Extended Events: system_health and a Long Running Query
Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...
2020-03-16 (first published: 2020-03-09)
567 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
A Rose By Any Other Name
There is only one kind of execution plan within SQL Server. I’ve said this several times on this blog. Now, I’d like you to go and read this excellent...
2020-03-11 (first published: 2020-03-03)
334 reads
Query Store, Plan Forcing, and DROP/CREATE
I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just...
2020-03-09 (first published: 2020-03-02)
416 reads
Are You Still Worried About Data in the Cloud?
There really are technology stacks and business use cases that should never be moved off of big iron. Then there’s the rest of us. Chances are very high if...
2020-03-03 (first published: 2020-02-27)
559 reads
Why I Support Code Automation Tools Like ORMs
I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in...
2020-02-25 (first published: 2020-02-17)
544 reads
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another example comes from the stack of audit events that exist only in Extended Events. One...
2020-02-24
59 reads
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done some amazing stuff over the years. We’re going to be doing even more amazing stuff...
2020-02-24
35 reads
2020-02-20
334 reads
Be Kind
Simply put, we are not always going to agree. Please, take this as someone who was nicknamed “The Scary DBA” for reasons comic and tragic. I’ve screwed up a...
2020-02-18 (first published: 2020-02-11)
479 reads
2020-02-17
175 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 Mohamad Toha No.Telp:087757645171
Whatsapp:087757645171 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253
BCA KCU ASEMKA No tlpon:083138717148
Whatsapp:083138717148.Jl. Asemka No.27-30, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta...
BCA KCU BLITAR telp:cs.083188951403
Whatsapp:083188951403 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
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