2023-06-05
360 reads
T-SQL
2023-05-22
404 reads
Common Table Expression Basics
Learn the basics of how CTEs work with a few examples in this article.
2023-05-31 (first published: 2023-05-19)
5,842 reads
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
2023-05-19
2023-05-15
392 reads
Find 40 Problems in this SQL Server Stored Procedure
I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.
2023-05-10
2023-05-01
460 reads
2023-04-24
568 reads
2023-04-19
644 reads
2023-04-17
445 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