My notes from SQL PASS 2009 Summit in Seattle: why I went, from networking to putting faces to names, and links to my posts from all four days.
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
A full walk through Policy Based Management in SQL Server 2008: the policy framework, facets and conditions, then creating, evaluating and fixing policies.
The Implicit Conversion That Quietly Kills Your Index
Find an implicit conversion in your SQL Server plan, understand which value changes type, and match application parameters to indexed columns.
SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.
SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Why is SQL Server Agent starting before SQL Server Engine service? A user group member asked me, and here are my quick reasons, from jobs to OS tasks.
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
Is there any real world reason to list a missing identity in a table? Readers had no new script, but a lively discussion on whether gaps matter.
SQLAuthority News – Interview with SQL Server MVP Glenn Berry
My interview with SQL Server MVP Glenn Berry, Database Architect at NewsGator and longtime SQL Server teacher at University of Denver.