Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,331 reads
Andy Jones
Auto Generate Your Database Documentation
Script provided to create missing extended properties allowing you to auto generate your database documentation.
2017-11-17 (first published: 2016-02-25)
8,976 reads
Initial Installation of the Production Database
Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production.
2003-02-04
6,354 reads
Loading a Series of Flat Files
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,237 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Tanah Abang 2 Tlpn/wa:085373737551
Jl. Tanah Abang II No.49 & 51, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...
BCA KCP Sabang Tlpn/wa:085373737551
Jl. H. Agus Salim No.57 B, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, Daerah...
BCA KCP Bungur Tlpn/wa:085373737551
Jl. Bungur Besar Raya No.32 & 32A, Gn. Sahari Sel., Kec. Kemayoran, Kota Jakarta...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers