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 SQL…
Month: July 2019
SQL 2019- Script for working with Resumable online indexes
Below is the script used in the video demonstrating Resumable online indexes feature in SQL 2019. https://youtu.be/xJTfyERfTkk 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)…
Tuple Mover Basics and the Updateable Columnstore index
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…