Missing Indexes in the Query Store
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...
2019-03-11
26 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
system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the...
2019-03-04
22 reads
system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management...
2019-03-04
499 reads
Query Store and a READ_ONLY Database
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The...
2019-02-27 (first published: 2019-02-11)
2,098 reads
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from...
2019-02-25
14 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing a few extensions. Buck Woody has a great list...
2019-02-18
6 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing...
2019-02-18
314 reads
Input Into Azure Data Studio
I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going...
2019-02-15 (first published: 2019-01-28)
1,805 reads
Query Store and a READ_ONLY Database
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is...
2019-02-11
7 reads
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is...
2019-02-04
20 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Alamat Kontak Bank BCA KCP Soreang Telp:08218154392
WA CS:08218154392 No. 1-A, Jl. Raya Soreang, Pamekaran, Kec. Soreang, Kabupaten Bandung, Jawa Barat...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers