Crossing Azure Borders
Steve Jones is pleased to see some changes at Azure that make the database a stronger platform.
2015-11-05
106 reads
Editorial
2015-11-04
138 reads
Virtual Failback
The pressure to move to virtual systems is increasing, but is there a fallback if you have issues?
2015-11-03
89 reads
Secret Software Security
The move to limit disclosure of vulnerabilities continues, with potential issues for many of us.
2015-11-02
99 reads
SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
2015-11-02
268 reads
2015-10-30
322 reads
The Hot Jobs
This week Steve looks at the hot jobs that are going to have pay increases in the coming year.
2015-10-26
258 reads
Positive or Negative
Today Steve Jones wonders if the way you choose to design a database says something about you.
2015-10-23
183 reads
The Dangers of Travel
As data professionals, we might carry lots of information with us that relates to our organization. Will we get caught up in government issues as we cross borders?
2015-10-22
195 reads
An Out of Date CAP
The CAP Theorem talks about the properties of distributed systems, and how you can really only have two of them in any system.
2015-10-21
103 reads
Blogs
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Forums
Don't Forget About Financial Skills
Comments posted to this topic are about the item Don't Forget About Financial Skills
Building a Simple SQL/AI Environment
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
Checking Identities
Comments posted to this topic are about the item Checking Identities
Question of the Day
Checking Identities
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9
GO
DBCC CHECKIDENT(TravelLog, RESEED)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-09-14', '2025-09-17')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers