SQL-Server-2016

Great Reads

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

Always Encrypted Feature in SQL Server 2016

by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Building a Basic Test Data Generator for Books in SQL

by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

DROP IF EXISTS in SQL Server 2016

by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

Latest Articles

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

Always Encrypted Feature in SQL Server 2016

by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Building a Basic Test Data Generator for Books in SQL

by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

DROP IF EXISTS in SQL Server 2016

by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

All Articles

top

SQL-Server-2016

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

Building a Basic Test Data Generator for Books in SQL

by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

Dynamic Data Masking in SQL Server 2016

by Kashif-Sohail

What is Data masking, enabling it in an existing application and giving access to different users to the masked data

FOR XML Basics (AUTO Mode): 2 of 4

by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

FOR XML Basics (EXPLICIT Mode): 3 of 4

by AhsanAhmed

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

FOR XML Basics (RAW Mode): 1 of 4

by AhsanAhmed

A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format

Masking Sensitive Data with SQL Server 2016

by Suvendu Shekhar Giri

How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking

MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API

by Jovan Popovic(MSFT)

Create powerful REST API with just few lines of C# code using MsSql.RestApi package

SQL Server 2016 - Always Encrypted

by RahulBansode

SQL Server 2016 - Security Feature - Always Encrypted

SQL Server Performance Issue After An Upgrade

by Kanishka Basak

Analysis and troubleshooting a database performance bottleneck

Strange Behavior on JSON_VALUE When Table Contains Blank and Non-blank Values (JSON Text is Not Properly Formatted. Unexpected Character '.' is...

by Manjuke Fernando

Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values

Streamline Log Shipping Failovers

by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

Top 10 Exciting New Features in SQL Server Management Studio 2016

by Suvendu Shekhar Giri

Introduction of new useful features in SSMS 2016