Reading Time: 2 minutes 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…
A blog about Microsoft Data Platform offerings
All things relating to SQL Server
Reading Time: 2 minutes 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…
Reading Time: 3 minutes 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,…
Reading Time: 3 minutes 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…
Reading Time: 2 minutes 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…
Reading Time: 2 minutes Voting for SQLBits general sessions is now open. For those of you that still have to attend SQLBits I will do a quick recap. SQLBits…
Reading Time: 4 minutes 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…
Reading Time: 5 minutes 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…
Reading Time: 2 minutes 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…