Kenneth M. Nielsen

Author
Recent Posts

Kenneth M. Nielsen works as managing consultant and team lead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large BI installations in Denmark over the last 12 years.

He really likes to advise the customers to take the right decisions, but also maintains a high technical knowledge, so he can act as both architect and developer.

Over the last years, he has become a highly-rated international speaker at various SQL events. Organizing the Danish SQLSaturday and member of the board in SQLSUG.dk

View all posts by Kenneth M. Nielsen

Latest posts by Kenneth M. Nielsen (see all)

Using SQL Server 2016 CTP3 in Azure - November 6, 2015
New Features in SQL Server 2016 – Dynamic Data Masking - July 23, 2015
New Features in SQL Server 2016 – Always encrypted - July 8, 2015

Using SQL Server 2016 CTP3 in Azure

November 6, 2015 by Kenneth M. Nielsen

As the time of the release of the next version of SQL Server is closing in, the cycle of Community Technical Preview (CTP) releases is shorter and shorter – we are now at CTP3 and the product seems very much mature for release. There is a handful of features not yet implemented, that was on the roadmap – but I bet you the SQL Team will go an extra length to get the features ready for the final release.

This post will show you how to get started with testing/using the newest version of the CTP.

New Features in SQL Server 2016 – Dynamic Data Masking

July 23, 2015 by Kenneth M. Nielsen

There are many new features in SQL Server 2016, but the one we will focus on in this post is:

Dynamic Data Masking

Have you ever been on a website, where your personal information, ie. Social Security number or Credit Card number shown in clear text, ready for everyone to have a look at. Would it not be cool if your information was somehow masked by default, and not needed to rely on the application to mask the data before displaying it on the screen?

New Features in SQL Server 2016 – Always encrypted

July 8, 2015 by Kenneth M. Nielsen

There are many new features in SQL Server 2016, but the one we will focus on in this post is:

Always encrypted

A feature many companies and developers have been waiting, is now finally being implemented in SQL Server. The feature is called Always Encrypted, the main purpose of this feature is to secure your data. Your data will only be visible to the ones logged into an application consuming the data, and will never be transferred from application to database unencrypted.

New Features in SQL Server 2016 – Temporal Data Tables

July 6, 2015 by Kenneth M. Nielsen

There are many new features in SQL Server 2016, but the one we will focus on in this post is:

Temporal Database Tables

One of the many new features in SQL server 2016 is the built-in support for temporal data tables. This is a feature that many developers have been urging to have as a “out of the box feature” – and therefore many have developed their own ways of implementing the capability to store information about how data looked in a certain period of time.