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)