Microsoft has recently introduced a few changes in how the certification works. I have tried to simplify the same thing over here. The new certification line is called Microsoft cloud-built Certifications. Let us read more about Microsoft Certification.
The mapping of the certifications is here.
Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
Let’s get some basic definitions down first about SQL Server Security. Take the workplace example where “Tom” needs “Read” access to the “Financial Folder”. What are the Securable, Principal, and Permissions from that last sentence?
A Securable is a resource that someone might want to access (like the Financial Folder).
A Principal is anything that might want to gain access to the securable (like Tom).
A Permission is the level of access a principal has to a securable (like Read).
The goal of a Fast Track Data Warehouse reference architecture is to achieve an efficient resource balance between SQL Server data processing.
Read Part 1 Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment
Read Part 2 Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table
In this third part of the series, we will see how we can retrieve various information from the FileTable database.
