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

A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!  Read more...

Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.  Read more...

SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.  Read more...

Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.  Read more...

Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.  Read more...

Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits.  Read more...

A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010  Read more...

This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.  Read more...

Why are they here? Why is anyone?  Read more...