2016-03-14
99 reads
Editorial
2016-03-11
123 reads
Building Better Software
Steve Jones discusses the idea of building software better, and why that's a challenge for many of us.
2016-03-10
103 reads
The Slack Integration
Slack has become a popular phenomenon in the technical world, especially for software developers. Should we join in?
2016-03-09
217 reads
The Data Driven Event
In a couple of days, Microsoft is holding Data Driven, an event that will highlight SQL Server 2016.
2016-03-08
99 reads
2016-03-07
260 reads
Testing times with SMO
SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.
2016-03-07
56 reads
Spousal Surcharges
Today we have a guest editorial from Andy Warren that examines the costs of family at work.
2016-03-04
163 reads
Open is Not Necessarily More Secure
Just because we can view the source code for software doesn't mean it is more secure.
2016-03-03
92 reads
Learning from Microsoft
Microsoft has changed their engineering to do amazing things in the cloud, especially with SQL Server. We could all learn from this.
2016-03-01
256 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