Dexterity Matters
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
2016-03-28
62 reads
Editorial
2016-03-28
172 reads
Protecting sa
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
2016-03-25
103 reads
Do Less
One way to make code run faster is to have less of it. Or ensure the code you have does less work.
2016-03-24
105 reads
2016-03-22
153 reads
On-Time, or Not
Today we have a guest editorial from Andy Warren that looks at the respect, understanding and compromise we might make with each other.
2016-03-21
100 reads
The New Men of IT
According to the New Men of IT, the industry changes so frequently that experience and qualifications quickly become obsolete and irrelevant. The argument won't wash with Phil Factor.
2016-03-21
141 reads
2016-03-17
115 reads
The Math on Automation
Is it worth automating things? Many people say yes, but Steve Jones says it isn't just about time saved.
2016-03-16
140 reads
SQL Server on Linux
There was an announcement last week that SQL Server can run on Linux. And it's coming next year.
2016-03-15
332 reads
Blogs
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...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
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