solving sql server problems for millions of dbas and developers since 2006

Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Product Highlight

Idera - SQL safe backup

Idera's SQL safe provides a high-performance backup and recovery solution for Microsoft SQL Server. SQL safe saves money by reducing database backup time by up to 50% over native backups and reducing backup disk space requirements by up to 95%. SQL safe also enables complete "hands-free" automated backup of your entire SQL Server infrastructure and ensures compliance with your organization's backup and recovery policies. From implementations with tens of SQL servers to enterprises with hundreds of servers spread around the globe, SQL safe is the only SQL Server backup and recovery solution th

Learn more!

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.

Backup and Recovery

Automate a Database Restore (7/29/2008)
Estimating Data Compression ratios for all (9/22/2008)
Large log backups with bulk operations and read only databases (10/15/2007)

Clustering

Outline, Checklists, Document Sheets for Installing Clustered SQL Servers (6/29/2008)
Sample Completed Info Sheets for a SQL Server Cluster (6/29/2008)
SQL Server Cluster Configuration Checklist (6/28/2008)
SQL Server Cluster Node Configuration Checklist (6/28/2008)
SQL Server Configuration Checklist (6/28/2008)
SQL Server Disk Configuration Checklist (6/29/2008)
SQL Server Post Cluster Configuration Checklist (Part 2 of 4) (6/29/2008)
SQL Server Post SQL Installation Checklist (Part 4 of 4) (6/29/2008)
SQL Server Pre Cluster Installation Checklist (Part 1 of 4) (6/29/2008)
SQL Server Pre SQL Installation Checklist (Part 3 of 4) (6/29/2008)

Data Management

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

Data Types

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

Database Configurations

How does AUTO_UPDATE_STATISTICS_ASYNC work with Sql 2005? (10/15/2007)
SQL Server SERIALIZABLE isolation level and duplicate key insertion attempts (10/15/2007)

Database Mirroring

Login failures connecting to new principal after SQL Server Database Mirroring failover (1/29/2007)

Dynamic Management Views and Functions

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

Fragmentation and Index Maintenance

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

Hardware

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

Identities

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

Indexing

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

Install and Uninstall

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

Interview Questions DBA

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

Licensing

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

Maintenance

AUTO_UPDATE_STATISTICS_ASYNC SQL Server Database Configuration (3/6/2007)

Partitioning

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

PowerShell

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

Replication

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

Security

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

Service Packs and Patches

Energy Policy Act of 2005 Implications on SQL Server (1/23/2007)

SQL Server 2008

SQL Server 2008 consume output directly from the OUTPUT command (10/31/2007)
SQL Server 2008 Data Compression and Backup Compression (10/15/2007)
SQL Server 2008 Features, Function and Value (8/21/2007)
SQL Server 2008 Group By Sets (10/15/2007)
SQL Server 2008 Inline variable initialization and Compound assignment (10/15/2007)
SQL Server 2008 List of New Features (10/15/2007)
SQL Server 2008 MERGE More than UPSERT (11/1/2007)
SQL Server 2008 Transaction Logging Enhancements (5/20/2008)

SQL Server Configurations

What is a hobt_id in Sql 2005? (10/15/2007)

SQL Server Configurations Memory

PAE and 3GB and AWE oh my (10/15/2007)
Sql 2005 Dynamic Memory Managment with AWE enabled (10/15/2007)

System Stored Procedures

sp_who for Sql 2005 (sp_who2k5) (10/15/2007)

T-SQL

Nullability settings with select into and variables (9/10/2009)

Sponsor Information

Try the free performance monitoring tool from Idera!

Web-based SQL Server monitoring whenever, wherever.

SQL Server Issues? Not sure where to turn for answers? Innovative SQL DBA consultants

Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now.

Free web casts for DBAs and Developers on Performance Tuning, Development, Administration and more....

Copyright (c) 2006-2012 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com