Build a lot of DSN's in a hurry!
This article by Andy Warren offers a free utility that will generate DSN's for all or just a subset of the databases on a server in seconds.
Problem Solving With Information Schema Columns
Directly accessing system tables is discouraged - so what's the alternative? Using the Information Schema should allow you to create code that survives upgrades. Beyond that, what can you do with it? Joe has four great examples to get you started.
SQL and Java Go on a Date
Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.
Where Do I Want To Go Today? - Included Indexes
Where should SQL Server go in the future? What enhancements are needed? Steve Jones continues to explore his wish list for future versions of SQL Server.
Review: Data Compare v3.01
Andy reviewed v1.51 almost two years ago, this week he looks at the latest release that includes one feature he really wanted - the ability to compare and sync text columns.
Upgrading to Windows 2003
Chris has been working through the process of upgrading to Win2003 and has the start of a great checklist along with few lessons learned - stuff that will come in handy it's time for you to do your own upgrade.
A Brief History of SQL
Frank has been part of our community for a while now, posting more than 1000 times (wow!) in our discussion area. He's decided to contribute more of his time by putting together an article that discusses how SQL has evolved.
Automate DTS Logging
DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.
Where Do I Want To Go Today? - Index Tuning Wizard
Where should SQL Server go in the future? Steve Jones continues to explore his wish list for future versions of SQL Server. This article looks at an area where much improvement is needed: the index tuning wizard.
Normalizing Dates
Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance!
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