SQL Server 2016

Stretching temporal history tables in SQL Server 2016

June 20, 2016 by Jean-Pierre Voogt

Background

With the release of Microsoft SQL Server 2016 a lot of new features were introduced, one of which was Temporal Tables, a feature that gives you the ability to view the state of your data at a given point in time. This means you can go back in time with your data. Another very popular feature is Stretch Databases which allows for remote archiving of data to Azure Stretch region.

Query optimizer changes in SQL Server 2016 explained

June 17, 2016 by Ed Pollack

Description

SQL Server 2016 includes a variety of query optimizer enhancements. Some of these have existed since the first previews while others were added later. This is an opportunity to discuss, test out, and validate the behavior and benefits of these changes!

Installing SQL Server 2016

June 7, 2016 by Robert Seles

Introduction

Microsoft SQL Server 2016 provides faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios. Along with these features, comes the new installation setup. Although it is similar to the installation of SQL Server 2014 and other older versions, there are few notable differences:

Single package deployment in SQL Server Integration Services 2016

May 31, 2016 by Sifiso W. Ndlovu

SQL Server 2016 has some exciting enhancements to SQL Server Integration Services. In this article, we take a look at how the issue of single package deployment into an SSIS Catalog has been resolved with this SQL Server release.

How to connect to a remote SQL Server

February 18, 2016 by Marko Zivkovic

In this article, we will explain step by step how to connect remotely to a SQL Server Express instance. Remote access is the ability to get access to a SQL Server from a remote distance in order to manipulate data which are located on that SQL Server.

In-Memory OLTP Series – Data migration guideline process on SQL Server 2016

January 29, 2016 by Luan Moreno M. Maciel

On the last article about the best modes to move the disk-based tables to using the In-Memory feature we covered all the aspects and styles available on SQL Server 2014. Continuing on the migration process now we’re going to look at some of the new enhancements of makes SQL Server 2016

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.

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

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.