Click here to Skip to main content
15,436,489 members
Everything / Database Development / SQL Server / SQL Server 2016

SQL Server 2016

SQL-Server-2016

Great Reads

by Jovan Popovic(MSFT)
In this article, I will show you how to create powerful REST API with just a few lines of C# code using MsSql.RestApi package. If you follow this approach, it might be a huge time saver for you.
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
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.
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.

Latest Articles

by Oleksandr Viktor (UkrGuru)
Minimally simple UkrGuru.SqlJson package for modern data manipulation
by E. Scott McFadden
This article explains how to create and use a self referencing key in a SQL Server Table.
by Kanishka Basak
Analysis and troubleshooting a database performance bottleneck
by DiponRoy
A utility query to find table generations in SQL Server relational database.

All Articles

Sort by Score

SQL Server 2016 

5 Nov 2018 by Jovan Popovic(MSFT)
In this article, I will show you how to create powerful REST API with just a few lines of C# code using MsSql.RestApi package. If you follow this approach, it might be a huge time saver for you.
2 Jun 2017 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
29 Aug 2018 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.
10 Feb 2016 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.
1 Jun 2017 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
12 May 2019 by Manjuke Fernando
Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values
2 Jun 2017 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
15 Aug 2016 by Suvendu Shekhar Giri
How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking
23 Aug 2016 by Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
13 Nov 2017 by Haroon Ashraf
This article helps beginners to generate over million records of random test data for a database object like books in SQL.
11 Mar 2016 by Kashif-Sohail
What is Data masking, enabling it in an existing application and giving access to different users to the masked data
9 Dec 2019 by Kanishka Basak
Analysis and troubleshooting a database performance bottleneck
19 Aug 2016 by RahulBansode
SQL Server 2016 - Security Feature - Always Encrypted