2020-07-21
84 reads
Data Privacy and Protection
The Social Impact of Data
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
2020-06-06
80 reads
2020-04-16
125 reads
2020-03-31
63 reads
A Data Controversy
A request to rapidly gather data caused some friction recently. Is that something that organizations ought to be prepared to handle?
2020-03-26
147 reads
Automatic Redaction of PII
Amazon is providing automatic redaction of PII data in there transcription service.
2020-02-29
275 reads
Database Security, People and Processes
Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors needed to build secure systems.
2020-01-22
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
161 reads
Is Data the Future of the Vibrant Web?
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
2019-09-24
169 reads
Don't Get On This Page
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
423 reads
Blogs
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
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...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
SSIS Package is reporting successful however is short 80-100k records
Good morning all, I have been running into a very random weird issue that...
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