Microsoft SQL Server 2005

Email Alerts

Register now to receive news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQL Server Service Broker Tutorial and Reference Guide

    Discover the basics of the SQL Server Service Broker, including a general overview on how this addition to SQL Server works. 

  • Export SQL Server data to an Excel file using SSIS and Visual Studio

    Here are seven steps for transferring SQL Server 2005 data to a MS Excel spreadsheet. In this book chapter from the "Beginners Guide to SQL Server Integration Services Using Visual Studio 2005" by Jayaram Krishnaswamy, you'll learn how to design an S... 

  • Upgrading to SQL Server 2005 FAQs

    We've compiled a list of frequently asked questions to address your SQL Server 2005 upgrade issues, including working with DTS packages, copying databases, creating passwords and installing different SQL Server versions on one machine. 

  • Creating CLR database objects

    Get an overview of the process to manually create a CLR database object. Then go further and learn how to use the Visual Studio 2005 Professional, Enterprise, and Team System Editions, which all have tools that help create CLR database objects as wel... 

  • Developing CLR database objects: 10 tips, 10 minutes

    The integration of the .NET Framework's Common Language Runtime (CLR) with SQL Server 2005 is arguably the most significant new development featured in the SQL Server 2005 release. In this book excerpt, you'll learn about capabilities to create datab... 

  • CLR aggregates

    The CLR aggregate is another new type of .NET database object that was introduced in SQL Server 2005. Learn more in this chapter excerpt. 

  • CLR architecture

    The .NET Framework CLR is very tightly integrated with the SQL Server 2005 database engine. In fact, the SQL Server database engine hosts the CLR. This gives SQL Server 2005 several distinct advantages over the .NET integration that's provided by DB2... 

  • Debugging CLR database objects

    One significant feature found in the integration of .NET Framework, Visual Studio 2005, and SQL Server 2005 is the ability to debug the CLR database objects that you create. Find out more in this chapter excerpt. 

  • CLR stored procedures

    Stored procedures are one of the most common database objects that you'll want to create using one of the managed .NET languages. One of the best uses for CLR stored procedures is to replace existing extended stored procedures. Learn the best method... 

  • CLR assemblies in SQL Server 2005

    If you're familiar with ADO.NET, you may wonder exactly how CLR database objects connect to the database. Find out in this chapter excerpt, along with how to code to create a SQL Server assembly. 

  • See more Essential Knowledge on Microsoft SQL Server 2005
  • Microsoft reiterates promise of SQL Server 2005 SP3

    SQL Server 2005 database administrators and managers will be happy to know that a third service pack will be here shortly. 

  • SQL Server DBMS' growing popularity is no coincidence

    SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of using SQL Server over other... 

  • Q&A: Making the jump to 64-bit SQL Server 2005

    Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... 

  • Q&A: What's new in SQL Server 2005 SP1

    SQL Server 2005 Service Pack 1 offers DBAs production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and additional features to ease the pains of fully utilizing the new DBMS. We recently asked Microsoft prod... 

  • SQL Server 2005 SP1 ships

    SQL Server 2005's database mirroring functionality is finally here with the release of SQL Server SP1. 

  • Microsoft releases CTP for SQL Server SP1

    Community preview of SP1 for SQL Server 2005 includes new features, fixes. 

  • SQL Server 2005 Database Mirroring primer

    @18437 Since SQL Server 2000, you have been able to create a standby server using replication, log shipping and backup and restore -- but now Microsoft has introduced a built-in tool that enables automated failover. Database Mirroring is a new fe... 

  • Q&A: Making the jump to 64-bit SQL Server 2005

    Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... 

  • Free version of SQL Server 2005 tops list of downloads

    The five most popular picks on Microsoft's SQL Server downloads site include its free SQL Server 2005 Express, MSDE 2000 and the most recent service packs for SQL Server 2000. 

  • Free download expands features for SQL Server 2005

    The November SQL Server 2005 feature pack from Microsoft provides interoperability and backward-compatibility tools. 

  • See more News on Microsoft SQL Server 2005
  • Yukon

    Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, t... 

About Microsoft SQL Server 2005

Microsoft released SQL Server 2005 more than five years after SQL Server 2000 replaced SQL Server 7.0. The release features a multitude of improvements over its predecessor, including new better error recovery systems, indexing algorithms and native support for managing both relational and XML data. This Microsoft SQL Server 2005 topic page features resources dealing with the upgrade, migration and installation of Microsoft's SQL Server database management system. Do you want to learn about the new features and enhancements in SQL Server 2005? Take a look at these tips that go inside SQL Server 2005 on topics of development and database administration.