Security

Read this article to understand some of the things you need to be aware of for the General Data Protection Regulation that goes into effect in May 2018.

In this tip we look at ways to find orphaned database users.

Read this tip to learn how to identify columns for dynamic data masking and how to apply.

In this tip we learn whether disabling xp_cmdshell in SQL Server really improves security.

Learn how to protect your SQL Server from ransomware with these tips.

In this tip we will cover why it is important to have separate accounts for normal use and for administrative use.

Check out this tip to learn how to limit DBA level access in SQL Server by building custom server and database roles.

In this tip we will cover one approach to find failed logins that occurred in the last week.

Read this tip to learn how to check and auto-generate SPNs for your SQL Servers.

As we develop applications and databases with user's private data, learn some of the good considerations, practices and design patterns that should be taken into account when building your next application.

Row-Level Security is a new feature in SQL Server 2016 and in this tip we take a look at the overhead of using this feature.

In this tip we look at best ways to architect and design SQL Server security authentication.

As a DBA we often have a need to migrate SQL Server logins, permissions, server roles, etc. from one server to another. In this tip we will cover a new approach using PowerShell.

Learn ways to recover access to a SQL Server instance if you are locked out.

Learn how to clone a SQL Server login onto another server and keep the same password.

We usually need to restore our production databases to our QA or other environment for various reasons, but due to data security requirements we need to mask sensitive data, like customer name, addresses, email addresses, phones numbers, etc. In this tip

Cloning a SQL Server login with permissions that match another login is a common task. In this tip we show how this an be done using PowerShell.

You need a T-SQL tool to monitor and report which accounts have sysamdin or database owner privileges on a given SQL Server instance. Check out this tip and script.

Learn how to use custom Event Log views and PowerShell to find failed SQL Server logins.

I was trying to cleanup my SQL Server logins and users, but when I tried to drop a login I got this error message Login 'x' owns one or more database(s). Change the owner of the database(s) before dropping the login.. Also, when I tried to drop a datab

Learn how to Migrate the Correct Logins with a SQL Server Database including Windows Users, Windows Groups, SQL Server Logins, mismatched and orphaned logins.

Learn about the risks of storing passwords in a SQL Server database and how to do so properly without compromising your overall application.

Learn how to determine the SQL Server Permissions Granted to All Users By Default in the public role, in system databases and user defined databases.

Learn how to inventory SQL Logins on a SQL Server instance with PowerShell.