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,345 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,261 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,814 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,390 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,838 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,835 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,284 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
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers