Security — Dirceu Resende

SQL Server - Password Policies: Expiration, Mandatory Change and Login Lockout After N Attempts

May 21, 2022 11 min read

SQL Server - Beware of the SecurityAdmin Server Role: Using Privilege Escalation to Become Sysadmin

April 18, 2022 5 min read

SQL Server - Encrypting Passwords with Symmetric Encryption Functions: EncryptByPassPhrase and DecryptByPassPhrase

December 26, 2019 13 min read

SQL Server - Avoiding Queries on Specific Columns with Column-Level Security (CLS)

July 14, 2019 6 min read

stp_SecurityChecklist - Best Practices and Security Checklist for SQL Server

June 23, 2019 3 min read

How was the Live on DevelopersBR channel - SQL Server Security - Are you leaving the key under the mat?

May 24, 2019 1 min read

SQL Server - Security Checklist - A stored procedure with more than 70 security items to validate your database

May 12, 2019 4 min read

SQL Server - How to connect using the DAC (Dedicated Admin Connection) without SQL Browser

May 10, 2019 6 min read

[Live] - How the webcast "Seven Zomis and One LAW" went - LGPD from the perspective of IT professionals

March 21, 2019 2 min read

General Personal Data Protection Law (LGPDP or LGPD) applied to SQL Server databases

March 17, 2019 26 min read

SQL Server - Understanding the Risks of the TRUSTWORTHY Property Enabled in a Database

February 24, 2019 7 min read

SQL Server - How to avoid SQL Injection? Stop using Dynamic Query with EXEC(@Query). Now.

February 24, 2019 16 min read

SQL Server - How to avoid and protect yourself from Ransomware attacks, like WannaCry, on your database server

February 12, 2019 10 min read

SQL Server - How to avoid brute force attacks on your database

February 11, 2019 21 min read

SQL Server - How to Use Auditing to Map Real Required Permissions for a User

January 20, 2019 8 min read

SQL Server - How to disable the "sa" login while minimizing impacts

December 22, 2018 6 min read

SQL Server - How to hide databases from unauthorized users

December 9, 2018 4 min read

FREE database check-up + security analysis: Do you need it?

December 2, 2018 3 min read

SQL Server - How to Use EXECUTE AS to Run Commands as Another User (Impersonate) and How to Prevent It

November 13, 2018 29 min read

SQL Server 2016 - How to archive historical tables in Azure with Stretch Database

November 11, 2018 17 min read

SQL Server 2008 - How to encrypt your data using Transparent Data Encryption (TDE)

October 20, 2018 13 min read

SQL Server 2016 - How to encrypt your data using Always Encrypted

October 20, 2018 12 min read

SQL Server - How to recover the source code of deleted objects (View, Stored Procedure, Function and Trigger)

July 8, 2018 9 min read

SQL Server - How to enable the sa user

July 8, 2018 4 min read

SQL Server 2016 - How to protect your data using Row Level Security (RLS)

February 12, 2018 11 min read

SQL Server - How to monitor and audit data changes in tables using Change Data Capture (CDC)

February 7, 2018 9 min read

SQL Server - Trigger to Prevent and Block Changes in Tables

February 4, 2018 3 min read

SQL Server - Data Masking with Dynamic Data Masking (DDM)

January 3, 2018 10 min read

SQL Server - Audit Trigger for Permissions and Privileges at Database and Instance Level (GRANT / REVOKE)

July 19, 2017 2 min read

SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole

February 28, 2017 7 min read

SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions

February 27, 2017 15 min read

SQL Server - How to copy/replicate a user's permissions

February 19, 2017 11 min read

SQL Server - How to identify weak, empty, or user-name passwords

November 24, 2016 4 min read

SQL Server - How to audit permission errors on objects using SQL Profiler (Trace)

September 10, 2016 5 min read

Using the Default SQL Server Trace to Audit Events - fn_trace_gettable()

April 23, 2016 5 min read

Auditing in SQL Server (Server Audit)

October 22, 2015 11 min read

Checking Permissions, Privileges and Accesses of a Database User in SQL Server

September 7, 2015 21 min read

SQL Server - How to Implement Login Audit and Control (Logon Trigger)

July 19, 2015 9 min read

How to create an audit trigger to log object manipulation in SQL Server

July 18, 2015 6 min read

How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server

June 5, 2015 4 min read