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
476 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
320 reads
Blogs
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers