Five Useful SQL Server Management Practices

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.

Execute As Security

Dynamic Data Masking Feature in SQL Server 2016

Microsoft has introduced very impressive new security feature in SQL Server 2016 called Dynamic Data Masking (DDM).Dynamic Data Masking allow user to decide how much of the sensitive data to reveal with minimal impact on the application layer.

Always Encrypted Certificates

Password Policy

Change Login Auditing Option

Configure Login Auditing

Checking Admins

SQL Authentication Via AD Groups Part III: What About Orphaned Users?

With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.

Column Level Permissions and DENY

Certificate