Microsoft SQL Server 2005

New & Notable

Download this free guide

Free Guide: DBMS Features Overview for 3 New Popular Options

IT expert Michael Otey, explores 5 trends for SQL Server environments, what to expect in SQL Server 2019 and why it might be time to update SQL Server skills. Also, compare the key features of Google Cloud Spanner and Oracle Database 19c.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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

Microsoft SQL Server

Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments Continue Reading
Quick start tips for using the new MSSQL-CLI SQL query tool

The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows. Continue Reading
Microsoft SQL Server Management Studio (SSMS)

Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure. Continue Reading

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.

SQL Server 2005 end of life is closing in: Are you ready?

Extended support for SQL Server 2005 ends in April. That's it. It's done. If your organization isn't prepared, your data could be at risk, cautions expert Robert Sheldon. Continue Reading
Five steps for a successful backup of a stored procedure in SQL Server

Follow these steps to use Management Studio for SQL 2005 for a successful SQL Server stored procedure backup. Continue Reading
Should you upgrade to SQL Server 2005 or SQL Server 2008?

Even though SQL Server 2005 was released almost three years ago, many companies haven't upgraded yet. With last week's release of SQL Server 2008, it's time to put some serious thought into an upgrade. SQL Server expert Roman Rehak examines the ... Continue Reading

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.

SQL Server consolidation: Why it's an optimization technique

SQL Server consolidation -- a.k.a., the fix for SQL Server sprawl -- provides ease of management, improved availability and lower licensing costs. Continue Reading
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX

Retrieving a hierarchy with recursive relationships in SQL can get difficult to manage -- very quickly. Learn how to easily implement this type of relationship with a parent-child dimension using Microsoft's Analysis Services MDX. Continue Reading
SSIS error message due to installation problem on SQL Server 2005

If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools. Continue Reading