Storing XML Data in a Relational Database
Use familiar XML markup to extend the capabilities of your relational database.
The “sys.dm_os_performance_counters” Dynamic Management View
SQL Server performance can be tracked and monitored by using performance counters. For SQL Server 2005 performance counters can be displayed by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV).
Fixing Orphaned Users
Migrating databases between production, test, development and train servers is something that a DBA needs to deal with constantly. During migration, one of the inevitable issues we need to deal with is concept of Orphaned Users.
Advanced Matrix Reporting Techniques
In SQL Reporting Services, the native Matrix control provides a crosstab view of data, similar in behavior to a PivotTable in MS Excel. Rows and columns will have intersecting points of data which is often useful in time based reporting . David Leibowitz shows you how...
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.
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.
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.
The Weekly Update for Dec 2, 2007
A few notes and comments on the database news from the previous week.
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.
Business Analysis: A Guide to Better Business Requirements
This article presents ten business analysis guidelines, representing best practices from successful projects.
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers