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

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

BCA KCP Pluit Raya Tlpn/Wa 0853.7373.7551

BCA KCP Sejati Mulia Telpon/WA:08137887595

BCA KCP Kramat Jaya Tlpn/Wa 0853.7373.7551

Question of the Day

Increase Deadlock Detection