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
277 reads
GDPR
The Changing Nature of Data
The way we look at data is changing, especially when data privacy and protection is considered. Today Steve has some thoughts on address data and the implications for cities as well as databases.
2019-07-16
164 reads
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
385 reads
Changing Context and Data Reuse
We don't have strong data consent rules in the US, but Steve thinks we should.
2019-04-23
130 reads
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
196 reads
Fifty Different Ways to Enact Data Privacy Laws?
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.
2018-10-11
2,871 reads
Exhuming the GDPR Bodies
Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares
2018-10-01
2,535 reads
Information Security in Practice
Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses the ways that data manages to migrate around the organisation and the challenges found in protecting that data.
2018-08-16
3,193 reads
How to be Accountable for Handling Personal Data
The GDPR is in full effect but meeting the requirements may still be confusing for many companies. In this article, William Brewer discusses what is needed to ensure compliance, including when a Data Protection Impact Assessment is required. He also explains the Data Protection Officer role.
2018-07-23
3,908 reads
How does GDPR impact your SQL Server Recovery Plans
With GDPR on the imminent horizon, there are many things that Data Platform engineers need to consider with regards to the rights of data subjects. Primary among these is understanding the impact of requests to be forgotten and updates to a person's data when it comes to restoring databases. If you have data that is within the scope of the GDPR then here are some thoughts on extra processes for your DR planning.
2018-03-28
3,302 reads
Blogs
SQLCover 0.5 - Fixes, smaller features and an exciting surprise
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Switch activity in Azure Data Factory: Container with many IFs
By Rayis Imayev
(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with...
Setting Permissions for a SQL Server backup folder–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Using Graph Theory To Group Records
Comments posted to this topic are about the item Using Graph Theory To Group...
More Network Restrictions
Comments posted to this topic are about the item More Network Restrictions
Checking on IFI
Comments posted to this topic are about the item Checking on IFI
Ask SSC