Other
Replication: Initialize with Backup
Sometimes your DB is so big you need to initialize replication with a backup and restore instead of a...
Regex Word Boundaries
Here I’m going to show you how to use regex word boundaries. Word boundaries allow you to match entire...
Regex Lookarounds
In regex you can perform lookarounds to check for matches that don’t get consumed. These are zero-length assertions that...
Find double words in regex
Here I show you how to use a backreference in regex to be able to find double words in...
How to set PasswordNeverExpires for Office 365 Users
In O365 you can only set a user password to never expire using powershell. Here I show you how...
Optimize For Adhoc Workloads
There’s a lovely sp_configure option that can help you keep the size of your plan cache under control. Let’s...
Find File Lock
Have you ever been plagued by a file you couldn’t delete or move because it was being held open...
Windows Crash Dump Analysis
If Windows has ever bluescreened on you, then you know how important it can be to find the issue....
Uninstall a CU in SQL Server 2008 R2
Here I’ll show you how to uninstall a CU from SQL Server 2008 R2, CU5 to be specific, but...
Uninstalling SP1 in SQL2K8
SP1 is the first one that you can uninstall in SQL Server, so here I thought I’d take a...
Troubleshoot Missing DB File
Come with me on a quick trip to see how to troubleshoot a missing database file.
Katmai Server Group Management
Learn how to use the new group server mgmt functionality in the Katmai SSMS.
Cool New SSMS Features for DBAs
I give MS a hard time sometimes so I like to give them props when I find something really...
SSMS Fast Load
Here I show you how to get SSMS to get SSMS to load a lot faster so you don’t...
Using ServerProperty
Here I show you the benefit of using ServerProperty() instead of @@Version to find the version of SQL Server...
Troubleshoot DB Connection with Telnet
Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect. Using...