An audit finding relating to production data, containing customer identifiable data, in a UAT environment, prompted this simple script, which completely scrambles data in such a way that the original value can not be reconstituted.
create view dbo.random
as
select convert(int,rand()*10) random; /*the multiplier can be any number, I just used 10 to demo*/GO
CREATE OR ALTER FUNCTION dbo.scramble (@In NVARCHAR(4000))
RETURNS NVARCHAR(4000)
AS
BEGIN
declare @a nvarchar(4000)='',@li tinyint=0;
while @li < len(@In)
begin
select @a+= nchar(ascii(substring(@In,@li+1,1))^random) from dbo.random;
select @li+=1;
end
RETURN @a;
END
GO
select dbo.scramble ('absoltion z, ABSOLTION Z'); 
2023-03-27
286 reads
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,536 reads
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
2021-05-10
162 reads
Apple buys a company every few weeks. The data integration for this must be a large effort.
2021-03-31
91 reads
2021-03-04
367 reads