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: 1/8/2020)
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)