2014-01-15
2,009 reads
T-SQL
2014-01-13
1,770 reads
2014-01-09
2,342 reads
A Simple Recursion Finds Joins
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
2014-01-06
8,196 reads
2014-01-03
2,082 reads
2013-12-31
2,307 reads
2013-12-20
2,353 reads
2013-12-16
1,859 reads
The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)
This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)
2013-12-28 (first published: 2013-12-10)
7,532 reads
2013-12-09
2,368 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
How are you handling sensitive data when using AI for queries or transformations
Hi everyone, I’ve been looking into using AI for helping with data-related tasks (writing...
BCA KCP Jalan Panjang TLP/WA 08216977749
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Daan Mogot Dua TLP/WA 08218573837
Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers