Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...
2021-04-22 (first published: 2021-04-19)
211 reads
A while back I wrote an editorial about how I believed the data community would easily continue after the PASS organization was no more. I'm pleased as punch to be able to report that I was right. Not because I enjoy being right (I do, who doesn't), but because I care very much for the […]
2021-04-18
103 reads
I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication. Strictly on a personal level, I miss […]
2021-04-17
148 reads
While XML is, without a doubt, a giant pain in the bottom, sometimes, the best way to deal with Extended Events is to simply embrace the XML. Now, I...
2021-04-12 (first published: 2021-04-05)
242 reads
One story I hear over and over goes like this: I tried setting up Extended Events, but then I saw the output was XML so I stopped. Look, I...
2021-04-08 (first published: 2021-03-29)
372 reads
Just a little over a year ago, I started posting a “Good Morning!” tweet on Twitter every work day. I’ve kept it up for over a year and I’d...
2021-04-06
113 reads
There are a lot of uses for Query Store, but one of the most interesting is as an upgrade tool. We all know that upgrades in SQL Server can...
2021-03-29 (first published: 2021-03-22)
316 reads
Hello all! I wanted to apologize to you. I haven’t been keeping up with the blog well at all over the last couple of months. I have simply been...
2021-03-15
30 reads
I've always been fascinated by history. For a long time growing up, my plan was to become a history teacher. While that didn't work out, I've continued to read quite a lot of history, both popular and scholarly works. One of the things about it that I find most fascinating are the stories. History is […]
2021-03-06
48 reads
As part of my job, I’ve been tasked with doing some of my work in Oracle, so I’m learning Oracle. Allow me to share a little of my pain...
2021-02-19 (first published: 2021-02-15)
336 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...
KM 1 No 2, Jl. RTA Milono, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan...
Jl. Alianyang No.16A, RT.023/RW.008, Melayu, Kec. Singkawang Bar., Kota Singkawang, Kalimantan Barat 79122
Jl. Jatinegara Bar. No.4 C 1, RT.2/RW.4, Wil, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers