Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn :
Fixed server roles
Making a custom role for the server
What is a schema?
What is multibase chaining?
What is Row Level Security?
And much more
We will also cover a long chapter on the different isolation modes (READ COMMITED, SERIALIZABLE, SNAPSHOT…), we will also see the different types of constraints (PK,FK,CHECK,UNIQUE…), as well as SEQUENCES, and IDENTITY.
We will also discuss the change data capture (CDC), many new features released on SQL Server 2016 such as Row Level Security, Dynamic Data Masking (DDM), Temporal Data.