Put Advanced SQL Server Features To Work
SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.
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.
Blogs
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Forums
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers