Practical guides and insights for modern data practitioners
In this post I want to cover how to deploy SQLWATCH to SQL Server using Azure DevOps. Because I’ve started experimenting with it. In addition, I want to show you how you can do it directly from a GitHub repository. By the end of this post you will know how to deploy SQLWATCH to SQL … Read more
Since I’ve been giving some advice to others recently I thought I would share tips for dealing with large SQL Server scripts. Which are based on my own experiences over the years. Of course, we all have our own ideas about what a large SQL Server script is. Some people would say it’s hundreds of … Read more
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
Recently there’s been a few questions asked online about slow clustered index rebuilds within SQL Server for rowstore indexes. So, I thought I would cover some of the reasons that I have experienced here. In truth, some of these I discussed in a series I posted last year about maintaining larger SQL Databases better. You … Read more
Last year I did some posts about maintaining larger SQL Server databases better. Since then I have had to answer some questions on the SQLHelp hashtag on Twitter about information which is in these posts. So, I have decided to do this post as a quick recap about them to help others. Reading these posts … Read more
Introduction In this post I cover part 4 of a series about maintaining your larger databases better if you use SQL Server. It covers personally recommended free tools you can use. I decided to cover free tools because in general people prefer things that are free. With this in mind, I wanted to recommend ones … Read more
In this post I cover personally recommended SQL Server DMV’s, part 3 of a series about maintaining your larger databases better if you use SQL Server. I’ve done this post about personally recommended DMV’s because they can help you maintain your larger databases better. If you’ve yet to read the other parts of this series, … Read more
In this post I cover part 2 of a series about maintaining your larger databases better if you use SQL Server. It covers indexes. In my last post I covered some ways you can maintain your larger databases better. This post is the next in this series and covers indexes in more detail. So, here’s … 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