2023-12-21 (first published: 2023-12-20)
497 reads
T-SQL
2023-12-18
366 reads
Searching an Encrypted Column
This article examines the challenges with searches on encrypted data and presents a possible solution that you might use to speed up those queries.
2023-12-15
2,266 reads
2023-12-13
526 reads
SQL GROUP BY Alias - An Oracle feature that would be great in SQL Server
Learn about using an alias in the GROUP BY clause for complex SQL Server code instead of having to rewrite the code in the GROUP BY.
2023-12-13
2023-12-13
251 reads
Window Function Basics - PARTITION BY
This article looks at the basics of the OVER() clause and how the PARTITION section works.
2023-12-08
11,548 reads
2023-12-06
444 reads
2023-12-04
395 reads
2023-11-29
460 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 Kartini Tlpn/wa:085373737551
Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, Daerah Khusus Ibukota Jakarta...
Cara Koreksi Nama Tiket Batik Air
Koreksi Nama pada tiket Batik Air dapat dilakukan melalui saluran resmi Batik Air hubungi...
BCA KCP Pintu Air Tlpn/wa:085373737551
Jl. Pintu Air Raya No.36 Q, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
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