Reading Time: 5 minutes 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,…
A blog about Microsoft Data Platform offerings
Category: SQL Performance Tuning
Performance Tuning SQL Server
Reading Time: 6 minutes 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…
Reading Time: 4 minutes 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…
Reading Time: 3 minutes 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…
Reading Time: 2 minutes 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…
Reading Time: 4 minutes 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…
Reading Time: 5 minutes 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…
Reading Time: 4 minutes 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…
Reading Time: 4 minutes 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…