Category: SQL Server Security
This category contains all SQL Server security related articles.
-
What is SQL Injection? How to prevent it? Examples, best practices, tips and tricks to safeguard your SQL Server databases
This article explains what SQL Injection is, how it works, with easy to understand examples. It also discusses the preventive measures you can take to defend against SQL Injection, along with security best practices, tips and tricks
-
SQL Server Orphan Users and Logins – how to prevent and manage them, and the gotchas to be aware of
This article discusses what are SQL Server orphan user and logins, how to prevent users and logins getting orphanned, and how to manage them. It also talks about the security risks associated with orphan AD/Windows groups.
-
How to check the correct Windows Defender antivirus (AV) exclusions are in place for SQL Server?
Most enterprises run some sort of Antivirus or endpoint protection software on their servers including on SQL Server estates. The software choice depends on things
-
How to generate simple or complex passowrds and numeric OTP codes using T-SQL?
Generating random passwords and One Time Passcodes (OTPs) is a pretty common requirement. I am sure you can find several different versions of T-SQL code
Latest Articles


