Create and Use an Email Alias
If you are using Microsoft 365, you can create and use an email alias through your admin center.
data security
101 Ways to Say NO to SysAdmin Requests
As an admin, you often get requests from developers asking for elevated permissions on servers and systems. Inside of SQL Server, this is called ‘sysadmin‘ access. As you can imagine, it is not a good idea to give this level of access to just anyone. I thought I would write a post to help you … Read more
Use SQLMap to Connect Directly to Azure SQL Database
I’ve written before about using sqlmap to perform sql injection testing against a website. It is also possible to use sqlmap to connect directly against a database. In this post I will show you how to use sqlmap to connect directly to Azure SQL Database. Once connected you can enumerate objects, open a shell, or … Read more
Modify SQL Audit for Azure SQL Database
At SQL Server Live last November, I demonstrated enabling SQL Audit for Azure SQL Database. During the class discussion I explained you must use Powershell to modify SQL Audit for Azure SQL Database. So, that’s my post today, showing you how it is done. By default, SQL Audit for Azure SQL Database will enable the … Read more
Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
SQL Server ships with an internal system function, PWDCOMPARE(), that we can use to find SQL logins with weak passwords.
Happy Data Privacy Day!
I decided that in the spirit of celebration for Data Privacy Day I would share with you some common tips, tricks, and advice on keeping your data private.
