Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

Always Encrypted SQL Server 2016

Always Encrypted SQL Server 2016 Always Encrypted is a new feature introduced in SQL Server 2016. Always Encrypted SQL Server 2016 main objective is to protect sensitive data from unauthorized access. Unlike TDE, as well, Always Encrypted allows you to encrypt only certain columns, rather than the entire database. Always Encrypted option enables data encryption

Dynamic Data Masking SQL Server 2016

Dynamic Data Masking SQL Server 2016 Hi friends, in this post we will discuss a newly added feature by SQL Server team to keep data safe, Dynamic Data Masking SQL Server 2016. Dynamic data masking SQL Server 2016 restrict sensitive data exposure to non-privileged users. Dynamic data masking feature used to hide sensitive data from unauthorised access and

Reporting Services Catalog Database File Existence

Reporting Services Catalog Database File Existence Hi friends, recently I am trying to reinstall SQL Server 2016 Developer edition on my system. As earlier version is SQL Server 2016 Release Candidate 2. During installation I got this error Reporting Services Catalog Database File Existence & Reporting Services Catalog Temporary Database File Existence. I already faced this error so

How to recover corrupt Master Database

How to recover corrupt Master Database Hi friends, in this post we are discussing a very important task played by a SQL Server DBA How to recover corrupt Master Database. In case of MASTER database corruption in SQL Server, you can’t able to start your SQL Server. So it is a wise approach to take backup

SQL Distinct

SQL Distinct Hi friends, in this post we will learn about SQL Distinct. Distinct keyword is used to get distinct (different) values. SQL DISTINCT keyword is used in with SELECT statement, it eliminate all the duplicate records and fetching only unique records. Earlier we had discussed about SQL Group by Clause,SQL Order By Clause,SQL Select Top Clause, Like Clause SQL