VMWare
VMWare is a software product that is great for testing new ideas without having to purchase and install a separate machine.
2001-05-21
4,344 reads
Articles
SQL Server 2000 Black Book
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
2001-05-18
4,611 reads
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,260 reads
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,713 reads
Cell Phone Horror Stories
These are some stories that show the downside of everyone having cell phones.
2001-05-16
1,813 reads
Getting The Best From The Index Tuning Wizard
The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.
2001-05-16
5,388 reads
Using DTS Global Variables
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
2001-05-16
14,837 reads
Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
2001-05-15
14,834 reads
DTS Basics
In this article, we get you started with the core knowledge you'll need to transform your data using DTS.
2001-05-15
11,282 reads
Incorrect Reporting of Date and Time in Performance Log Files
If you use performance log data and need to conduct time-sensitive analysis, watch out for this little feature in Windows 2000.
2001-05-15
3,058 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers