Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!

What's Your Downtime?

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones talks about downtime. Do you know what yours is?

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

by Additional Articles

SimpleTalk

FIFO

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor's SQL Speed Phreak challenge produced some memorable code, but can SQL features introduced since then help to produce code that performs as well and is also easy to understand? Kathi Kellenberger investigates.

Data Mining Part 37: The Data Mining query transformation task

by Daniel Calbimonte

SQLServerCentral.com

This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task

Successful Projects

by Steve Jones

SQLServerCentral.com

Editorial

What makes a successful software project? Steve Jones has some thoughts.

What is Code Coverage For?

by Additional Articles

SQLServerCentral

code coverage

Code coverage is a practice that goes hand in hand with automated testing, reporting the percentage of your code that has been exercised during a test run. Ed Elliott and Redgate have partnered to make a code coverage tool available for SQL Server, both free and open source. SQL Cover measures the coverage of your SQL Server stored procedures and functions. It has built-in support for the popular tSQLt unit testing framework, but can also be used alongside any automated testing framework of your choosing. Find out more in this blog post.