Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-10
11 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Non-Stop Learning
There was a recent discussion in the forums here at SQL Server Central regarding the difficulties presented by the constantly shifting technology landscape. The core question was, how on earth do you master stuff? Especially, how do you master things when they're both new and constantly changing? Honestly, you don't. I mean, you can, but […]
2021-05-08
256 reads
Using Extended Events Live Data With Azure
In my last post I showed some shortcomings of Extended Events, however, it is possible to use Live Data with Azure. Let’s explore exactly how that works. To get...
2021-04-26
36 reads
Extended Events and Azure SQL Database
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)
213 reads
The Thriving Data Community
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
105 reads
Things We Are Missing
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
150 reads
Extended Events: Embrace the XML
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)
243 reads
Extended Events: Avoid the XML
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)
373 reads
A Year of “Good Morning!”
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
115 reads
Query Store as an Upgrade Tool
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)
318 reads
Blogs
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Forums
Alamat Kantor BCA KCU Magelang Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang,...
Alamat Kantor BCA KCU KUDUS Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus,...
Alamat Kantor BCA KCU Gang Tengah Telp:08217555651
Hub Via Wa:628217555651 Alamat Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa...
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers