Simplifying Instead Of Triggers
Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
SP_MSForeachtable - Life Without Cursors.
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
Standing Back And Looking At Benchmark Results
What do the TPC-C benchmarks mean to the average DBA? In this article, Neil Boyle steps back and looks at them from a practical view.
Using DMO to Execute a Job
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
Piping a Query to a Text File
The case where one has to send the results of a query to a text file comes up quite often. This quick tip will show you how to output the results of a query to a text file.
Prove Your Case and Win a Buck!
Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.
Quick Tip: Taking a Database Offline
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
Tuning SQL Server Memory in 2 Minutes
You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.
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