Chad Boyd

Chad is an Architect, Administrator, and Developer with technologies such as Sql Server (and related technologies), .NET, Windows Server, and the Microsoft Clustering stack (MSCS, NLB, HPC). After nearly 5 years at Microsoft in a variety of roles related to pushing the limits of the Microsoft stack in many of the largest, most complex Sql Server installations in the world, he now provides consulting to many different customers and clients ranging from startup to Fortune 50. Most recently he has been spending much of his time as an architect at SpruceMedia, Inc., a startup firm in the Facebook/Social Advertising space (http://sprucemedia.com) and resides in the Redmond, WA area where he also spends a significant amount of time writing, talking, presenting and blogging about the data-related technologies on the Microsoft stack. Chad regularly posts Sql Server related content, tools, and advice with the MSSQLTips team at http://www.mssqltips.com/author.asp?authorid=2 and on stackoverflow.com athttp://stackoverflow.com/users/169012/chadhoc. Chad can be contacted via his blog or email at chad dot boyd dot tips at gmail dot com.

2013 Awards

2007 Awards
MSSQLTips award

Backup

Large log backups with bulk operations and read only databases (last update: 10/15/2007)

Clustering

SQL Server Cluster Configuration Checklist (last update: 6/28/2008)
SQL Server Cluster Node Configuration Checklist (last update: 6/28/2008)
SQL Server Configuration Checklist (last update: 6/28/2008)
SQL Server Disk Configuration Checklist (last update: 6/29/2008)
SQL Server Post Cluster Configuration Checklist (Part 2 of 4) (last update: 6/29/2008)
SQL Server Post SQL Installation Checklist (Part 4 of 4) (last update: 6/29/2008)
SQL Server Pre Cluster Installation Checklist (Part 1 of 4) (last update: 6/29/2008)
SQL Server Pre SQL Installation Checklist (Part 3 of 4) (last update: 6/29/2008)

Comparison Data and Objects

Sort and compare SQL Server unicode and binary data results (last update: 10/15/2007)

Compression

Estimating Data Compression ratios for all (last update: 9/22/2008)
SQL Server 2008 Data Compression and Backup Compression (last update: 10/15/2007)

Data Types

Row sizes exceeding 8060 bytes in Sql 2005 (last update: 10/15/2007)

Database Administration

How does AUTO_UPDATE_STATISTICS_ASYNC work with Sql 2005? (last update: 10/15/2007)
SQL Server 2008 Transaction Logging Enhancements (last update: 5/20/2008)
SQL Server SERIALIZABLE isolation level and duplicate key insertion attempts (last update: 10/15/2007)

Database Mirroring

Dynamic Management Views and Functions

Buffer Pool Space in SQL Server 2005 (last update: 2/26/2007)
Determine objects consuming the largest amount of space in the SQL Server buffer pool (last update: 10/15/2007)
SQL Server Resource Database Values in DMVs (last update: 2/16/2007)

Fragmentation and Index Maintenance

Custom SQL Server Index Defrag and Rebuild Procedures (last update: 3/9/2008)
SQL Server Fragmentation Custom Detection Procedure, Page Linkage Part 7 (last update: 2/22/2008)
SQL Server Fragmentation Hands On Experience (Part 9 of 9) (last update: 3/1/2008)
SQL Server Fragmentation How to address it (Part 8 of 9) (last update: 2/23/2008)
SQL Server Fragmentation How to avoid it (Part 4 of 9) (last update: 2/13/2008)
SQL Server Fragmentation How to detect it (Part 6 of 9) (last update: 2/22/2008)
SQL Server Fragmentation Storage basics and Access Methods Part 1 of 9 (last update: 11/12/2007)
SQL Server Fragmentation What causes it (Part 3 of 9) (last update: 2/7/2008)
SQL Server Fragmentation What it impacts and what it does not Part 5 of 9 (last update: 2/17/2008)
SQL Server Fragmentation What it is, what types there are Part 2 of 9 (last update: 11/28/2007)

Hardware

SSD and Me (last update: 3/12/2008)
SSD and SQL Server Fragmentation Impact (last update: 4/7/2008)
SSD and SQL Server SQLIO performance (last update: 3/16/2008)

Identities

Gaps in SQL Server Identity Columns (last update: 3/2/2007)

Indexing

How can I get sysindexes information in Sql 2005? (last update: 10/15/2007)
Index System Tables in SQL Server 2000 vs SQL Server 2005 (last update: 3/29/2007)
Non Unique Clustered Index and Duplicate Value limits (last update: 10/15/2007)
Tracking index maintanence information (last update: 10/15/2007)
What indexes are used most often (or least often) on my server? (last update: 10/15/2007)

Install and Uninstall

Installation and Configuration Outline (last update: 6/28/2008)
Service Pack 2 Uninstall Not Possible for SQL Server 2005 (last update: 2/23/2007)

Licensing

SQL Server 2005 CPU Licensing with Multi Core Technology (last update: 1/26/2007)

Maintenance

AUTO_UPDATE_STATISTICS_ASYNC SQL Server Database Configuration (last update: 3/6/2007)

Monitoring

sp_who for Sql 2005 (sp_who2k5) (last update: 10/15/2007)

Partitioning

Partitioning SQL Server Data for Query Performance Benefits (last update: 3/19/2008)

PowerShell

Invoke Nz Powershell script similar to Nz VBA function (last update: 7/26/2009)
Restore-SqlDb Automate a SQL Server Database Restore improved with Powershell (last update: 10/12/2008)
Try Catch Finally with Powershell (last update: 10/4/2008)

Professional Development Interview Questions DBA

SQL Server DBA Concurrency and Locking Interview Questions (last update: 5/29/2007)
SQL Server DBA Interview Questions Part 1 (last update: 7/5/2007)
SQL Server DBA Interview Questions Part 2 (last update: 7/9/2007)
SQL Server DBA Interview Questions Part 3 (last update: 7/18/2007)

Replication

Monitor SQL Server replication latency using tracer tokens (last update: 10/24/2007)

Restore

Automate a Database Restore (last update: 7/29/2008)

Security

How to determine service related privileges for Sql Server service account (last update: 10/15/2007)
SQL Server Service Account Privileges (last update: 2/20/2007)

SQL Server Configurations

PAE and 3GB and AWE oh my (last update: 10/15/2007)
Sql 2005 Dynamic Memory Managment with AWE enabled (last update: 10/15/2007)
What is a hobt_id in Sql 2005? (last update: 10/15/2007)

T-SQL

Nullability settings with select into and variables (last update: 9/10/2009)
SQL Server 2008 consume output directly from the OUTPUT command (last update: 10/31/2007)
SQL Server 2008 Group By Sets (last update: 10/15/2007)
SQL Server 2008 Inline variable initialization and Compound assignment (last update: 10/15/2007)
SQL Server 2008 MERGE More than UPSERT (last update: 11/1/2007)

Upgrades and Migrations

Energy Policy Act of 2005 Implications on SQL Server (last update: 1/23/2007)
SQL Server 2008 Features, Function and Value (last update: 8/21/2007)
SQL Server 2008 List of New Features (last update: 10/15/2007)

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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Chad Boyd

More SQL Server Solutions