Create a professional looking HTML table from T-SQL, not SSRS.  Read more...

Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.   Read more...

In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.  Read more...

Stellar Phoenix SQL Database Recovery Software Review  Read more...

Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.   Read more...

This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.  Read more...

Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.  Read more...

On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.  Read more...

Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.  Read more...

Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands   Read more...

Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...  Read more...

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...  Read more...