SQL Server 2016 – Articles

–> Download and Install [SQL Server 2016 RTM], [Service Pack 1], [SSMS 2016]

–> New Sample database [WideWorldImporters] for SQL Server 2016

–> New Features in SQL Server 2016:

1. Native JSON support

    a. Introduction to Native JSON support in SQL Server

    b. JSON, Export/Convert Table or SQL Query data to JSON format – Part 1

    c. Import/Read JSON data to tabular format – Part 2

    d. Reading JSON string with nested elements – Part 3

    e. Store JSON in Table, OPENJSON, JSON_Value functions – Part 4

    f. Passing JSON string as parameter in SP with multiple values – Part 5

2. Temporal Database & Tables

    a. Temporal Data/Tables – Part 1

    b. Temporal, enabling Temporal on existing Table – Part 2

    c. Temporal, resolve issues while enabling Temporal on existing Table – Part 3

3. Row Level Security:

    a. Row Level Security (RLS), Filter Predicates – Part 1

    b. Row Level Security (RLS), Block Predicates – Part 2

4. Dynamic Data Masking:

    – Dynamic Data Masking, Introduction and demo

5. Stretch Database:

    – Stretch you on-premise Database to Azure SQL Database with StretchDB

6. Live Query Statistics:

    – Check Live status of Execution plan by using Live Query Stats

8. Query Store:

    a. Query Store, introduction

    b. Query Store, enable “Query Store” in a Database

7. Other features:

    a. TRUNCATE Table at Partition level

    b. New Feature – STRING_SPLIT() function to split strings

    c. Now export and import UTF-8 data (BCP, Bulk Insert, OPENROWSET)

    d. New Feature – COMPRESS and DECOMPRESS functions

–> Enhancements in SQL Server 2016:

    a. ColumnStore Indexes evolution from SQL Server 2012, 2014 to 2016

    b. In-memory OLTP improvements from SQL Server 2014 to 2016

    c. TempDB Database Files

    d. new “IF EXISTS” option with ALTER & DROP statements

–> My whitepaper published on – Top 8 features of SQL Server 2016

–> My YouTube Videos on SQL Server 2016:


–> Join SQL Server 2016 groups on [LinkedIn] and [Facebook] for more updates.

  1. Rakesh
    February 3, 2016 at 1:55 pm

    Hello Manoj,
    your posts are very useful and informative.
    I suggest all my colleagues to use this web site if they better articles related to SQL.
    You elaborate very effectively.
    Everything is so perfect in it.
    I went through your post on https://borntolearn.mslearn.net/certification/database/f/516/t/321649.
    It is very informative.
    Its very good for me writing to you.
    I would like to know the certifications.
    Can you please spare some time helping me?
    I am new to a job, I want myself to become a certified in SQL.
    Which certifications will be good for me?
    SQL Server 2014
    SQL Server 2014
    SQL Server 2016?

    Please help me!
    Your Help will be greatly appreciated.
    Thanking You!

    • February 3, 2016 at 2:08 pm

      Thanks a lot @Rakesh for your comments and I’m happy that you really liked it and it helped you and your friends.

      Regarding certifications, right now the latest exams are based on “SQL Server 2012” version only. So, you can take 70-461/462/463, as per your interest and convenience.


  2. Rakesh
    February 3, 2016 at 2:12 pm

    I heard this exam will be expired soon

  3. Rakesh
    February 3, 2016 at 2:16 pm

    Few of my colleagues were telling me. But sql server 3016 is on its way. So which exam will be beneficial for me.

    • February 3, 2016 at 3:48 pm

      Ok, I checked with the SQL product team, and came to know that:

      • MCSA (461/462/463) exams will be having SQL 2012 content only.
      • MCSE (464/465 and 466/467) exams are updated with SQL 2014 topics. And same will go with 2016 after release.


      • Rakesh
        February 3, 2016 at 3:50 pm

        If I appear for 461 then will I able to appear for 464/465?

        or will it change after 2016 release?

      • February 3, 2016 at 3:53 pm

        To appear for MCSE DP: 464 or 465, you need to pass 461, 462 and 463, all 3 MCSA exams.

      • Rakesh
        February 3, 2016 at 3:55 pm

        But If I passed 461, 462, 463 in SQL 2012 and further want to appear for 464/465,
        but You stated that “MCSE (464/465 and 466/467) exams are updated with SQL 2014 topics. And same will go with 2016 after release”.
        Will I need up-gradation?

      • February 3, 2016 at 5:13 pm

        upgrade not for 461/2/3, but yes for rest of the ones.

  4. Mahesh R
    August 30, 2016 at 6:03 pm

    Hi Manoj,

    I am very glad to see your posts of SQL Server 2016 new features, those are very informative and are in great detailed. Thank you so much!!

    Need some help/tips :

    We are trying to upgrade some of our components from sql server 2012 to sql server 2016.

    As part of migration, would like to know is there any deprecated features in SQL 2016(discontinued in sql server 2016 that are exist in sql server 2012/2014)

    if we have deprecated features, do we have any road blocks?

    For , In-place up-gradation we can use Microsoft upgrade Adviser,

    how to do migration if it would be Parallel up-gradation( with new servers)

    Kindly help me out with these

    Would be grateful to you for your help!!

  5. Ramesh Dharecha
    September 8, 2016 at 3:20 pm


  6. Arpita
    March 10, 2017 at 4:06 pm

    Thank You Manoj for a detail explanation in the blog as well as in the video. Could you please tell me Can we attempt for SQL 2016 certification now.

  1. September 4, 2015 at 7:02 am
  2. October 1, 2015 at 4:48 pm
  3. October 29, 2015 at 11:58 am
  4. November 3, 2015 at 6:14 pm
  5. December 1, 2015 at 3:19 pm
  6. December 30, 2015 at 2:48 pm
  7. March 3, 2016 at 8:08 pm
  8. March 8, 2016 at 10:00 pm
  9. March 28, 2016 at 7:01 am
  10. March 28, 2016 at 10:32 am
  11. April 6, 2016 at 8:12 pm
  12. August 7, 2016 at 12:38 am
  13. November 28, 2016 at 12:37 am
  14. March 14, 2017 at 2:51 am
  15. May 29, 2017 at 7:03 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: