I’ve seen the term polyglot persistence floating around Redgate a bit recently in the marketing department. I haven’t really seen this term anywhere, and I wonder if you have....
2024-07-05 (first published: 2024-06-17)
132 reads
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...
2024-07-03 (first published: 2024-06-16)
102 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced! We’re kicking off at 1pm UTC on August 8th (8th of the 8th…get it? 🙂...
2024-07-03
66 reads
After a data migration, we needed to decommission the old Azure SQL DBs, but we wanted to keep a copy in case we needed anything later. Enter exporting an...
2024-07-03 (first published: 2024-07-02)
412 reads
I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server...
2024-07-03
634 reads
A couple of weeks ago, a developer came to me and wanted to know how to figure out what was causing a deadlock. I honestly didn’t know where to...
2024-07-03 (first published: 2024-06-14)
57 reads
Have you heard the news about the new Power BI Project files? Okay, maybe not news anymore since it was announced over a year ago. Just in case you...
2024-07-02 (first published: 2024-07-01)
97 reads
DIVERSIFY! We devote a lot of time to mastering the technology that we are passionate about or use for our jobs. For example, I specialized in Microsoft business intelligence,...
2024-07-02
86 reads
I wrote an article that was published on SQL Server Central on how to get your scripts into Git. This post adds a few more thoughts on how you...
2024-07-01
354 reads
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in Fabric, not to be confused with deployment pipelines), you will most likely have some activities...
2024-07-01 (first published: 2024-06-13)
449 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Jend. Sudirman No.99, RT.001/RW.007, Kranji, Kec. Bekasi Bar., Kota Bks, DKI Jakarta 17135
Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, Pusaka Rakyat, Kec....
BCA KCP Arundina Cibubur Telpon/WA:085188120691 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers