Recent Posts

TFS Work-Item Fancy Filtering

less than 1 minute read

If you want to create a TFS query that would identify work items that have changed, but were not changed by the person working it, there is a nifty way to do...

Previewing the new SSRS 2016 portal

less than 1 minute read

Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a not found error.

Failover all databases to other server

less than 1 minute read

Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way I want to click that darn Fail-over butto...

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.