Monthly Archives: July 2019

SQL 2019 – Certificate Management within SQL Server Configuration Manager

By | July 31, 2019

  Those of us who work with hybrid environments such as public facing data warehouse systems or Hybrid cloud infra will appreciate the ability to manage Certificates used by SQL Server in a more familiar environment. Previously we would import the certificates via certificate manager in the OS and then bind the same to the… Read More »

SQL 2019- Script for working with Resumable online indexes

By | July 30, 2019

Below is the script used in the video demonstrating Resumable online indexes feature in SQL 2019. https://youtu.be/xJTfyERfTkk [codesyntax lang=”tsql”] use master IF Exists (select 1 from sys.databases where name =’ResumableIX’) BEGIN DROP DATABASE ResumableIX END Create database resumableix go Use ResumableIX go Create table resumableIxtbl ( Id int identity(1,1) , customername varchar(100), somerandomtext varchar(1000)) GO… Read More »

Make the List and Stick to it

By | July 26, 2019

Every few weeks I am approached by someone on LinkedIn on how to go about starting the business or improving the way they work etc. To be honest I won’t claim to be an expert in this field (by any measure) but the fact that people ask me these question tells me that I must… Read More »

Tuple Mover Basics and the Updateable Columnstore index

By | July 9, 2019

When Microsoft introduced Columnstore indexes in SQL server 2012 a key limitation was the table could only be read from and not inserted. While the limitation itself has been overcome in subsequent versions of SQL server we need to understand the impact of how they work to explain performance issues when it comes to accessing… Read More »