You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.

Top five tips for SQL Server developers

by Additional Articles

SearchSQLServer

T-SQL

Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.

Basically Available, Soft State, Eventually Consistent

by Phil Factor

SQLServerCentral.com

Database Weekly

The use of non-relational databases is a fascinating topic but they will remain special-purpose and are not competing with SQL-based relational databases.

No Google

by Steve Jones

SQLServerCentral.com

Editorial

Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.

Database Mirroring in SQL Server 2008

by Additional Articles

Database Journal

Database Mirroring

Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.

No Google

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.

No Google

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.

No Google

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.

Shrinking the Log

by Steve Jones

SQLServerCentral.com

Blogs

It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to be close to the time when I need a cut-and-paste snippet stored in a file I can pull out for my standard "it is recommended that you...

Transfer Logins Task and Transfer Database Task in SSIS

by Additional Articles

SQL Server Performance

Integration Services (SSIS)

The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.

Service Pack 2 Uninstall Not Possible for SQL Server 2005

Top five tips for SQL Server developers

Basically Available, Soft State, Eventually Consistent

No Google

Database Mirroring in SQL Server 2008

No Google

No Google

No Google

Shrinking the Log

Transfer Logins Task and Transfer Database Task in SSIS

Blogs

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

A Fabric solution can be very cost effective

Track SQL Server Configuration Changes Using the Error Log

Forums

We Are Eating Our Own Seed Corn

Before Using AI with Business Data, Read This

Designing SQL Server ETL Pipelines That Don't Break at Scale

Question of the Day

Detecting Deadlocks Quickly