GDPR

SQLServerCentral Article

Design your systems and processes for auditability

  • Article

I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation.  The UK Financial Services Authority (FSA) was seen to be a toothless tiger.  The UK government replaced the FSA with two separate bodies, each with its own more […]

(3)

You rated this post out of 5. Change rating

2021-10-25

1,577 reads

SQLServerCentral Editorial

Scary Data Collection

  • Editorial

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.

You rated this post out of 5. Change rating

2019-04-18

321 reads

External Article

Fifty Different Ways to Enact Data Privacy Laws?

  • Article

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

External Article

Exhuming the GDPR Bodies

  • Article

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

External Article

Information Security in Practice

  • Article

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

Blogs

What’s New at AWS re:Invent 2025 – Day2 Highlights

By

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...

Quantum Computing and SQL Server Article Is Up

By

In parallel with the presentation I gave at the PASS Data Community Summit on...

SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)

By

 SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...

Read the latest Blogs

Forums

Improving update statistics process for 6 big tables

By jellybean

Recently I was asked to investigate the update statistics process on a particular database....

Adding a Lot of Seconds

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding a Lot of Seconds

SQL Server Licensing is Simple

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Licensing is Simple,...

Visit the forum

Question of the Day

Adding a Lot of Seconds

When does this code work and when does it fail?

DECLARE @BaseDate DATETIME = '1900-01-01';

SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];

See possible answers