Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
Scrubbing Data With DTS : Part 1
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
A Windows 2000 Service Pack 2 Update
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
MesaureUP Test Prep (70-029)
Review of the MeasureUp test preparation serivce actually used by the author for the SQL Server 7 Design exam(70-029).
SP_MSFOREACHDB - Getting a list of databases via TSQL.
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
SQL 7 Bugs on SMP Servers
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
A Look at SQL Server CE
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
ANSI Joins
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
SQL Server 7.0 and 2000 Clustering Resources
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
Your Friend the Computer
You know it is time to reassess your relationship with
your computer when....
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers