John Sterrett

John Sterrett is a Database Administrator and Software Developer who has over five years of experience within Information Technology. My area of expertise includes data modeling, database design, database administration and developing data driven applications and services.

Blog: http://www.johnsterrett.com
Twitter: http://twitter.com/johnsterrett

Central Management Servers

SQL Server Central Management Server Security (last update: 6/20/2011)

Dates

Convert SQL Server DateTime Data Type to DateTimeOffset Data Type (last update: 2/23/2011)

Install and Uninstall

Uninstalling a SQL Server Clustered Instance (last update: 11/26/2010)

Policy Based Management

Monitor SQL Server Agent Jobs with Policy Based Management (last update: 12/27/2010)

Profiler and Trace

Use SQL Server Profiler to trace database calls from third party applications (last update: 6/16/2010)

Table Valued Parameters

Table Value Parameters in SQL Server 2008 and .NET (C#) (last update: 9/13/2010)

Testing

SQL Query Stress Tool (last update: 7/18/2012)

Upgrades and Migrations

Migrating a VLDB in SQL Server with Log Shipping (last update: 7/29/2010)