Worker migration in SQL 2019 is the process by which workers that are bound to a scheduler can be unbound and run on another scheduler in order to […]

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 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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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. […]