2023-02-17
602 reads
T-SQL
Manage Data Over Time with SQL Server MERGE Statement
Once data is in a table it needs to be maintained....
2023-02-15
The Growth of T-SQL
I saw this tweet recently, where Richie Rump asked what has changed in T-SQL since the SQL Server 2012 version. A few people from Microsoft responded that there were changes in all versions, and while I think some versions have few changes, I decided to look. SQL Server 2012 introduced the window functions with the […]
2023-02-13
357 reads
2023-02-06 (first published: 2023-02-03)
512 reads
2023-02-06 (first published: 2023-01-23)
741 reads
2023-02-06 (first published: 2023-01-20)
474 reads
2023-02-06 (first published: 2023-01-16)
506 reads
Getting started with ROUND() and Its Use Cases
Learn the basics of the ROUND() function in this article.
2022-12-02
3,079 reads
How to get IO statistics of SQL Server database files
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
10,253 reads
2022-11-04
410 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