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.

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

• 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)
  

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

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

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

• 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)
  

• 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)
  

• Script to determine free space to support shrinking SQL Server database files (last update: 1/8/2020)
  

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

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

• 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)
  

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

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

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

• 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)
  

• 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)
  

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