Recent Posts

Calculating Some Max Mirror Stats

less than 1 minute read

This turned out to be quite a challenge. I couldn’t find anything that made this very clean and straight forward to calculate, and in my case I was trying to...

Transaction Logging & Recovery (part 3)

5 minute read

Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log.

Verifying Instant File Initialization

1 minute read

Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but found out that running the xp_c...

Transaction Logging & Recovery (part 2)

3 minute read

… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please co...

Model needs exclusive lock

less than 1 minute read

Ran into an issue where a developer was trying to create a database and was denied due to no ability to obtain exclusive lock on model. After verifying with ...