Multiple Table Insert
This article shows how to do conditional multiple table inserts. While it is more script than we typically display, it's interesting and might get you thinking about other uses for the idea.
The Guru's Guide to SQL Server Architecture and Internals
New book! This new book by Ken Henderson (author of other 'GURU' books abou SQL) promises an all inclusive approach to the internals. Sample chapters and other info available by following the link. We'll try to get a review up soon!
Using Xp_cmdshell
One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.
Transferring a SQL Server Diagram
So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.
Another Method of Testing for Updated Columns in a Trigger
This article by Andy Warren discusses how to use if update() in your update triggers to simplify your code. They are easy to use and quite effective!
When's Your Anniversary
Ever need to find out what anniversary dates are coming up? What about a list of birthdays in the near future? This article looks at querying for repeating dates.
Deleting Duplicate Rows
This article presents one technique to be used for removing duplicate rows in a table.
Transcript of SQL Technet Chat
This is a transcript of a recent chat that included our own Brian Knight!
Amazing FUD
How often do you hear FUD either for or against Microsoft? Know what FUD is? Steve Jones recently ran across an article looking at reasons why you don't want Microsoft products in your enterprise, specifically servers. Here's a few comments and a link to the article.
More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
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