SQL
Server 2016 is the biggest leap forward in Microsoft data platform
history. There is a lot of buzz around SQL Server 2016. Gain real time insights
across your transaction and analytical data with a salable database platform
that has everything built in, from unparalleled in-memory performance, new
security innovations and high availability, to advanced analytics that make
mission-critical applications intelligent.
Always Encrypted - SQL
Server 2016 has introduced new feature that is Always Encrypted. If this feature
is enabled in your SQL Server then all data would be in encrypted mode always.
By this feature all the confidential data would be save and we can apply proper
access control of data in proper mode.
Dynamic Data Masking - This
is very interesting feature of SQL Server 2016 edition. If you want to hide
some part of any data to be hidden by for some one and some part to be shown to
some one then easily you can make this done using this feature. e.g. you have
mobile number stored in database and you want to hide all digits except last 2
digits then easily you can perform this using Dynamic
Data Masking feature.
JSON Support - JSON
stands for Java Script Object Notation. Now using this feature of SQL Server
2016 you can easily interchange the data in JSON format.
TempDB Database Files - During setup, you can configure the number of tempdb database
files, initial size, auto growth and directory placement using the new UI input
control on the Database Engine Configuration - TempDB section of SQL Server
Installation Wizard.
Query Store - If you are into examining execution plans than you will like the
new Query Store feature. Currently in versions of SQL Server prior to 2016 you
can see existing execution plans by using dynamic management views (DMVs). But,
the DMVs only allow you to see the plans that are actively in the plan cache.
You can’t see any history for plans once they are rolled out of the plan cache.
With the Query Store feature, This is a great addition and will allow you to
now track execution plans performance for your queries over time.
Row Level Security - You can apply row level security in SQL Server 2016
When you are trying to install SQL server on your computer and because of any other installation or any process some files are pending for renaming hence this happened.
Steps to solve this problem
- Open the run window
- Type regedit to open registry editor.
- Search for following value in registry.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
- Double click the PendingFIleRenameOperations and once you will double click it a dialog window would be appeared and simply press the delete key and click OK
Now you would be able to install your SQL server. Please leave your comments if this post helps you.
DML - is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.
e.g.: SELECT, UPDATE, INSERT statements
DDL - is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.
e.g.: CREATE, ALTER, DROP statements
DCL -is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.
e.g.: GRANT, REVOKE statements
TCL - is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.