2026-03-23
1,066 reads
T-SQL
2026-03-20
1,395 reads
2026-03-18
1,163 reads
2026-03-06
533 reads
Find Duplicate Rows in SQL Server with a CTE
This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).
2026-03-04
2026-03-04 (first published: 2026-02-27)
744 reads
2026-02-25
1,136 reads
2026-02-20
653 reads
Fun with JSON
Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]
2026-03-09 (first published: 2026-02-18)
4,404 reads
2026-02-18
632 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Jamblang Tlpn/wa:085373737551
Jl. Jamblang Raya No.51, RT.2/RW.1, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCU GREEN GARDEN Telpon/WA:08218168291
BCA KCU GREEN GARDEN Telpon/WA:08218168291.Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
BCA KCP Pasar Tanah Abang. Tlpn:085373737845
Jl. KH Fachrudin 36 Blok D/23, Daerah Khusus Ibukota Jakarta 10250
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