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

Implementing searching in your database is always a challenge and MVP Michael Coles brings us a method of building a Google-like search for SQL Server.  Read more...

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.  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...

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

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

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...

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

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...

Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.  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...

A short description of requirements to fully utilize the indexes on views.  Read more...

Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.  Read more...

Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.  Read more...

This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.  Read more...

I have often needed a means to send zipped files via email. This article shows one method to do just this.  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...

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

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