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,356 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
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
634 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
432 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,221 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
610 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,712 reads
PASS Board Update: Post-Summit 2016
Monday
I got in on Sunday and chose to have a small dinner with a couple of friends, quiet, preparing.
Monday was...
2016-11-08
428 reads
sp_executesql Is Not Faster Than an Ad Hoc Query
This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...
2016-11-07
1,202 reads
Emotions and Decision Making
Today we have a guest editorial from Grant Fritchey that looks at emotions and how they can affect our decision making.
2016-10-28
108 reads
SQL Cruise as a Speaker and Sponsor
SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, severaltimes, about...
2016-10-28 (first published: 2016-10-18)
1,134 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers