Practical guides and insights for modern data practitioners
Chantified Lens 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
In this post I want to do a quick introduction to Power BI Report Server. Which is a version of Power BI that you can install on a server. To be honest with you todays post was going to be about something completely different. However, I’ve been asked a few times about this recently. I … Read more
Welcome Welcome to my first ever T-SQL Tuesday contribution. I will do a recap in case you’ve never heard of T-SQL Tuesday before. It’s where various members of the SQL community blog at the same time on the second Tuesday of every month. This month’s theme is based on a book called Death March. It … Read more