Microsoft SQL Server 2005

Microsoft SQL Server 2005 News

  • April 28, 2016 28 Apr'16

    Database trends to watch after SQL Server 2005 end of life

    Two database industry experts discuss infrastructure and analytics trends to consider for database upgrades following the end of SQL Server 2005 extended support.

  • April 28, 2016 28 Apr'16

    Why SQL Server 2005 end of life is good news for DBAs

    Two database experts explain how to take advantage of the opportunity created by SQL Server 2005 end of life and how to build a better database.

  • May 26, 2006 26 May'06

    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 ...

  • January 24, 2006 24 Jan'06

    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 ...

Microsoft SQL Server 2005 Get Started

Bring yourself up to speed with our introductory content

Evaluate Microsoft SQL Server 2005 Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

  • Five sqlcmd features to automate SQL Server database tasks

    Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcmd commands, such as for utilizing and populating ... Continue Reading

  • New T-SQL features in SQL Server 2005

    Have you experienced the new T-SQL features in SQL Server 2005? SQL Server database administrator Eric Johnson outlines four of its hottest development features: error handling, ROW_NUMBER function, DDL triggers and CLR. Continue Reading

  • FAQ: SQL Server comparison features

    In this FAQ, our SQL Server experts answer your questions about comparison features in both SQL Server 2000 and SQL Server 2005. Have you wanted to know which data type to use, nvarchar or varchar when storing character information? Or, are you ... Continue Reading

Manage Microsoft SQL Server 2005

Learn to apply best practices and optimize your operations.

Problem Solve Microsoft SQL Server 2005 Issues

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.