We're sponsoring over 5 hours over 5 days of training on SSIS and Business Intelligence with Brian Knight, SQL Server MVP and founder of Pragmatic Works.   Read more...

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.   Read more...

Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.  Read more...

Build List Updated with Cumulative Update 8 for SP2.   Read more...

It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.  Read more...

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...

One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.  Read more...

Everyone has a set of handy utilities and tools that they use with their SQL Server, but sometimes convincing an employer to purchase tools is hard. Longtime DBA David Bird brings us a list of the tools he likes to use and are FREE.   Read more...

How a transaction log was deleted and then recreated.  Read more...

This article describes how to generate the sp_who2 results including the query text for the spid.  Read more...

Two useful functions for dealing with hierarchical data.  Read more...

Discusses the use of the newly introduced APPLY Statement in SQL Server 2005  Read more...

Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.  Read more...

Reduce your recovery time and minimize the chance for error by resolving all logins in one script.  Read more...

Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.   Read more...

This article is about using VBscript hacks to overcome two limitations of DTS packages.  Read more...

We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.   Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

Continuing on with his very popular series on monitoring your servers, David Bird takes a look at how you manage checking on multiple servers.  Read more...

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...