A common requirement I have is to generate test data. Sometimes for trainings and sometimes for consulting work. As you may have seen from many previous video and […]
SQL 2019 – Certificate Management within SQL Server Configuration Manager
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 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 […]
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 […]
Adaptive Joins SQL 2017
SELECT a.StateName ,a.CityName ,sum(flights) FROM Airports a INNER JOIN normalization_index n ON a.AirportSeqId = n.OriginAirportSeqID WHERE a.AirportSeqId > 1474703 GROUP BY a.StateName ,a.CityName SELECT a.StateName ,a.CityName ,sum(flights) FROM […]
94% Compression???? SQL Server from 1GB to 65 MB
In this video we go about taking data that is little over 1 GB in size and incrementally reducing its size all the way down to 65MB. This […]
Drawing triangles using SQL Server – Fractals
If you play sports you know how much fun it is to do trick shots every once in a while. Occasionally I find myself with time on my […]
SQL 2017 – Minor features
There are a tons of minor improvements of features in SQL 2017 that nobody talks about so I figured before we all get swept up with SQL 2019. […]
administration / Database / Errors / TSQL
Finding candidate keys/Primary keys from data that needs to be imported
This is a continuation from the previous post where we went and inserted data from multiple CSV files into SQL server tables using linked server connection. Often the […]
Adding CSV files as linked Server Connection
I often get a lot of migration projects where the data needs to port from CSV format into SQL Server. Here is a quick way I achieve it […]