Josh & myself at Antman & the Wasp Quantumania Hello Dear Reader! It's the Presidents Day holiday today in America. With it comes a 3 day weekend. To celebrate Josh...
2023-03-03 (first published: 2023-02-20)
108 reads
Today’s coping tip is to make plans with a friend or loved one. I don’t like making plans, preferring to somewhat flow with life and make decisions close to...
2023-03-02
11 reads
Od minulého roku jsme spustili náš 4-týdenní Joyful Craftsmen Bootcamp pro budoucí Data Engineers. Jedná se o intenzivní studium přímo u nás v Joyful Craftsmen HUBu, které posouvá datové...
2023-03-02
29 reads
Today’s coping tip is to call a friend to catch up and really listen to them Actually a friend pinged me to ask about a call recently. I made...
2023-03-01
12 reads
(2023-Feb-20) The previous posts covered the following areas of Metadata-driven pipelines in Azure Data Factory:Part 1 - Data CopyPart 2 - Feed ConfigurationPart 3 - Column MetadataThese 3 areas suggested that it is...
2023-03-01 (first published: 2023-02-20)
543 reads
It’s been nearly 3 years of Daily Coping Tips here at the Voice of the DBA. I started these when the pandemic hit and the world shut down. I’ve...
2023-03-01
27 reads
In this blog post, I will show you how to build a hello world container-based web application in the go programming language. The reason I want to do this...
2023-03-01 (first published: 2023-02-19)
203 reads
Today’s coping tip is to thank three people you feel grateful to and tell them why. This is something I tend to do privately, thanking people who’ve impacted my...
2023-02-28
8 reads
Today is the corporate Wellness Day at Redgate. It’s a day off for almost everyone in the company, unless they have something that can’t get moved. A few support...
2023-02-27
67 reads
A while back I wrote a post on how to retrieve the SQL Server images in the Microsoft Container Registry (MCR). It’s pretty simple to check the MCR but...
2023-02-27 (first published: 2023-02-17)
403 reads
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...
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
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