Sometimes your DB is so big you need to initialize replication with a backup and restore instead of a snapshot. Here I show you Continue reading “Replication: Initialize with Backup”
Category: Other
Regex Word Boundaries
Here I’m going to show you how to use regex word boundaries. Word boundaries allow you to match entire words, or even words that Continue reading “Regex Word Boundaries”
Regex Lookarounds
In regex you can perform lookarounds to check for matches that don’t get consumed. These are zero-length assertions that merely report the match. Here Continue reading “Regex Lookarounds”
Find double words in regex
Here I show you how to use a backreference in regex to be able to find double words in regex. What you’ll learn how to do Continue reading “Find double words in regex”
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 to do it.
Here are the Continue reading “How to set PasswordNeverExpires for Office 365 Users”
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 go have some fun.
Find File Lock
Have you ever been plagued by a file you couldn’t delete or move because it was being held open by something else? Well here Continue reading “Find File Lock”
Monitoring SAN Space
Monitoring SAN Space.
Windows Crash Dump Analysis
If Windows has ever bluescreened on you, then you know how important it can be to find the issue. Windows creates a crash dump Continue reading “Windows Crash Dump Analysis”
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 it doesn’t matter. Here there’s Continue reading “Uninstall a CU in SQL Server 2008 R2”
Uninstalling SP1 in SQL2K8
SP1 is the first one that you can uninstall in SQL Server, so here I thought I’d take a look at the uninstall process and Continue reading “Uninstalling SP1 in SQL2K8”
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.
Katmai’s Search Feature
Here I explore Katmai’s new search feature.
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 worth it. And here I Continue reading “Cool New SSMS Features for DBAs”
SSMS Fast Load
Here I show you how to get SSMS to get SSMS to load a lot faster so you don’t have to wait.
When did SQL Server Start?
Find out 2 ways to tell when SQL Server started.
Using ServerProperty
Here I show you the benefit of using ServerProperty() instead of @@Version to find the version of SQL Server you’re on.
Troubleshoot DB Connection with Telnet
Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect. Using telnet you can tell pretty clearly Continue reading “Troubleshoot DB Connection with Telnet”