PASS Board: Year-End Wrap-Up
This month concludes my second full year on the PASS Board of Directors and my first full year on the...
2016-12-19
418 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
2016-12-14
1,175 reads
OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR...
2016-12-12
642 reads
Query Data Store Data
The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics...
2016-11-28 (first published: 2016-11-21)
1,282 reads
PowerShell to Test a Query
So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...
2016-11-23
1,362 reads
SQL Server on Linux: Boring
As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of...
2016-11-22
637 reads
Book Review: Marshmallow Test
Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...
2016-11-18
441 reads
Reinforcing the Importance of Statistics on Row Estimate
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,230 reads
Azure Data Platform Learning Resources
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
621 reads
Stored Procedures Are Not Faster Than Views
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,729 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers