Monthly Archives: November 2010

Execution Extract, Transform, and Load your Data Warehouse

October 22, 2009 – Execution Extract, Transform, and Load your Data Warehouse by Jessica M. Moss. One data warehouse buzzword that often gets used is “ETL”, also known as extract, transform, and load. But what does this really mean from … Continue reading

Posted in Past Meetings | Comments Off

Execution Plan Caching and Reuse

August 27, 2009 – Execution Plan Caching and Reuse by Alejandro Mesa presents. In this presentation, Alejandro is going to talk about how batches are cached and reused (SS 2005 / 2008), and a review of best practices on maximizing … Continue reading

Posted in Past Meetings | Comments Off

Inside SQL Server 2008 Resource Governor

July 16, 2009 – Inside SQL Server 2008 Resource Governor by Aaron Bertrand. In this presentation, Aaron will provide an overview of Resource Governor, a new feature in SQL Server 2008 that will give DBAs and system administrators much more … Continue reading

Posted in Past Meetings | Comments Off

Inside SQL Server Policy-Based Management

May 28, 2009 – Inside SQL Server Policy-Based Management by Geoff Hiten. This meeting explained how to scale your DBA efforts across an entire SQL Infrastructure. Policy-based management is a new tool in the SQL Server product that allows you … Continue reading

Posted in Past Meetings | Comments Off

DTS to SSIS

March 17, 2009 – DTS to SSIS by Brian Knight. The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles … Continue reading

Posted in Past Meetings | Comments Off