Security

Valuable SQL Server Security tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
Understanding and dealing with orphaned users in a SQL Server database Atif Shehzad2026-05-29
Capital on Tap Meeting Regulatory Compliance and Explosive Growth with DataVeil Data Masking Jeremy Kadlec2026-05-19
PostgreSQL Static Data Masking with DataVeil Andrea Gnemmi2026-05-18
How to configure SQL Server SSL Certificate Tibor Nagy2026-05-14
Preparing SQL Servers and Data for Quantum Computing K. Brian Kelley2026-05-14
SQL Server 7.0 to 2005 Security Vulnerabilities for Logins Tim Ford2026-05-10
SQL Server Static Data Masking with DataVeil K. Brian Kelley2026-04-08
Register a SPN for SQL Server Authentication with Kerberos Ben Snaidero2025-09-29
SQL Server Database Security – Logins and Users Jan Potgieter2025-06-17
Meeting HIPAA Regulations with Agility and Automation Jeremy Kadlec2025-05-30
SQL Server Login and User Permissions with fn_my_permissions Manvendra Singh2025-05-27
Restrict User Query Access in SQL Server Jared Westover2025-05-15
Using Group Managed Service Accounts with SQL Server John Martin2025-01-31
Enable xp_cmdshell in SQL Server Greg Robidoux2024-12-30
Easily Create Non-Sensitive Copies of Production Databases MSSQL Tips2024-10-17
Audit SQL Server Extended Stored Procedures Usage Emad Al-Mousa2024-10-10
SQL Server Database and Server Roles for Security and Permissions Nivritti Suste2024-08-13
How to Secure SQL Server – End to End Security MSSQL Tips2024-04-16
Dynamic Data Masking in SQL Server for Sensitive Data Protection Sergey Gigoyan2024-01-08
Grant SQL Server Permissions to a Folder for Backups or Database Files Levi Masonde2023-12-15
Find All Securable Objects in SQL Server and Permissions Manvendra Singh2022-08-02
Data Masking in SQL Server vs Oracle Pablo Echeverria2022-07-27
SQL Server Database Users to Roles Mapping Report Eli Leiba2022-03-25
SQL Login Details with SQL LOGINPROPERTY Function Manvendra Singh2022-01-28
Learn xp_cmdshell in SQL Server Rick Dobson2021-10-13
SQL ALTER Authorization Examples Manvendra Singh2021-04-29
Kerberos Configuration Manager for SQL Server SPN Validation Svetlana Golovko2021-03-08
Encryption and Decryption of Passwords in SQL Server with PowerShell Jeffrey Yao2021-02-25
SQL Server Windows Authentication with Users and Groups Semjon Terehhov2020-12-29
Implementing SQL Server Security with Stored Procedures and Views K. Brian Kelley2020-09-03
SQL Server EXECUTE AS Greg Robidoux2020-08-14
Resource Based Kerberos Constrained Delegation Tim Cullen2020-07-14
Understanding SQL Server Ownership Chaining K. Brian Kelley2020-04-09
Skip-2.0 Malware Impacts SQL Server – Should I Be Worried? K. Brian Kelley2019-10-24
Find Embedded SQL Server Logins in Jobs, Linked Servers or SSISDB Pablo Echeverria2019-10-17
List SQL Server Permissions for Read and Write Access All Databases Pablo Echeverria2019-08-22
SQL Server Security Functions Joe Gavin2019-05-23
Review Minimum SQL Server Security Practices Tim Smith2018-12-07
Script out SQL Server Credentials and Proxies Pablo Echeverria2018-11-21
Getting Sysadmin Access to SQL Server When Locked Out Joe Gavin2018-08-21
Solving forget me requests for GDPR in SQL Server Aaron Bertrand2018-07-02
Automated WMI Alerts for SQL Server Login Property Changes Svetlana Golovko2018-06-19
Data cleanup in SQL Server becomes more important with GDPR Aaron Bertrand2018-06-12
Alerts and Notifications for SQL Server Login, Database User and Role Membership Changes Svetlana Golovko2018-04-11
Meltdown and Spectre Vulnerabilities Impact on SQL Server Daniel Farina2018-03-21
How does GDPR impact your SQL Server Recovery Plans John Martin2018-03-13
Using Managed Service Accounts with SQL Server John Martin2018-02-13
SQL Server Security Vulnerability Assessment Tool in SSMS 17.4 Rajendra Gupta2018-02-02
Simple SQL Server Function to Generate Random 8 Character Password Eli Leiba2018-01-31
SQL Servers Assessment for the Meltdown and Spectre Vulnerabilities Svetlana Golovko2018-01-25
Backdoor to Elevate SQL Server Security Privileges Jeffrey Yao2018-01-23
Encrypting passwords for use with Python and SQL Server Burt King2018-01-15
Retaining File Information for ETL Security Analysis Tim Smith2018-01-10
Application Database Security Design Part 2 – Multiple Levels of Access to SQL Server K. Brian Kelley2018-01-10
Is your SQL Server environment ready for GDPR? Aaron Bertrand2018-01-05
Different Ways to Find SQL Server Orphaned Users Jeffrey Yao2017-12-01
SQL Server Dynamic Data Masking Discovery and Implementation Thomas LaRock2017-10-25
Is disabling xp_cmdshell in SQL Server really secure? K. Brian Kelley2017-09-06
Protecting SQL Server from Ransomware K. Brian Kelley2017-08-29
Practice of Using Privileged Accounts to Access SQL Server K. Brian Kelley2017-08-07
Tighten SQL Server security with custom server and database roles Douglas Correa2017-07-26
Find All Failed SQL Server Logins Eli Leiba2017-07-03
Script to Check and Auto Generate SPNs for SQL Server Kun Lee2017-05-08
Reflect on SQL Server Security Considerations After Recent Breaches Tim Smith2017-04-03
Performance Impact of SQL Server 2016 Row-Level Security Aaron Bertrand2017-03-27
Application Security Design – Part 1 – Authentication for SQL Server K. Brian Kelley2017-03-03
Migrate SQL Server Logins with PowerShell Rajendra Gupta2017-01-31
More on Recovering Access to a SQL Server Instance Aaron Bertrand2017-01-27
Clone a SQL Server login and password to a new server Bhavesh Patel2017-01-26
SQL Server Functions to Mask Confidential Data using CLR or PowerShell Jeffrey Yao2016-12-12
Cloning a SQL Server Login with all permissions using PowerShell Jeffrey Yao2016-11-22
SQL Server security report to show sysadmins and database owners Eli Leiba2016-11-14
Quickly Find Failed SQL Server Logins Using the Windows Event Log K. Brian Kelley2016-08-04
SQL Server errors with drop login and drop user Ahmad Yaseen2016-06-10
Migrate the Correct Logins with a SQL Server Database K. Brian Kelley2016-04-28
Storing passwords in SQL Server – things to know to keep the data secure Derek Colley2016-04-25
SQL Server Permissions Granted to All Users By Default K. Brian Kelley2016-03-28
Inventory SQL Logins on a SQL Server with PowerShell Adam Bertram2016-02-19
How to Create SQL Server Logins with PowerShell Adam Bertram2016-02-12
Default Schema for Windows Group in SQL Server Ahmad Yaseen2015-10-19
Compare SQL permissions using SQL Server Data Tools Svetlana Golovko2015-09-04
Best Practices to Secure the SQL Server sa Account K. Brian Kelley2015-08-18
Grant User Access to All SQL Server Databases Ahmad Yaseen2015-06-25
How to Clone a SQL Server Login, Part 3 of 3 K. Brian Kelley2015-06-04
How to Clone a SQL Server Login, Part 2 of 3 K. Brian Kelley2015-05-29
PCI Best Practices Guide for SQL Server DBAs Tibor Nagy2015-05-08
Generating a Password in T-SQL from a Table of Words Dallas Snider2015-04-29
Generating A Password in SQL Server with T-SQL from Random Characters Dallas Snider2015-04-24
How to Clone a SQL Server Login, Part 1 of 3 K. Brian Kelley2015-04-13
Prevent and Log Certain SQL Server Login Attempts Aaron Bertrand2015-04-03
Automated way to get all port information for SQL Server instances K. Brian Kelley2015-03-09
Running SQL Server Databases in the Amazon Cloud: Q & A Sadequl Hussain2015-02-17
SQL Server PCI DSS Security Patching Checklist Tibor Nagy2014-12-25
Script to Drop All Orphaned SQL Server Database Users Percy Reyes2014-12-11
How to troubleshoot SSL encryption issues in SQL Server Tibor Nagy2014-11-25
Verify the databases a SQL Server login can see – and why Aaron Bertrand2014-11-06
Map between SQL Server SIDs and Windows SIDs Aaron Bertrand2014-10-13
How to use module signing for SQL Server security Tibor Nagy2014-09-18
Protect Confidential SQL Server Data Q and A Tim Smith2014-09-17
Auditing Critical Windows Files and Folders for SQL Server K. Brian Kelley2014-09-08
Script to drop SQL Server login and all owned objects using PowerShell Jeffrey Yao2014-08-13
Add a Salt with the SQL Server HASHBYTES Function K. Brian Kelley2014-07-25
How come I can create SQL Server objects but not access these objects K. Brian Kelley2014-04-09
Creating a Kerberos Delegation Table for SQL Server Access Brian P ODwyer2014-03-05
Get SQL Server SPN information for all servers using PowerShell Brian P ODwyer2014-02-18
SQL Server Security Checklist Tibor Nagy2014-02-06
Understanding how SQL Server handles Service Isolation K. Brian Kelley2013-11-26
How to Enable Secondary Decryption of SQL Server Symmetric Keys K. Brian Kelley2013-11-11
Script to Set the SQL Server Database Default Schema For All Users Aaron Bertrand2013-11-08
Using Views to Expose Encrypted Data in SQL Server K. Brian Kelley2013-10-21
Determining Permission Issues for a SQL Server Object K. Brian Kelley2013-09-24
Implementing SQL Server Row and Cell Level Security Daniel Farina2013-09-10
SQL Server Security Community Questions on Windows, Server Level, Database, Roles and more K. Brian Kelley2013-08-06
Understanding the importance of key length with the SQL Server asymmetric encryption algorithms K. Brian Kelley2013-07-23
Understanding the SQL Server Symmetric Encryption Algorithms K. Brian Kelley2013-07-19
Understanding the SQL Server HASHBYTES hashing algorithms K. Brian Kelley2013-07-11
Can I stop a System Admin from enabling SQL Server xp_cmdshell? K. Brian Kelley2013-07-03
The Power of the SQL Server Database Owner K. Brian Kelley2013-03-15
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions K. Brian Kelley2013-03-06
Understanding GRANT, DENY, and REVOKE in SQL Server K. Brian Kelley2013-02-27
Identify blank and weak passwords for SQL Server logins Manvendra Singh2012-09-26
Protecting the SQL Server Backup folder K. Brian Kelley2012-09-19
Using PowerShell to Audit for Blank SA Passwords K. Brian Kelley2012-09-04
Recover access to a SQL Server instance Aaron Bertrand2012-08-30
How to Unlock a SQL Login Without Resetting the Password K. Brian Kelley2012-08-28
Using nmap to scan for SQL Servers on a network K. Brian Kelley2012-08-16
Issues Determining an Individual SQL Server User’s Permissions K. Brian Kelley2012-07-25
SQL Server User Defined Server Roles Brady Upton2012-07-09
Tracking Login Password Changes in SQL Server Aaron Bertrand2012-06-13
Why Can’t I Set a Default SQL Server Schema for Windows Group Login? K. Brian Kelley2012-05-29
Identifying the Tie Between Logins and Users K. Brian Kelley2012-05-23
SQL Server Login Failure Error 18456, Severity 14, State 10 Jugal Shah2012-04-27
How to connect to SQL Server if you are completely locked out Manvendra Singh2012-04-26
How to Connect to a SQL Server Named Instance K. Brian Kelley2012-03-22
Get Back into SQL Server After You’ve Locked Yourself Out K. Brian Kelley2012-03-09
SQL Server Transparent Data Encryption (TDE) Performance Comparison Ben Snaidero2012-03-06
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role Jugal Shah2012-02-29
Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server K. Brian Kelley2012-02-24
Get Alerts for Specific SQL Server Login Failed Events Aaron Bertrand2012-01-17
Grant Truncate Table Permissions in SQL Server without ALTER Table David Bird2012-01-03
Options for cross database access within SQL Server Diana Moldovan2011-11-30
Securing and protecting SQL Server data, log and backup files with TDE Brady Upton2011-11-03
How to Create Secure SQL Server Service Accounts K. Brian Kelley2011-09-28
Script to move all objects to a new schema for SQL Server Brent Shaub2011-09-02
Creating a SQL Server 2012 User Defined Server Level Role Ashish Kumar Mehta2011-06-27
Identify Local Administrators on a SQL Server box using PowerShell K. Brian Kelley2011-06-15
Why System Account is a bad idea for SQL Server Service Account K. Brian Kelley2011-05-25
Unable to see a SQL Server table K. Brian Kelley2011-05-18
Understanding When SQL Server Kerberos Delegation is Needed K. Brian Kelley2011-02-22
SQL Server separation of duties Matteo Lorini2011-02-11
Retrieving SQL Server Fixed Database Roles for Disaster Recovery K. Brian Kelley2011-02-04
Different ways to secure the SQL Server SA Login Jugal Shah2011-01-17
How to check SQL Server Authentication Mode using T SQL and SSMS Jugal Shah2010-12-24
How to Setup Row Level Security for SQL Server K. Brian Kelley2010-12-17
Network communications mechanisms for SQL Server K. Brian Kelley2010-12-10
Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server K. Brian Kelley2010-11-23
Implicit Permissions Due to SQL Server Database Roles K. Brian Kelley2010-11-17
Retrieving SQL Server Permissions for Disaster Recovery K. Brian Kelley2010-10-27
Creating a SQL Server proxy account to run xp_cmdshell Tim Ford2010-10-22
SQL Server Login Issue With Default Database Jugal Shah2010-10-07
Filtering SQL Server Columns Using Column Level Permissions K. Brian Kelley2010-09-30
Filtering Columns in SQL Server Using Views K. Brian Kelley2010-09-21
Extended Protection available in SQL Server 2008 R2 Tim Cullen2010-09-01
Cannot make a role a member of itself error in SQL Server K. Brian Kelley2010-08-30
Understanding How A User Gets Database Access in SQL Server K. Brian Kelley2010-06-14
Replace xp_cmdshell command line use with SQL Server Agent K. Brian Kelley2010-05-19
Secure and disable the SQL Server SA Account Thomas LaRock2010-05-14
Identifying SQL Server logins with overlapping server roles Tim Ford2010-04-23
SQL Server nested securable permissions K. Brian Kelley2010-04-13
Nesting Database Roles in SQL Server K. Brian Kelley2010-04-07
Configure Windows Firewall to Work with SQL Server Atif Shehzad2010-01-27
Configure Password Enforcement Options for Standard SQL Server Logins K. Brian Kelley2009-12-28
Understanding SQL Server fixed database roles K. Brian Kelley2009-12-14
Understanding SQL Server fixed server roles K. Brian Kelley2009-11-24
Options for hiding SQL Server code Atif Shehzad2009-09-01
Dynamic SQL and Ownership Chaining in SQL Server K. Brian Kelley2009-08-24
Breaking ownership chaining within a schema in SQL Server K. Brian Kelley2009-08-11
Grant limited permissions to create SQL views in another schema Part 2 K. Brian Kelley2009-07-27
Grant limited permissions to create SQL views in another schema Part 1 K. Brian Kelley2009-07-20
Understanding Cross Database Ownership Chaining in SQL Server K. Brian Kelley2009-06-29
Ownership chaining in SQL Server security feature or security risk K. Brian Kelley2009-06-23
Database level permissions for SQL Server 2005 and 2008 K. Brian Kelley2009-03-30
Server level permissions for SQL Server 2005 and SQL Server 2008 K. Brian Kelley2009-03-24
How to eliminate SQL Server security issue caused by sp_replwritetovarbin Tim Ford2009-02-23
Security issues when using aliased users in SQL Server Ranga Narasimhan2009-01-28
Extend the REVERT statement using the WITH COOKIE clause in SQL Server Edwin Sarmiento2009-01-06
New Security Catalog Views in SQL Server 2005 and SQL 2008 K. Brian Kelley2008-12-24
Identify SQL Server 2005 Standard Login Settings Jeremy Kadlec2008-04-16
Correct the SQL Server Authentication Mode in the Windows Registry Tim Ford2008-02-25
Script to determine permissions in SQL Server 2005 Jeremy Kadlec2008-02-22
How to determine service related privileges for Sql Server service account Chad Boyd2007-10-15
Assigning DBA Rights in SQL Server Jeremy Kadlec2007-07-10
Accessing the Windows File System from SQL Server Jeremy Kadlec2007-06-12
Windows cannot access the specified device, path or file error Jeremy Kadlec2007-06-11
Who is logging in as the sa login in SQL Server? Jeremy Kadlec2007-04-03
Suspect SQL Server 2000 Database (Part 1 of 2) Jeremy Kadlec2007-03-26
ASP.NET Security for SQL Server Jeremy Kadlec2007-03-13
Hiding instances of SQL Server 2005 Greg Robidoux2007-03-07
SQL Server Service Account Privileges Chad Boyd2007-02-20
SQL Server Database Guest User Account Jeremy Kadlec2007-02-05
SQL Server 2005 Installation Log File Security Vulnerabilities Jeremy Kadlec2007-01-09
When was the last time the SQL Server sa password changed? Jeremy Kadlec2006-12-27
Giving and removing permissions in SQL Server Greg Robidoux2006-12-19
When not to use the sa password in SQL Server applications Jeremy Kadlec2006-12-15
How do I secure a SQL Server extended stored procedure? Jeremy Kadlec2006-09-14
Windows Groups to Support SQL Server 2005 Application Security Jeremy Kadlec2006-08-28
Security Issues with the SQL Server BUILTIN Administrators Group Jeremy Kadlec2006-07-31