Enforcement of the new GDPR will begin in May 2018. One of the cornerstones in GDPR … Dynamic Data Masking (DDM) – Mask query resultsRead more
SQL Server
The T-SQL Merge statement
You have a table A with new data, and a table B with old data. How … The T-SQL Merge statementRead more
From SQL Server to MSMQ using PowerShell
How do you get records from a SQL Server table into a MSMQ queue as separate … From SQL Server to MSMQ using PowerShellRead more
Identity columns that are about to overflow
Identity columns are widely used as primary key columns in SQL Server tables. They can be … Identity columns that are about to overflowRead more
Temporal Tables Introduction
Temporal tables was introduced in SQL Server 2016, and is a technique that simplifies keeping track … Temporal Tables IntroductionRead more
SQL Agent job logging with tokens
A useful feature in the SQL Agent is the possibility to use tokens. Tokens are a … SQL Agent job logging with tokensRead more
Toggl Time entries to SQL Server
Toggl is a very simple to use cloud based time tracking application. Time entries on projects … Toggl Time entries to SQL ServerRead more
Split strings to columns
A short demo on how to split strings with delimiters into columns.
SSISDB.catalog.create_execution
The SSISDB Catalog was introduced in SQL Server 2014. With it came a lot of procedures … SSISDB.catalog.create_executionRead more
SQL Server recovery time
SQL Server Recovery time is the time it takes for SQL Server to rollback or roll-forward … SQL Server recovery timeRead more