Ever had a folder with a bunch of XML documents that you needed to query? Read … Get element max value from folder with XML filesRead more
Author: Tomas Lind
Tomas Lind - Consulting services as SQL Server DBA and Database Developer at High Coast Database Solutions AB.
Dynamic Data Masking (DDM) – Mask query results
Enforcement of the new GDPR will begin in May 2018. One of the cornerstones in GDPR … Dynamic Data Masking (DDM) – Mask query resultsRead more
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
Solvency II QRT Names
On and off I am working in SolvencyII projects (financial reporting to governments for companies in … Solvency II QRT NamesRead 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
From PowerShell to SQL Server tables
Some of the output from PowerShell cmdlets return results that can be represented as tables. So … From PowerShell to SQL Server tablesRead more