Blogging at SQLPerformance.com
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
366 reads
Blog Posts
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,037 reads
Dropping Foreign Keys The Lazy Way
Hello!
So, on another blog a long time ago, I wrote a couple of posts about foreign keys and what step...
2017-04-18
124 reads
How to write understandable code for your future self
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
11 reads
I’m Speaking! Code PaLOUsa!
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
364 reads
Power BI and Data Security – Compliance and Encryption
As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....
2017-04-18 (first published: 2017-04-10)
1,551 reads
2017-04-18
249 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica...
2017-04-18
1,717 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. This error mostly appears when we...
2017-04-18
11 reads
T-SQL Tuesday 89 – Roundup
I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how...
2017-04-18
418 reads
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
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