I recently came across a post in Linkedin about a script that performs Pattern Matching or “Fuzzy Lookup” within TSQL. The Script was definitely an elegant solution to […]
Tales from the crypt: – Passing multiple int values into a variable
Reference Post https://social.msdn.microsoft.com/Forums/en-US/7c04a296-3c26-4a43-ae63-bc90139f4ab3/error-converting-data-type-nvarchar-to-int?forum=sqlgetstarted I was browsing through the forums and found this question being asked. While the reason for the error is fairly obvious I felt it needed […]
Generating TPC H data for testing
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 […]
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 […]