Using COM to Output Queries to a Text File
This article presents a method of outputting the results of a query as a tab delimited text file using COM.
Troubleshooting ASP and ADO Errors
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
Using Java to Encrypt Passwords
Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.
How Many Business Days Are There?
Ever had to calculate the number of business days between two dates? This article presents a way to solve this problem in T-SQL.
Tuning and Sizing Windows 2000
Steve Jones's review of a great guide for tuning the Windows 2000 OS.
Harnessing the Power of SQL's Analysis Services
WebCast! June 27, 2001 from 9:00am to 10:30am Pacific Time. Registration closes 24 hours prior to the event start time.
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers