giveaway

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Ken Simmons

google plus

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 Consistency Checks DBCCs

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

Database Design

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

Database Mail

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

Dynamic SQL

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

Functions - System

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

Import and Export

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

Indexing

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

Monitoring

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

Partitioning

Identify Overloaded SQL Server Partitions (5/19/2010)

Performance Tuning

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

Policy Based Management

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

Professional Development Books

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

Restore

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

Scripts

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

SQL Server Agent

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

SQL Server Management Studio

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

Surface Area Configuration Manager

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

More SQL Server Solutions