This a script to compare two parallel data streams, in my case production and QA. Two extracts were created and a mapping table was created as a look-up between old and new recordids. A final table TestResults was created to hold the results of the comparison. The comparison table names and join syntax are controlled […]
2003-08-21
161 reads
This script to designed to kill all connections for all users to a specified database. This is used in conjunction with an automated QA/Dev database restore/refresh process run as a DTS job.
2003-08-21
737 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Whatsapp:087757645171 Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa Barat...
WhatsApp 083110611866Jl. Pahlawan Ruko Rempoa 8 No.Kav 9, RT.4/RW.13, Bintaro, Kec. Pesanggrahan, Kota Jakarta...
Whatsapp.083831617937 Jl. Tidar No.109, Petemon, Kec. Sawahan, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers