2024-04-19
361 reads
2024-04-19
361 reads
2024-04-03
480 reads
2024-03-21
399 reads
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)
656 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
8,323 reads
2017-07-06
1,295 reads
2015-10-29
1,989 reads
2015-04-16
1,664 reads
2015-04-14
1,780 reads
2014-09-03
1,970 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers