Implementing Common Reference Data in a Data Warehouse
This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.
2007-12-04
2,734 reads
Articles
SQL Server Indexes: The Basics
Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.
2007-12-04
5,686 reads
Ten Ways To Lose Your DBA Job
We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.
2007-12-03 (first published: 2006-11-30)
67,795 reads
Toward Integrity - Part 1
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
2007-12-03
4,949 reads
Business Analysis: A Guide to Better Business Requirements
This article presents ten business analysis guidelines, representing best practices from successful projects.
2007-12-03
3,044 reads
SQL Server 2005 Bug Alert: Merge Replication Could Mean Data Loss
The SQL Server 2005 merge replication engine introduced breaking changes that can cause data loss for both MSDE and SQL Server Express subscribers. Find out how this bug manifests itself in a real-world scenario.
2007-12-03
2,048 reads
SQLonCall: Mock Interview, Part I
The first part of a great video series from Chris Shaw of SQL Oncall that walks you through a mock interview and gives advice on how you can present yourself in the best light.
2007-12-03
2,081 reads
Altering a column on a Replicated Table
SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.
2007-11-30 (first published: 2005-01-19)
45,736 reads
Source Control in SQL Server
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
2007-11-30 (first published: 2006-12-04)
14,276 reads
Accessing and Updating Data in ASP.NET 2.0: Handling Database NULL Values
Dealing with NULL database values in ASP.NET.
2007-11-30
2,302 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers