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 […]
Pattern matching vs Fuzzy Lookup in SQL Server
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
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 further investigation so […]
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 […]