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 […]
Using Bookmarks in PowerBI
PowerBI is a robust reporting tool that has a number of easy to use and configurable options when it comes to reporting. One of the most frequently used […]
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 […]
The Key didn’t match any rows in the table – PowerBI
When you get the below error it usually has nothing to do with primary keys or rows. In fact the majority of the time it is because you […]
A Case for Classroom trainings
Every once in a while I see an advertisement on LinkedIn about companies that conduct online Trainings. Each time I see such ads I am reminded of how […]
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 […]