SQL Server - Password Policies: Expiration, Mandatory Change and Login Lockout After N Attempts May 21, 2022 11 min read Continue reading
Azure SQL Database - How to Create and Manage Users and Logins with SQL and Azure Active Directory (Azure AD) Authentication May 13, 2022 11 min read Continue reading
SQL Server - Encrypting Passwords with Symmetric Encryption Functions: EncryptByPassPhrase and DecryptByPassPhrase December 26, 2019 13 min read Continue reading
How to use WhatsApp and Telegram safely and avoid invasions or message leaks July 28, 2019 13 min read Continue reading
SQL Server - Avoiding Queries on Specific Columns with Column-Level Security (CLS) July 14, 2019 6 min read Continue reading
stp_SecurityChecklist - Best Practices and Security Checklist for SQL Server June 23, 2019 3 min read Continue reading
How was the Live on DevelopersBR channel - SQL Server Security - Are you leaving the key under the mat? May 24, 2019 1 min read Continue reading
SQL Server - How to connect using the DAC (Dedicated Admin Connection) without SQL Browser May 10, 2019 6 min read Continue reading
[Live] - How the webcast "Seven Zomis and One LAW" went - LGPD from the perspective of IT professionals March 21, 2019 2 min read Continue reading
General Personal Data Protection Law (LGPDP or LGPD) applied to SQL Server databases March 17, 2019 26 min read Continue reading
SQL Server - How to avoid brute force attacks on your database February 11, 2019 21 min read Continue reading
SQL Server - How to Use Auditing to Map Real Required Permissions for a User January 20, 2019 8 min read Continue reading
SQL Server - How to disable the "sa" login while minimizing impacts December 22, 2018 6 min read Continue reading
SQL Server - How to hide databases from unauthorized users December 9, 2018 4 min read Continue reading
FREE database check-up + security analysis: Do you need it? December 2, 2018 3 min read Continue reading
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 Continue reading
SQL Server 2016 - How to archive historical tables in Azure with Stretch Database November 11, 2018 17 min read Continue reading
SQL Server 2008 - How to encrypt your data using Transparent Data Encryption (TDE) October 20, 2018 13 min read Continue reading
SQL Server - How to recover the source code of deleted objects (View, Stored Procedure, Function and Trigger) July 8, 2018 9 min read Continue reading
SQL Server 2016 - How to protect your data using Row Level Security (RLS) February 12, 2018 11 min read Continue reading
SQL Server - How to monitor and audit data changes in tables using Change Data Capture (CDC) February 7, 2018 9 min read Continue reading
SQL Server - Trigger to Prevent and Block Changes in Tables February 4, 2018 3 min read Continue reading
SQL Server - Data Masking with Dynamic Data Masking (DDM) January 3, 2018 10 min read Continue reading
SQL Server - Audit Trigger for Permissions and Privileges at Database and Instance Level (GRANT / REVOKE) July 19, 2017 2 min read Continue reading
SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions February 27, 2017 15 min read Continue reading
SQL Server - How to encrypt and decrypt passwords (with Salt) using CLR (C#) December 2, 2016 4 min read Continue reading
SQL Server - How to identify weak, empty, or user-name passwords November 24, 2016 4 min read Continue reading
SQL Server - How to audit permission errors on objects using SQL Profiler (Trace) September 10, 2016 5 min read Continue reading
SQL Server - How to create a data change history for your tables (audit logs) July 17, 2016 7 min read Continue reading
Using the Default SQL Server Trace to Audit Events - fn_trace_gettable() April 23, 2016 5 min read Continue reading
Monitoring DDL and DCL operations using SQL Server fn_trace_gettable April 4, 2016 3 min read Continue reading
Checking Permissions, Privileges and Accesses of a Database User in SQL Server September 7, 2015 21 min read Continue reading
SQL Server - How to Implement Login Audit and Control (Logon Trigger) July 19, 2015 9 min read Continue reading
How to create an audit trigger to log object manipulation in SQL Server July 18, 2015 6 min read Continue reading
How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server June 5, 2015 4 min read Continue reading