By Frank Solomon, 02/19/2009
Use this custom tool to create a numbers table that works around nearly all the limitations that traditional techniques for building these tables usually involve.
By Kevin Kline, 02/18/2009
This free tool’s robust logging lets you quickly figure out why a SSIS package that was executing correctly suddenly isn’t.
By William Vaughn, 02/17/2009
See what Microsoft changed in SQL Server Reporting Services 2008 and how these new features will affect you.
By William Vaughn, 02/16/2009
A confusing array of Report Designers is available to SQL Server Reporting Services developers. Here's a list of the versions and what they support.
By William Vaughn, 02/16/2009
Visual Studio 2008 SP1 enables many features that didn’t make the cut in the initial Visual Studio 2008 release to manufacturing (RTM). Learn about SP1 reporting and data caching ...
By William Vaughn, 02/16/2009
A free utility, Reporting Services Scripter, can help you export SQL Server Reporting Services 2008 reports.
By Andrew J. Kelly, 02/11/2009
Are you using SQL Server's CLR functionality to parse trace files? Microsoft recently updated its RML Utilities, and you might find them easier to use—and a great benefit to your ...
By Michael K. Campbell, 02/03/2009
Deriving useful business intelligence from multidimensional data hasn't been easy—until now.
By Michael Otey, 01/14/2009
Microsoft’s AdventureWorks series of sample SQL Server databases is now available at its open-source website CodePlex—which is where you can find these 7 great downloads, plus ...
By Anne Grubb, 10/17/2008
Database backup and performance tuning are top-of-mind topics for SQL Mag online readers.
By Michael K. Campbell, 10/10/2008
For generating sample and testing data for SQL server databases, this product will win you over as quickly as it produces data.
By Michelle A. Poolet, 05/28/2008
Back up your SQL Server databases regularly to prevent lost data in the event of a disaster.