Stack Overflow & AI
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get...
2025-06-04 (first published: 2025-05-21)
416 reads
Blog Posts
Why I Created the SQL Rescue Sprint – And How It Works
Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one...
2025-06-04
38 reads
My first year on full disability, wow!
What a year … At the end of May 2024, I went on full time disability. For the first time in my adult life, I was not fully employed....
2025-06-03 (first published: 2025-06-02)
45 reads
Getting References for GenAI Results
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...
2025-06-02
29 reads
KDA: Echoes of Deception - Case 2
The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.
The problem
The police have asked for our assistance, and we’ve...
2025-06-02 (first published: 2025-05-13)
198 reads
SQL Server 2025 Is Here – AI Just Changed Everything!
🔟 Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch #MicrosoftFabric #DataEngineering #TechUpdates #decodeites #mssqlfun
2025-06-02
75 reads
T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots on Pure Storage FlashArray, all from within SQL Server, no external tooling. SQL Server 2025...
2025-06-02 (first published: 2025-05-19)
633 reads
SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!
They run, they return data. So what? Some SQL queries just waste your time and resources. Here’s what to stop writing – and the much smarter alternatives. Sure, your...
2025-05-31
170 reads
A New Word: Falesia
falesia– n. the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you...
2025-05-30
16 reads
Copilot Outside of SSMS Seems to Work
I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t...
2025-05-30
100 reads
Blogs
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
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...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
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