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 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 →
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 →
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 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 →
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?
A short demo on how to split strings with delimiters into columns.
Here’s a short tip on how to align columns (separated by comma or other character) for text files in Notepad++ for increased readability.
This short blog post is mostly targeted to my Swedish visitors. I have created a downloadable database backup that contains all SNI codes with both Swedish and English descriptions.
The SSISDB Catalog was introduced in SQL Server 2014. With it came a lot of procedures to manage deployed SSIS projects. The procedures cover running, configuring, managing and troubleshooting SSIS packages. In this post I will cover a procedure that … Read more →