Capture Custom Events in Profiler for Troubleshooting

User configurable events have been available in SQL Server since at least version 2000, but aren’t often used, I suspect just because DBA’s aren’t familiar with them. Here’s a screen shot of the Events Selection page of the Trace Properties for a SQL Server Profiler trace: Despite having all of the user configurable events selected,…


Get Rid of Deadlocks

Locks are used by relational database management systems to increase user concurrency (more users) while guaranteeing data consistency. A deadlock is when two locks interfere each other, and is caused by one process locking a row, page, partition, or table while it waits for another row, page, partition, or table to become available, but the one it’s…

4

Test SharePoint Mirror Without Down-Time

Here’s a ??SQL Server PFE war-story to give one example of one of the kind of work we might do. Most of the customers I support run SharePoint services, and they use a variety of methods to provide disaster recovery capabilities. One method involves SQL Server’s Database Mirroring capability to maintain a copy of the data at…


Installing SQL Server 2008 Services in a High-Security Domain

If you need to install the SQL Server 2008 Database Engine (SS08) or the SQL Server Reporting Services (SSRS) in a domain where some of the administrative privileges of the local administrator account have been removed, you may want to check 3 particular permissions, listed just below. Unfortunately, these permissions don’t get checked by the RTM (release-to-manufacturing)…

2