The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
2022-03-16
127 reads
Data Privacy and Protection
Location Data Is Not Anonymous
The world of public data is scary for Steve, even when the data is aggregated. It appears that keeping information private is becoming harder, and perhaps, impossible.
2021-10-04
140 reads
Tracking, Privacy, and Lots of Data
Apple has implemented some privacy controls for customers, which some advertisers don't like, but Steve agrees with.
2021-06-16
122 reads
Agree or Lose Features
Forcing users to agree to a new EULA or removing features seems like a bad idea to Steve.
2021-05-26
149 reads
Differential Privacy
Steve looks at a technique that some think will allow more data to be used in research and training.
2021-05-24
83 reads
Finding Legal Data
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
2021-04-19
151 reads
Getting Started with Azure Purview
Introduction Azure Purview is Microsoft’s unified data governance service that helps you discover and get insight into your available data. It replaces Azure Data Catalog and is now based on Apache Atlas, one of the leading open-source data governance and metadata frameworks. Apache Atlas was created by Hortonworks and big names within finance, pharma, etc. […]
2021-02-18
4,506 reads
Data Privacy Grows in California
Changes in data privacy law in California are demanded by consumers.
2021-01-23
55 reads
The Best Way to Protect Sensitive Data
Steve has a thought on the best way to protect sensitive data.
2021-01-07
129 reads
2020-12-14
126 reads
Blogs
Quick Filtering in SSMS–#SQLNewBlogger
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Forums
High tempdb usage alternatives
Hi We have an stored procedure which runs frequently and it contain logic in...
high latency in sql server transactional replication
Hi I am new to replication and we have database of size around 2TB...
get week number of month
I want to query a table that has a datetime column ([CreateDateTime]) and get...
Ask SSC