After a very popular first article on tools for the DBA, David Bird is back with a list of some utilities you might find very handy for working with SQL Server.  Read more...

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.  Read more...

Some tips on what to do when you inherit a database that you've never worked on before   Read more...

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.  Read more...

Read more...

New and old DBAs alike can benefit from going back to the roots of the profession. This series of articles highlight the skills needed to move to the next level of Database Administration.  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...

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  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...

SQL Server MVP and SSIS guru, Andy Leonard, discusses Integration Services and some of the tasks and containers that he uses quite often.  Read more...

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.   Read more...

How to have SQL Server drive Excel spreadsheets  Read more...

Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.  Read more...

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.  Read more...

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...

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

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.  Read more...

Deploying changes to your SQL Servers can be a challenge. Longtime SQL Server expert David Poole brings us a new article looking at a solution using SQLCMD.  Read more...