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.
November 29, 2005 29 Nov'05
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.
June 28, 2005 28 Jun'05
Assembly permissions -- Who can catalog and use an assembly?

Learn about who can catalog and use assembly in SQL Server 2005 in this excerpt from "A First Look at SQL Server 2005 for Developers."

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

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
Copy-only backups: Another useful tool in SQL Server 2005

Copy-only backups of your database are a new option with SQL Server 2005. This useful backup tool doesn't interfere with your regularly scheduled backup sequences. If creating a spontaneous full backup is necessary, you'll avoid negative impacts to ... Continue Reading
Top 10 new features in SQL Server 2005

From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes well beyond. Edgewood Solutions' Jeremy Kadlec shares his SQL Server 2005 top 10 list. Continue Reading

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
Manage traces in SQL Server 2005 Analysis Services with XMLA commands

SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you ... Continue Reading

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

Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005

Understanding date/time data types in SQL Server can be difficult, especially when you add TIMESTAMP into the mix. In this tip, you'll learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as ... Continue Reading
How to configure Database Mail in SQL Server 2005 to send mail

Sending mail via SQL Server has become a much more reliable process. Here, SQL Server expert Roman Rehak explains how to configure Profiles and Accounts within the Database Mail architecture for sending and monitoring email. Continue Reading
How to use rank function in SQL Server 2005

SQL Server 2005 T-SQL includes a set of functions that let you rank the rows in your result set. SQL Server expert Robert Sheldon defines and gives examples of how to use the four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. Include ... Continue Reading