SQL Server 2016 Resources

Share

Related resources for SQL Server 2016

Implement Column Level Encryption/ Decryption In SQL Server 20167/8/2019 11:46:05 PM. This article familiarizes you with implementing column level encryption/decryption in SQL Server 2016.
Working With JSON In SQL Server 20167/8/2019 4:21:42 AM. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popu
How To Import Data From Excel Data Into SQL Table In Microsoft SQL Server 20163/18/2019 10:08:42 AM. This article demonstrates the inbuilt functionality of importing data from Microsoft Excel to a SQL table using import export wizard.
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Three11/16/2017 11:03:33 PM. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificat
DROP IF EXISTS In SQL Server 201611/13/2017 3:18:31 PM. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the objec
Masking Sensitive Data With SQL Server 201611/11/2017 5:59:13 AM. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side sec
Configuring SQL Server 2016 Express On LAN For C# Connection String11/8/2017 11:26:20 AM. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed11/6/2017 11:33:52 AM. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two10/14/2017 5:42:54 AM. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One10/6/2017 1:40:39 PM. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need t
Create Log Backup Maintenance Plan In SQL Server 20169/17/2017 1:25:00 PM. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
SQL Server 2016 - Getting Started With Row Level Security Feature4/25/2017 4:00:34 PM. This article familiarizes you with SQL Server 2016 - Getting started with Row Level Security feature.
Working With SQL Server R Services And R Scripts In SQL Server 20163/17/2017 6:06:43 PM. Working with SQL Server R Services and R Scripts in SQL Server 2016.
SQL Server 2016 - Bulk Import JSON File Data To Table2/25/2017 12:41:28 PM. In this article, you will learn about how to bulk import JSON file data to tables in SQL Server 2016.
Getting Started With SQL Server 20162/12/2017 10:15:35 AM. In this article, we will discuss in detail about SQL Server 2016, the list of features available in SQL Server 2016, prerequisites, setting up the environment, and more.
Getting Started With SSDT 2016 Using Visual Studio 20151/27/2017 12:37:43 AM. In this article, we will discuss in detail about how to get started with SSDT 2016.
Getting Started With SSRS 2016 - Part One1/27/2017 12:36:10 AM. In this article, we will discuss how we can create an SSRS Report without using Report Wizard in SQL Server Reporting Services 2016.
Build Persisting Layer With ASP.NET Core And EF Core Using PostgreSQL And SQL Server 201610/14/2016 12:29:57 PM. In this article, you will learn how to build persisting layer with ASP.NET Core and EF Core, using PostgreSQL and SQL Server 2016.
Stretch Database To Azure On SQL Server 20168/1/2016 10:15:23 PM. In this article, you will learn how to stretch database to Azure on SQL Server 2016.
Validate JSON With ISJSON() Function In SQL Server 2016 7/2/2016 6:16:44 PM. In this article, you will learn how to validate JSON with ISJSON function introduced in SQL Server 2016.
Step by Step Guide To Install SQL Server 2016, SSMS And SSDT Tool6/20/2016 10:16:48 AM. In this article, I will guide you on how to perform a new SQL Server 2016 installation.
Understanding SQL Server 2016 String_Split Function6/17/2016 11:19:11 AM. In this article, I will show you a new feature that has been introduced in SQL Server 2016; i.e., STRING_SPLIT function.
New Features In SQL Server 20164/15/2016 11:39:47 AM. In this article you will learn about some new features in SQL Server 2016.
Stretching SQL Server 2016 Tables To The Azure Cloud3/29/2016 10:53:56 AM. The following article introduces the concept of Stretch Database (Stretch DB), a new feature of SQL Server 2016 and demonstrates examples of its usage.
Dynamic Data Masking In SQL Server 20163/12/2016 12:43:44 PM. In this article you will learn about Dynamic Data Masking in SQL Server 2016.
New Features Of SQL Server 20162/5/2016 4:00:13 AM. In this article you will learn about some new features of SQL Server 2016.
New Features of SQL Server 20165/25/2015 12:23:15 AM. This article describes the new features of SQL Server 2016.
SQL Server 2016: Always Encrypted Feature5/22/2015 1:07:53 AM. I want to discuss today a new feature, Always Encrypted, that was highlighted in the SQL Server 2016.
Understanding SQL Server 2016 ColumnStore5/20/2015 11:53:53 PM. Watch this video to understand new SQL Server 2016 ColumnStore technology.

Topics