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.
Title Category Date
Scan a SQL Server Database for Objects and Columns Scripts2026-05-10
The Many Uses of Coalesce in SQL Server Functions System2022-09-30
SQL Server Sparse Columns Identifying Columns For Conversion Database Design2022-01-14
Script to find free space for shrinking SQL Server database files Monitoring2020-01-08
Finding SQL Server Deadlocks Using Trace Flag 1222 Performance Tuning2010-10-05
Renaming SQL Server Policy Based Management Policies Policy Based Management2010-09-08
Using Mandate Database with SQL Server Policy Based Management Policy Based Management2010-08-18
Understanding and Examining the Uniquifier in SQL Server Indexing2010-08-03
Configuring Alerts for SQL Server Policy Based Management Policy Based Management2010-07-06
Using Hints To Test SQL Server Indexes Indexing2010-06-24
Use Caution Altering Tables with SQL Server Management Studio SQL Server Management Studio2010-06-03
Identify Overloaded SQL Server Partitions Partitioning2010-05-19
Enabling a Fail Safe Operator in SQL Server Agent SQL Server Agent2010-05-07
Ensure SQL Server Data Purity Checks are Performed Database Console Commands DBCCs2010-04-20
Manipulating Multiple Objects in SQL Server Management Studio SQL Server Management Studio2009-12-30
SQL Server Database Mail Cleanup Procedures Database Mail2009-04-17
Where is the Surface Area Configuration tool in SQL Server 2008 Surface Area Configuration Manager2009-01-26
Simple way to export SQL Server data to Text Files Import and Export2008-11-24
Generate SQL Agent Job Schedule Report SQL Server Agent2008-11-07
Auto generate SQL Server restore scripts after each backup completes Restore2008-10-23
Run a Dynamic Query against SQL Server without Dynamic SQL Dynamic SQL2008-08-26
Using SQL Servers OPENROWSET to break the rules Import and Export2008-07-30
Create SQL Server Data Dictionary in Seconds Database Design2008-05-15