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 […]
2021-10-25
1,554 reads
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
156 reads
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
423 reads
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
343 reads
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
469 reads
We don't have strong data consent rules in the US, but Steve thinks we should.
2019-04-23
254 reads
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
317 reads
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
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
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
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Want to blend your love of marketing with the power of data? Becoming a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers