Recent Posts

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 ...

Documenting Your Database with Diagrams

6 minute read

Don’t get too excited. I know you love documentation, and just can’t wait to spend some time digging in to document your database thoroughly. I imagine you p...