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
and on stackoverflow.com
at http://stackoverflow.com/users/169012/chadhoc.
Chad can be contacted via email at chad
dot boyd dot tips at gmail dot com.
2013 Awards
2007 Awards
2013 Awards

2007 Awards

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
- Login failures connecting to new principal after SQL Server Database Mirroring failover (last update: 1/29/2007)
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
- 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)