Practical guides and insights for modern data practitioners
I thought for a couple of blog posts I would write a fictional tale about lessons learned by a time travelling SQL Server DBA. Because at the start of a new year people tend to look into the past and the future. I decided it would be a good idea to cover some topics in … Read more
Introduction In this post I cover part 1 of a series about maintaining your larger databases better if you use SQL Server. In reality, it’s based on things that I have seen over the years. One reason I’ve decided to do this is because I have noticed that some teams try to use one solution … Read more
In this post I want to cover fixing some of the problems caused when you introduce rowstore filtered indexes. Because issues can occur. In addition, in a past post here I did an overview of different index types. I said in that post that I think filtered indexes could be more popular. Some of you … Read more