The T-SQL Merge statement
You have a table A with new data, and a table B with old data. How do you make sure table B is refreshed with data from table A? You want to insert new records, update existing records and to … Read more →
All Posts by Tomas Lind
From SQL Server to MSMQ using PowerShell
How do you get records from a SQL Server table into a MSMQ queue as separate XML messages? A commonly suggested way to communicate with MSMQ from within SQL Server is to create a CLR assembly. See for instance this … Read more →
Identity columns that are about to overflow
Identity columns are widely used as primary key columns in SQL Server tables. They can be one of the data types TINYINT, SMALLINT, INT, BIGINT, NUMERIC or DECIMAL. Each of these data types has an upper limit and when that … Read more →
Temporal Tables Introduction
Temporal tables was introduced in SQL Server 2016, and is a technique that simplifies keeping track of changed records in a table. The handling of changes of records in a data warehouse dimension table is a good example of when … Read more →
SQL Agent job logging with tokens
A useful feature in the SQL Agent is the possibility to use tokens. Tokens are a number of system variables (e.g. $(ESCAPE_SQUOTE(DATE) that contains the current date) that gets expanded/replaced with a value when the job is run. An obvious … Read more →
Solvency II QRT Names
On and off I am working in SolvencyII projects (financial reporting to governments for companies in the insurance industry). There are a lot of QRT-reports (Quantitative Reporting Templates) that has to be reported to the local authorities, and a while … Read more →
Toggl Time entries to SQL Server
Toggl is a very simple to use cloud based time tracking application. Time entries on projects and clients can be submitted through the web page or through mobile and desktop applications. Time spent by the team can be viewed in … Read more →
From PowerShell to SQL Server tables
Some of the output from PowerShell cmdlets return results that can be represented as tables. So how can these results be stored in SQL Server tables?
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 text files in Notepad++ for increased readability.