SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
Who was that Affinity Masked Man?
Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Introduction to New Data Warehouse Scalability Features in SQL Server 2008
This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.
Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation
Part 1 of this series discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. This installment explains how to install SQL Server Database Engine on the cluster using the Integrated Installation option.
Row Count Transform - SQL School Video
Integration Services contains a tremendous number of ways to transform and work with data. MVP Brian Knight dives into the Row Count transform in this edition of SQL School. This shows how you can monitor the number of rows in a transform.
Scaling The Data Warehouse
Data warehouses aren't just exploding in size, they're also supporting more users and increasingly complex queries, all in shorter time frames. Here's how to make sure yours is ready to scale.
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers