Query store is a feature of SQL server that tracks and captures information about queries. Database administrators will find query store useful in trouble shooting performance issues. Most […]
SQL 2019- Scalar UDF inlining
Scalar UDF are notorious for their performance issues. The most common reason they cause issues is due the fact that the logic is applied on each row. So […]
SQL 2019 – Worker Migration
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 […]
SQL 2019 – Indirect Checkpoint
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 […]
Error when installing SQL 2019 – Developer Edition
Error Message Cannot insert the value NULL into column ‘CustomContext.ClusterId’, table ‘DWDiagnostics.dbo.pdw_component_health_data_lock’; column does not allow nulls. INSERT fails. Affected Components DB Engine , Replication , Polybase , […]
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 – TDE SUSPEND RESUME
In this video we are going to talk about transparent data encryption. Transparent data encryption is a feature in SQL server that protects data at rest. Data at […]
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 […]