On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR is an out-of-band update...
2023-02-24 (first published: 2023-02-15)
1,272 reads
I’m pleased to announce that I’ll be talking about how you can migrate your SSIS skills to Azure Data Factory at Data Saturday Rheinland. At the time of writing...
2023-02-24
16 reads
In my previous post, I set up the Flyway Desktop projects for SQL Server and PostgreSQL. I also added a table to each platform for development. In this post,...
2023-02-24 (first published: 2023-02-13)
217 reads
I’m thrilled to announce that the “Architecting Microsoft SQL Server on VMware vSphere” 8.0 best practices guide has been released! I’m pleased to have been able to contribute to...
2023-02-23
188 reads
Today’s coping tip is to give sincere compliments today to people. A tough day recently coaching, but I kept this in mind. Complementing parents, competitors and fellow coaches, and...
2023-02-23
14 reads
Today’s coping tip is to share something you find inspiring, helpful, or amusing. Maybe not inspiring to you, but it was for me. We recorded a number of customers...
2023-02-22
11 reads
Microsoft Purview, formally called Azure Purview (see Azure Purview is generally available) has recently released a number of new cool features. I wanted to call out a few of...
2023-02-22 (first published: 2023-02-09)
438 reads
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
267 reads
Today’s coping tip is to respond kindly to everyone you talk to today. This is often easy for me. I did this last week while traveling. I got coffee...
2023-02-21
16 reads
I was talking with some developers from my team about monitoring, and I said, “We all use the same tools,” referring to other monitoring software. Then, it hit me....
2023-02-21
8 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 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...
Comments posted to this topic are about the item 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