Thank you so much to those of you who were able to attend this three-hour, C# packed session! The Power BI Cruise was an incredible conference, and I cannot...
2023-05-12 (first published: 2023-05-02)
295 reads
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings.
2023-05-12
100 reads
An in-depth look at how you convert an existing table with data to a system versioned table that will maintain a history of changes.
2023-05-11
124 reads
Hello Dear Reader! My lastest blog on our Azure FastTrack blog for Microsoft is live, Monitoring Deadlocks in Azure SQL Managed Instance. Here's a little from the blog:To paraphrase Annie,...
2023-05-10 (first published: 2023-05-02)
437 reads
This is part of a series of new job blog posts. You can find them all here. As a DBA, the first six weeks on the job can be...
2023-05-10 (first published: 2023-05-01)
160 reads
“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...
2023-05-08 (first published: 2023-04-28)
511 reads
Hello Dear Reader, what a week! On Thursday my wife and I closed on a new house. We are so incredibly excited! We owned a house for a very...
2023-05-08
17 reads
What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your...
2023-05-08 (first published: 2023-05-01)
702 reads
Chysalism – n. the amniotic tranquility of being indoors during a thunderstorm? While I love the sun, I did enjoy thunderstorms when I lived in Virginia. Something neat about...
2023-05-05
30 reads
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what...
2023-05-05 (first published: 2023-04-24)
42 reads
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Comments posted to this topic are about the item An Unusual Identity
Comments posted to this topic are about the item Prompt Requests
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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