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.
2023-05-24 (first published: 2023-05-19)
407 reads
A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell
2018-07-03
7,756 reads
2017-07-06
1,294 reads
2015-10-29
1,989 reads
2015-04-16
1,664 reads
2015-04-14
1,779 reads
2014-09-03
1,970 reads
2014-08-28
2,168 reads
2014-01-27
1,478 reads
2012-11-20
2,109 reads
One of the nice things about the Microsoft Connector for Oracle is that it...
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Hi everyone My SQL query is close to 1000 lines with 17 separate calcs...
Hi folks I would like to get your views about partitioning a huge table...
Ask SSC