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 privacy
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.
SQL Audit Not Showing Full SQL Statement
I noticed some MSDN forum posts regarding SQL Audit not showing the full SQL statement. To the end user, it appears that SQL Audit is truncating of SQL statements. I decided to write a quick post to help clear up the confusion for large SQL statements and how they appear in SQL Audit.
GDPR Violations Are Hiding In Your Database – Here’s How To Find Them
Today I was attending the Microsoft Virtual Security Summit, and they posted this poll: As you can see, 22% of the respondents believe that their organization is not impacted by the GDPR. I think that many of that 22% have their head in the sand, something I’ve written about before. I’ve seen an uptick in conversations around GDPR recently. They … Read more
Audit SQL Server Jobs
In this post I will show you how to audit SQL Server jobs. If anyone adds, deletes, or modifies a job you can track who did what, and when.
