SQL Server DBA, BI Analyst and Microsoft MVP

post.tags

Segurança

tag.total

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

April 18, 2022 5 min read

Continue reading

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

December 26, 2019 13 min read

Continue reading

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

May 12, 2019 4 min read

Continue reading

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

February 24, 2019 7 min read

Continue reading

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

February 24, 2019 16 min read

Continue reading

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

February 12, 2019 10 min read

Continue reading

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

October 20, 2018 12 min read

Continue reading

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

February 28, 2017 7 min read

Continue reading

SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage

February 28, 2017 5 min read

Continue reading

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

February 19, 2017 11 min read

Continue reading