Dinesh's Blog :::: Being Compiled ::::

Here is my second video related to Always Encrypted. This video discusses the way of configuring CMK for serving multiple applications hos...

Here is my second video that speaks about Always Encrypted feature. This video shows How Always Encrypted works, how it should be configure...

SQL Server uses 3 protocols to make the communication between client and the server. Initially there were 4 protocols but now it supports ...

You know that we can create multiple administrator accounts in SQL Server if it is a on-premises instance or an instance configured in a V...

Unless it is a contained database, we must create a login for connecting with SQL Server in order to access a database. Databases are acce...

Has your database been attacked by someone? Most of our applications are data-driven applications and attackers can use various techni...

Among multiple methods given for securing data stored in the SQL Server database, even though the latest one which is Always Encrypted  is...

Assume that you use SQL Server 2016 and trying to create a  Symmetric Key or Asymmetric Key  for encrypting data. If you try use an algori...

Have you ever deleted a database accidentally? If you have done, then you know very well that how it makes you uncomfortable :). If you ar...

In order to access Azure SQL Server databases, firewall rules have to be set at either server level or database level by adding client IP ...

We use Transparent Data Encryption (TDE) for protecting our databases, making sure that no one can get our databases added to a different ...

While discussing about Impersonation , a question raised; If we mistakenly execute EXECUTE AS statement twice, do we have to call REVERT t...

We heavily use Dynamic Management Views and Functions for retrieving insight of inner operations of SQL Server and they are very useful. T...

You have installed SQL Server and it is up and running without any issue. Later, you need to change some permission given to either SQL Se...

Have you noticed two new database roles appeared in master database? You might have, you might have not, because these two appear only wit...

SQL Server 2016 introduced Dynamic Data Masking for obfuscating certain values in records, not exactly as a security measure but for hidin...

You are the Database Administrator and you maintain a database with following characteristics; Database contains sensitive data. Datab...

How do you check and see whether you have permission on a specific object and what permission types you have been granted? This requiremen...

Security is the most important area that needs to be addressed with many solution and same goes to your Business Intelligence solutions im...

When there is a requirement for granting permission on tables for database users, common or known way of doing it is, granting explicit pe...