Enable Team Connections in SSMS

Enable Team Connections in SSMS

As business requirements change I need to update post server installation scripts. A mistake in these scripts can cause major issues down the road, thus it's important to version control. One small hinderance of SSMS version 17 - 17.5…

Manage a trace session using T-SQL

Manage a trace session using T-SQL

After news of the Meltdown and Specter vulnerabilities hit I needed to understand the performance impact. I performed a series of benchmark tests and found myself using SQL Server profiler extensively. It quickly became apparent the overhead introduced by the…

Flush a Bad Query Plan

Flush a Bad Query Plan

I recently worked on a system with performance issues. Under load I found CPU would spike for a two minute stretch to 100% and then back a healthy 30% for five minutes and then back to 100% for two minutes.…

Privacy Policy