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

SQL Server 2016

SQL-Server-2016

Great Reads

by Jovan Popovic(MSFT)
Create powerful REST API with just few lines of C# code using MsSql.RestApi package
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 

8 Jan 2020 by E. Scott McFadden
This article explains how to create and use a self referencing key in a SQL Server Table.
24 Jun 2021 by Oleksandr Viktor (UkrGuru)
Minimally simple UkrGuru.SqlJson package for modern data manipulation
1 Oct 2016 by Suvendu Shekhar Giri
Enhancement on dropping an object with check for existence in SQL Server 2016
13 Aug 2016 by Krishna KV
Dynamic masking using SQL Server 2016
5 Sep 2016 by Suvendu Shekhar Giri
Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016
2 Feb 2018 by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment
29 May 2019 by DiponRoy
A utility query to find table generations in SQL Server relational database