Article: SQL Server Sample Databases
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases and what you need to know in order to use them yourselves.
2025-07-21
341 reads
Blog Posts
PostgreSQL 17: A Deep Dive into New Features, Benefits, and Enterprise Impact
PostgreSQL 17 introduces a new era of innovation in open-source database technology. This release focuses on performance, scalability, developer productivity, and enterprise-grade reliability. Each feature in PostgreSQL 17 is...
2025-07-21
1,042 reads
The Evolution of Data: From Databases to Spark to Lakebases
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling their jeans or people with bellbottoms or the 80’s music playing in grocery stores… It’s...
2025-07-18
118 reads
PostgreSQL Timeline: History and Evolution
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-17
114 reads
Why Microsoft Fabric Signals the Next Wave of Data Strategy
In today’s data-driven economy, organizations are no longer asking if they should invest in data, they are asking how fast they can turn data into decisions. The answer, increasingly,...
2025-07-17
375 reads
DP-203: The Complete Guide to Becoming a Microsoft Azure Data Engineer Associate
In today’s data-driven world, organizations rely on skilled professionals to design, build, and maintain scalable data solutions. The DP-203: Data Engineering on Microsoft Azure certification is your ticket to...
2025-07-16
114 reads
SQL Server Database Compatibility Levels
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve ever upgraded a SQL Server instance and something just broke in your application, chances are...
2025-07-16
455 reads
Understanding Zonal Redundancy in Azure SQL MI
Do you know what happens when you enable zonal redundancy for your SQL managed instance? Lets define it first (in the context of Business-Critical tier) – zonal redundancy is...
2025-07-16
91 reads
A field note: AI Ambition vs. Operational Reality in 2025
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from failure — and why most companies still underestimate what it really takes to turn strategy...
2025-07-15 (first published: 2025-07-14)
29 reads
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature enabling you to distribute read-only workloads such as reporting and analytics across built-in replicated secondary...
2025-07-15
110 reads
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