Tara Kizer 
Featured image photo by alexey turenkov on Unsplash A client reached out for help with a performance problem that had been going on for over a day. The application was performing so slowly that it was nearly an outage to their users. I love working on production emergencies where there’s a severe performance problem. I … Read more
IMPORTANT NOTE: This requires SQL Server 2017 or newer, Query Store and Enterprise/Developer edition. In SQL Server 2016, we were given the Query Store feature, and all the perf tuners rejoiced. Finally we had a great tool to help us with SQL Server parameter sniffing issues. These days, any time I work on a parameter … Read more
If you’re still on SQL Server 2008/2008 R2, you’re missing out on some great features. It’s no secret that Availability Groups are my favorite feature since SQL Server 2012. Back in the day, I was supporting complex environments with aggressive SLAs. On one particular system, I had Failover Clustering for HA, Asynchronous Database Mirroring for … Read more