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.
Data Security and Privacy
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.
No, You Don’t Need a Blockchain
The hype around blockchain technology is reaching a fever pitch these days. Visit any tech conference and you’ll find more than a handful of vendors offering blockchain in one form or another. This includes Microsoft, IBM, and AWS. Each of those companies offers a public blockchain as a service.
Unpacking the Language of GDPR
GDPR compliance may be hard, but nothing worthwhile is ever easy. Just a quick note today to brag about my company, SolarWinds, and their approach to GDPR.
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.
Data Collection: How To Gather Meaningful Data
The ability to gather meaningful data is as important as the insights the data can generate. Those insights, the end result of any data collection, is what people see and judge.
