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

Build List Updated with Cumulative Update 7 for SP2.   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...

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

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

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

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

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

Security was a major focus of SQL Server 2005 during its development, both in terms of making the product secure as well as enhancing the options. Security expert Brian Kelley brings us a look at how the paradigm of logins has changed and what you need to look for in SQL Server 2005.   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...

Steve Jones continues with his look at how SQL Server 2005 differs from SQL Server 2000, this time tackling the differences from a developer perspective.   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...

Row Level Version is one of the most coolest features introduced by SQL 2005.  Read more...

Buck Woody examines examines some of the decisions you'll need to make when embarking on your DBA career, and some the character traits and skills that will help you succeed and progress.  Read more...

SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.  Read more...

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

Discusses Index Selection impact when functions are wrapped around WHERE clause filtering columns  Read more...

This article describes one method of implementing a reporting system in SQL Server 2005  Read more...

Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new tricks with NULLs.   Read more...