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.
SQL MVP
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.
Three Ways to Become Data-Centric
When it comes to data, no one is perfect. These days, data is easy to come by, making it a cheap commodity. When data is cheap, attention becomes a premium.
Yes, SQL Server Standard Edition is NUMA Aware
The official documentation suggests that SQL Server Standard edition is not NUMA aware due to Standard having limits on the amount of hardware available.
Fact Checking Some Statements from the AWS re:Invent Keynote
During his keynote at AWS re:Invent, Andy Jassy made some statements that seemed…questionable. Well, questionable to me, at least. Not surprising, the questionable statements focused on databases, data services, and storage. If you are interested in watching the keynote for yourself, you can see it here: https://youtu.be/ZOIkOnW640A The keynote is 2 hours and 44 minutes. … Read more
Quantum Computing Will Put Your Data at Risk
To understand quantum computing, we must first look at how traditional computers operate.
