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

Impact of Reading from the Transaction Log

Impact of Reading from the Transaction Log

I read a book on data warehousing the other day. The author claimed reading from the transaction log had no impact on the source system. The author might have meant reading from the log doesn't have a significant impact. Reading…

Optimize Data Mining Models with doAzureParallel

Optimize Data Mining Models with doAzureParallel

Neural networks are an awesome modeling technique for finding complex patterns in our data. Most Neural Network R packages will have levers for customizing the model architecture. For example, the R package RSNNS (Stuggart Neural Network Simulator) contains a multi-augment…

Privacy Policy