2020-05-26
634 reads
T-SQL
2020-05-25
590 reads
The Products-Often-Purchased-Together Problem Solved in R
Learn how to analysis products that might be sold together using R and SQL Server.
2020-05-19
2,952 reads
Always on AG Dashboard report
This script can be used to generate Dashboard report for Always-on AG databases. Script can be placed in SQL Agent to generate report.
2020-05-22 (first published: 2020-05-12)
3,163 reads
2020-05-11
708 reads
2020-04-27
673 reads
A Solution for the Bin Packing Problem
A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions
2020-05-14 (first published: 2020-04-23)
5,721 reads
2020-04-23
844 reads
2020-04-20
877 reads
2020-04-16
629 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 Kas Plaza Kenari Mas Telpon/WA:087768193341
BCA KCP Kas Plaza Kenari Mas Telpon/WA:087768193341.Plaza Kenari Mas, Lt 4, Blok K37/38, Jl....
BCA Finance WTC Mangga Dua. Tlp:085373737845
Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....
BCA KCP Pasar Kenari Telpon/WA:087768193341
BCA KCP Pasar Kenari Telpon/WA:087768193341.Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, Kenari, Kec....
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