Blog Posts

Blog Post

Trailing Spaces in SQL Server

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

2019-07-03 (first published: )

1,043 reads

Blog Post

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Finding Data...

2019-07-02

28 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Kelapa Gading Hub.0813•7887•595

By ilyasahmad

BCA KCP Kelapa Gading Hub.0813•7887•595.Jl, Jl. Boulevard Raya Blok FX No.9-10, Klp. Gading Tim.,...

BCA KCP Cempaka Putih TLP/WA 0821•697•7749

By trevor.stevenson

Jl. Letjen Suprapto No.30 EF, Harapan Mulya, Kec. Kemayoran, Kota Jakarta Pusat, Daerah Khusus...

BCA KCP WTC Mangga Dua Hub.0813•7887•595

By ilyasahmad

BCA KCP WTC Mangga Dua Hub.0813•7887•595.Gedung WTC Mangga Dua Lantai Ground Lobby Selatan dan...

Visit the forum

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