Identity columns are widely used as primary key columns in SQL Server tables. They can be … Identity columns that are about to overflowRead more
Year: 2016
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
Split strings to columns
A short demo on how to split strings with delimiters into columns.
How to align columns in Notepad++
Here’s a short tip on how to align columns (separated by comma or other character) for … How to align columns in Notepad++Read more