Check our collection of high-quality articles, on a variety of SQL Server Security topics. The collection is being regularly updated with new articles.
Dynamic Data Masking in SQL Server or later, is another data protection feature originally shipped with SQL Server 2016. It limits sensitive data exposure by masking it to non-privileged users. The masking rules are applied in the query results and you designate how much of the sensitive data to reveal and to who. SQL … Read more…
SQL Server Row Level Security (RLS) is one of the top new features shipped in SQL Server 2016. With RLS, you can control access to rows in a table based on the characteristics of the user executing a query. The access restriction logic is located in the database tier and access restrictions are always applied, … Read more…
In this article, we will be discussing about the different available options, for encrypting SQL Server databases. The Need for Data Encryption In corporate environments there is always the requirement/policy of data protection. Data is the most valuable asset in every organization, after its human resources of course, as it is with data where … Read more…
SQL Server 2008, among other introduced significant security changes that enhance the database administrators applying an even stricter security policy on the SQL Server instances. This article discusses the security changes in SQL Server 2008. Major Security Changes in SQL Server 2008 Besides the changes in the Windows local groups that are created during … Read more…
In this article, we will be discussing about a special security feature in SQL Server, that is Policy-Based Management. Some time ago I promised publishing a post on Policy-Based Management in SQL Server. Well, it’s time to fulfill my promise! 🙂 This is a rather large post, I hope you find the information it contains … Read more…
Transparent Data Encryption (TDE) is another new feature in SQL Server 2008. It performs real-time I/O encryption and decryption of the data and log files, that is the entire database. For achieving that, it uses a database encryption key stored in the database boot record. A derived benefit of TDE is that whenever a database … Read more…