Practical guides and insights for modern data practitioners
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
In this post I will cover fixing some of the problems caused when you first introduce Columnstore indexes to a SQL Server database. Because in my last post I talked about fixing some of the problems caused when you introduce rowstore filtered indexes. Before we start I’d just like to point out I’m not going … 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
In this post I want to cover a couple of things to watch out for if deploying Power BI Report Server. So that it helps others who may encounter issues. A while back I wrote about how SQL Server DBA’s can make use of Power BI Report Server here. Therefore, I thought I better write … Read more
Hello and welcome to my T-SQL Tuesday contribution for this month about relearning Linux. For those of you who want to know more about this months T-SQL Tuesday you can click here. In the beginning It all started when a previous employer was looking to implement a Hadoop solution. I got involved and looked at … Read more
In this post I want to cover useful SQL Server related PowerShell Modules for the DBA. With this in mind, lets start with the one which is probably the most common module. SQLServer First of all, lets clear one thing up. To clarify, the SQLServer PowerShellmodule is the replacement for the old PSSQL module. So, if … Read more
Intro Since it’s Halloween this week I thought I would cover a true SQL Server horror story in this post, zombie spids. What are zombie spids? Well they are basically spids that continue to run and however you try to kill them whilst SQL Server is running they will not die. To avoid any confusion … Read more
For this post I want to cover how SQL Server DBA’s can use Power BI Report Server. So that others have ideas on how to use it. In a previous post I went through a quick introduction of Power BI Report Server. With this in mind, I have decided to do a follow up on … Read more
Introduction I want to do a unique review of SQL Server index types in this post. In order to help raise awareness about some of them. Because one thing I have noticed in various places is that people still tend to use the traditional clustered and non clustered indexes. However, I rarely see the filtered … Read more