Ken Simmons

Ken Simmons

Ken Simmons is a database administrator, developer, and Microsoft SQL Server MVP. He is the Author of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010). He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005.

Database Console Commands DBCCs

Ensure SQL Server Data Purity Checks are Performed (last update: 4/20/2010)

Database Design

Create a SQL Server Data Dictionary in Seconds using Extended Properties (last update: 5/15/2008)
SQL Server 2008 Sparse Columns Identifying Columns For Conversion (last update: 12/4/2008)

Database Mail

SQL Server Database Mail Cleanup Procedures (last update: 4/17/2009)

Dynamic SQL

Run a Dynamic Query against SQL Server without Dynamic SQL (last update: 8/26/2008)

Functions - System

The Many Uses of Coalesce in SQL Server (last update: 6/17/2008)

Import and Export

Simple way to export SQL Server data to Text Files (last update: 11/24/2008)
Using SQL Servers OPENROWSET to break the rules (last update: 7/30/2008)

Indexing

Understanding and Examining the Uniquifier in SQL Server (last update: 8/3/2010)
Using Hints To Test SQL Server Indexes (last update: 6/24/2010)

Monitoring

Script to determine free space to support shrinking SQL Server database files (last update: 6/2/2008)

Partitioning

Identify Overloaded SQL Server Partitions (last update: 5/19/2010)

Performance Tuning

Finding SQL Server Deadlocks Using Trace Flag 1222 (last update: 10/5/2010)

Policy Based Management

Configuring Alerts for SQL Server Policy Based Management (last update: 7/6/2010)
Renaming SQL Server Policy Based Management Policies (last update: 9/8/2010)
Using Mandate Database with SQL Server Policy Based Management (last update: 8/18/2010)

Professional Development Books

Pro SQL Server 2008 Policy Based Management (last update: 7/21/2010)

Restore

Auto generate SQL Server restore scripts after each backup completes (last update: 10/23/2008)

Scripts

Scan a SQL Server Database for Objects and Columns Containing a Given Text Value (last update: 6/20/2008)

SQL Server Agent

Enabling a Fail Safe Operator in SQL Server Agent (last update: 5/7/2010)
Generate SQL Agent Job Schedule Report (last update: 11/7/2008)

SQL Server Management Studio

Be Cautious Altering Tables Using SQL Server Management Studio SSMS (last update: 6/3/2010)
Manipulating Multiple Objects in SQL Server Management Studio (last update: 12/30/2009)

Surface Area Configuration Manager

Where is the Surface Area Configuration tool in SQL Server 2008 (last update: 1/26/2009)

More SQL Server Solutions

download

get free sql tips