Tag: SQL2016

Installing SQL server 2016 – standalone instance – new features

Daniel Holt, Database Administrator at Pythian, provides a step-by-step guide to installing SQL Server 2016, and highlights some of the new installation features.

Read More >

How to build a multi-domain cluster with AlwaysOn availability groups – SQL Server 2016

SQL Server 2016 is making lots of news, and promises to be a revolutionary SQL Server version. In talking about AlwaysOn Availability Groups, a very good number of improvements were already announced as part of the Basic Availability Groups. By…

Read More >

SQL On The Edge #8 – SQL server mobile report publisher

One of the cool things about SQL Server is that it comes bundled with all the Business Intelligence services with the core database engine license. Reporting Services (which includes the Mobile Report Publisher), Analysis Services, and Integration Services are all…

Read More >

SQL server 2016 – AlwaysOn basic availability group

Hemantgiri S. Goswami, Pythian database expert and SQL Server MVP, discusses a new feature, Basic Availability Groups for AlwaysOn, found in SQL Server 2016

Read More >

SQL 2016 – Improve Performance with the Query Store feature: Part 1

  After playing with this great new feature for some time and speaking about it during a SQL Saturday in Montreal, I can say that I am very excited about Query Store in SQL 2016! Performance tuning is our bread and butter…

Read More >

SQL server row level security

  Row Level Security (RLS) has been implemented in SQL Server 2016 for both on-premise and v12 of Azure instances. The problem this solves is: a company with multiple applications accessing sensitive data in one or more tables. How do…

Read More >

SQL On The Edge #4 – SQL 2016 Stretch Database

  As the Microsoft SQL Server team continues to build very interesting integrations between the full SQL Server box product we all know and the Azure cloud platform. Stretch database is another integration that will be included as part of SQL…

Read More >

SQL On The Edge #2 – SQL 2016 temporal tables

Hello and welcome to our second episode of SQL On The Edge! On this episode we’re going to focus on a new feature of SQL Server 2016 called Temporal Tables. What’s a Temporal table? Temporal tables allow us to go…

Read More >

Windows containers: installing SQL server

This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server in a Windows Container. Introduction As many of you have heard, Microsoft is jumping into containers with native support for…

Read More >

SQL On The Edge #1 – 2016 installer

  Hello and welcome to my new video blog (Vlog) series SQL On The Edge! My goal with these videos is to provide short, concise demonstrations of the latest and greatest features regarding SQL Server, Azure SQL Database and other…

Read More >