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

How to Create a New Client in SAP

How to Create a New Client in SAP In this post we will learn How to create a new client in SAP. In earlier post we had discussed about What is Client in SAP?. Prior creating a New Client in SAP, we have to create a new logical system. Step 1: Run transaction code BD54: it