More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.
2009-12-30
17,815 reads
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
978 reads
2009-12-21
5,102 reads
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,488 reads
2009-12-18
3,282 reads
2009-12-17
3,625 reads
Use this script to search for SQL Server logins who use weak password
2010-01-05 (first published: 2009-12-16)
4,343 reads
2009-12-16
3,094 reads
2009-12-15
3,635 reads
2009-12-14
3,921 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...
Jl. Kramat Kwitang No.29, Kwitang, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal Sudirman No.1,...
Tlpn/wa:085373737551 Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih, Kota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers