Recently, I was working on one of the performance tuning assignment with an esteemed client. The size of their databases were growing tremendously. Growth in the database size is...
2020-12-22 (first published: 2020-12-11)
626 reads
Reading execution plans in SQL Server is just hard. There’s a lot to learn and understand. I previously outlined the basics I use to get started when I’m looking...
2020-12-22 (first published: 2020-12-14)
663 reads
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,...
2020-12-21 (first published: 2020-12-14)
936 reads
I was just working on a new SQL job, and part of creating the job was adding a few new tables to our DBA maintenance database to hold data...
2020-12-21 (first published: 2020-12-11)
510 reads