Adaptive Query Processing – Batch Mode Adaptive Join
Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators
Effectiveness
Today Steve Jones notes that your software should handle the load and work, but it needs to get done as well.
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
Automatic Database Seeding
Set up and use the automatic databases seeding feature for Availability Groups.
Innovation Needs Information
We need data to innovate more. Steve Jones reminds us this means opportunity for many of us.
It's an Exciting Time
I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
The GDPR Sky is Falling
GDPR is coming and many are concerned. Steve Jones has a few thoughts today.
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
Andy Bca Finance. Tlp/wa:08218168235
JQGR+9P9, Grogol, Kec. Limo, Kota Depok, Jawa Barat 16533
Trik cara reschedule Garuda Indonesia
Trik tatacara Reschedule tiket Super Air Jet dapat dilakukan melalui situs resmi, aplikasi, WhatsApp...
BCA KCP Grage Mall Cirebon No. Telp 083139530154
Whatsapp: 083139530154 Jl. Tentara Pelajar No.1, Kejaksan, Kec. Kejaksan, Kota Cirebon, Jawa Barat Cirebon,...
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