2019-05-22
Data Privacy and Protection
The Death of the GDPR
The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.
2019-05-09
495 reads
SQL Data Discovery and Classification
With the recent data protection laws and the implementation of GDPR last year, it is imperative for us to know the type of data our databases are storing. This...
2019-05-08
Join DBAle’s data privacy competition!
Got a favorite story of unusual, unique, or inspired attempts at data privacy. We'd love to hear them on DBAle's data privacy contest. Share your story for the chance to win a box of beer and the glory of getting your name on DBAle
2019-05-08
Security Considerations for ERP Applications
Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the security aspects of ERP systems and some of the techniques used to protect data.
2019-05-08
GDPR in the USA
GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think it applies to you. Grant Fritchey explains why you might be wrong about that and why you need to act now.
2019-05-08
Data breach notifications don’t need to be scary
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?
2019-05-03
Defending Democracies Against Information Attacks
To better understand influence attacks, the Berkman Klein Center for Internet & Society proposed an approach that models democracy itself as an information system and explains how democracies are vulnerable to certain forms of information attacks that autocracies naturally resist.
2019-05-03
Why Isn't GDPR Being Enforced?
Politico has a long article making the case that the lead GDPR regulator, Ireland, has too cozy a relationship with Silicon Valley tech companies to effectively regulate their privacy practices.
2019-05-03
Scary Data Collection
More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren't always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.
2019-04-18
323 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers