CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,854 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
Carpenters vs. DBAs
Let’s get the caveat out of the way up front, I work for a tool vendor.
If you look around at...
2016-07-05
1,240 reads
SQL Server 2016 is Out and It's Fabulous!
On the First of June, SQL Server 2016 was officially released. While it is still early days to measure the full impact of the release, the one thing that is exceedingly clear is that this is a very successful software release. There have been very few complaints online beyond the standard heard during any upgrade: […]
2016-06-27
167 reads
Because
Because there’s nothing else I can do at the moment.
The post Because appeared first on Home Of The Scary DBA.
2016-06-14
534 reads
Choosing the Right SQL Server Edition
Post #6 of #entrylevel #iwanttohelp in support of Tim Ford’s (b|t) beginner’s initiative.
If you’re just getting started with SQL Server,...
2016-06-13
1,250 reads
Elastic Query in Azure SQL Database and Views
The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...
2016-06-13 (first published: 2016-06-06)
2,161 reads
Resources for Learning Azure Data Platform
You want to start working with Azure and the Azure Data Platform, but getting started is not easy. Just knowing...
2016-06-10 (first published: 2016-06-02)
1,522 reads
Independent Azure Data Platform Instructors
The Azure Data Platform is taking off. I’m seeing more and more interest on the forums, at conferences and in...
2016-06-01
434 reads
Precedence Goes to Query Store or Plan Guide?
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
943 reads
A Moment For Reflection…
While this is a personal blog, I try to keep it focused on either technical topics or personal development and...
2016-05-25
497 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...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Forums
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
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers