skip to Main Content

Insights

Blog, SQL Server

Sequential Unique Identifiers

Using Globally Unique Identifiers as the primary key for SQL Server database tables has become common place in physical database design. It replaces the use of int identifiers and the IDENTITY clause which date…

read more
Blog, SQL Server

DDL and Transactions

When I started in database management many years ago I worked exclusively on Oracle and I got used to the fact that transactions worked with the DML statements SELECT, INSERT,…

read more
Blog, How-To, SQL Server

SEQUENCE vs. IDENTITY

SQL Server Denali contains a new database object called SEQUENCE that delivers sequential numbers. It complements the existing IDENTITY construct that has a similar objective. IDENTITY has been around as…

read more
Blog, SQL Server

Querying Data Streams in Real-Time

Processing and acting on high volume real-time data is a requirement for many organisations today including: Financial: Processing real time trading information Utilities: Monitoring power consumption, tracking supply vs. demand…

read more
Back To Top