Brian Bønk Rueløkke

Author
Recent Posts

Brian works as a Business Intelligence and Database architect at Rehfeld – part of IMS Health.

His work spans from the small tasks to the biggest projects. Engaging all the roles from manual developer to architect in his 11 years experience with the Microsoft Business Intelligence stack. With his two certifications MSCE Business Intelligence and MCSE Data Platform, he can play with many cards in the advisory and development of Business Intelligence solutions. The BIML technology has become a bigger part of Brians approach to deliver fast-track BI projects with a higher focus on the business needs.

View all posts by Brian Bønk Rueløkke

Latest posts by Brian Bønk Rueløkke (see all)

How to import flat files with a varying number of columns in SQL Server - February 22, 2017
Ready, SET, go – How does SQL Server handle recursive CTE’s - August 19, 2016
Use of hierarchyid in SQL Server - July 29, 2016

How to import flat files with a varying number of columns in SQL Server

February 22, 2017 by Brian Bønk Rueløkke

Ever been as frustrated as I have when importing flat files to a SQL Server and the format suddenly changes in production?

Commonly used integration tools (like SSIS) are very dependent on the correct, consistent and same metadata when working with flat files.

So I’ve come up with an alternative solution that I would like to share with you.

Ready, SET, go – How does SQL Server handle recursive CTE’s

August 19, 2016 by Brian Bønk Rueløkke

First of all, a quick recap on what a recursive query is.

Recursive queries are useful when building hierarchies, traverse datasets and generate arbitrary rowsets etc. The recursive part (simply) means joining a rowset with itself an arbitrary number of times.

A recursive query is defined by an anchor set (the base rowset of the recursion) and a recursive part (the operation that should be done over the previous rowset).

Use of hierarchyid in SQL Server

July 29, 2016 by Brian Bønk Rueløkke

I attended a TDWI conference in May 2016 in Chicago. Here I got a hint about the datatype hierarchyid in SQL Server which could optimize and eliminate the good old parent/child hierarchy.

Query Store – the next generation tool for every DBA

November 13, 2015 by Brian Bønk Rueløkke

Along with the release of SQL server 2016 CTP 3 now comes the preview of a brand new feature for on premise databases – the Query Store. This feature enables performance monitoring and troubleshooting through the log of executed queries.

This blogpost will cover the following aspects of the Query Store feature:

Introduction
How to activate it
Configuration options
What information is found in the Query Store
How to use the feature
What’s in it for me

Behold the new live query stats in SQL Server 2016

September 11, 2015 by Brian Bønk Rueløkke

With the release of SQL Server 2016 also comes a great new feature to get a live view of the current execution plan for an active query.

This blogpost will cover the aspects of this new feature including:

Introduction
How to activate
How to use and read the output
Downsides – if any

Row level security in SQL Server 2016

August 13, 2015 by Brian Bønk Rueløkke

With the release of SQL Server 2016 comes many great new features. One of these is the implementation of row level security in the database engine.

This blogpost will cover the aspects of this new feature – including:

Setup
Best practice
Performance
Possible security leaks

The DBAs guide to stretch database

August 11, 2015 by Brian Bønk Rueløkke

One of the new features in SQL Server 2016 – and there is a lot – is the ability to stretch the on premise databases to an Azure environment.

This blogpost will cover some of the aspects of this – including:

Primarily setup – how to get started
Monitoring state of databases that are in ‘stretch mode’
Daily work with stretch databases
Backup – what’s good to know