Identity Columns Aren’t Automatically Primary Keys

Identity columns (automatically incrementing numbers) are fairly common in SQL Server, having the merit of simplicity and pretty good performance. As such they are often used as primary keys, and that’s fine too (unless you subscribe to natural keys at all costs). But, they aren’t automatically primary keys. If you want it to be the […]

The Architectural Journal

Somehow had completely missed this one, The Architectural Journal is published quarterly in PDF format. Issue 22 seems to be the latest, and here is what it shows in the table of contents: Foreword Data-Warehouse Principles for Supporting Enterprise-Enabled BI Applications BI-to-LOB Integration: Closing the Cycle Increasing Productivity by Empowering Business Users with Self-Serve BI […]