High Coast Database Solutions är ett Stockholmsbaserat IT-konsultföretag som erbjuder konsulttjänster främst relaterade till Microsoft SQL Server plattformen.


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 upper limit is reached, an error is raised and further inserts into the table are impossible.


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 temporal tables can be useful. In this blog post, I'll cover the basics of temporal tables.


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 use of tokens is to create a new log file with today's date and time in the file name each time an SQL Agent job is run.



© Copyright 2015 High Coast Database Solutions AB