Checkpoint in SQL server is the process by which dirt pages are written to disk. However it had a flaw that cause issues and the solution of which […]
Accelerated database recovery – And how it’s like a car wash
Accelerated Database Recovery is a feature that DBAs will find very useful. Dba’s are often stuck in a situation where the transaction log file cannot be truncated because […]
SQL 2019-Data Classification and Vulnerability assessment
Data Classification With GDPR security has become a high priority for a large number of organizations the cost of not implementing robust security has been significantly increased and […]
SQL 2019 – Lightweight Query profiling
Lightweight query profiling is a feature that was introduced in SQL 2014. Before we can start talking about lightweight query profiling we need to understand the problem that […]
SQL 2019 -Batch Mode on row store
With the introduction of Columnstore indexes we got Vertipaq Compression and Batch mode as the execution mode. The latter results in much faster query execution where large number […]
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 […]
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.
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
Imagine writing a query where sometimes you join a handful of rows and other times you process millions—traditionally the optimizer had to pick one strategy up front, often […]
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 […]