Continued thinking about my Journey blog where we have to look back at the revolutionary of SQL Server till SQL Server 2025. I would like to brief more on...
2026-03-27 (first published: 2026-03-26)
10 reads
In today’s world, this might mean something different, but in 2010, we had this value: In our context, this was about being open and transparent. This is the text...
2026-03-27
33 reads
A while back I posted about a couple of side projects that I’ve been working on when I get the chance. One of those was the Burrito Bot…a bot...
2026-03-27
76 reads
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
Originally published in 2023, this post never made it into Google's index, so I'm republishing it...
2026-03-26
52 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL...
2026-03-25 (first published: 2026-03-11)
317 reads
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released patches for SQL Server to address privilege escalation vulnerabilities in supported versions. Time to patch!
2026-03-25 (first published: 2026-03-12)
498 reads
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is...
2026-03-25 (first published: 2026-03-24)
89 reads
We’re coming back to New York, which is exciting for me. I love NYC. The Redgate Summit 2026 – New York City comes back on May 5, 2026. You...
2026-03-25
89 reads
A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...
2026-03-23 (first published: 2026-03-06)
175 reads
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...
2026-03-23 (first published: 2026-03-07)
297 reads
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
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