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:
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
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.
Leave a Reply
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 
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
or
SQL Server 2016?
Please help me!
Your Help will be greatly appreciated.
Thanking You!
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.
~Manoj
I heard this exam will be expired soon
I’m not aware of this, can you tell me where did you hear this? any reliable source?
https://www.microsoft.com/en-in/learning/mcse-sql-data-platform.aspx
i have decided to go for this exam.
But it is not possible to appear for this exam at the same time.
should I follow the flow?
Can you suggest me any?
Few of my colleagues were telling me. But sql server 3016 is on its way. So which exam will be beneficial for me.
Ok, I checked with the SQL product team, and came to know that:
MCSE (464/465 and 466/467) exams are updated with SQL 2014 topics. And same will go with 2016 after release.
~Manoj
If I appear for 461 then will I able to appear for 464/465?
or will it change after 2016 release?
To appear for MCSE DP: 464 or 465, you need to pass 461, 462 and 463, all 3 MCSA exams.
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?
upgrade not for 461/2/3, but yes for rest of the ones.
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!!
Thanks
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.