Interview with Chuck Kelley - Part I
An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.
XML Workshop XVII - Writing a LOOP to process XML elements in TSQL
Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.
Data Comparison with Data Dude
In this article Dinesh Priyankara shows how Visual Studio Team Edition for Database Professionals can be used to perform data comparison.
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
SQL Server Database Requirements
In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.
Configuring SQL Server 2005 Failover Settings in Windows Server 2003
This article is to discuss a number of important cluster Group and Resource properties that have significant impact on failover behaviors.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
The HierarchyID Datatype in SQL Server 2008
This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Prompt Requests
Comments posted to this topic are about the item Prompt Requests
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers