Hunting in Packs
Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.
2016-04-11
118 reads
Editorial
How Much Can You Learn?
This Friday Steve Jones wonders about the upper limits for what you may learn in a year.
2025-09-01 (first published: 2016-04-08)
251 reads
Naming Is Hard
Naming objects and variables in software can create contention in a team. While there are good conventions and standards, ultimately a team just needs to agree on something.
2016-04-07
129 reads
Would You Move For a Job?
Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough for you to uproot your life?
2020-09-18 (first published: 2016-04-04)
242 reads
Code smells versus transgressions
The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?
2016-04-04
153 reads
2016-04-01
122 reads
The Database Transaction Unit (DTU) Decoded
In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.
2016-04-01
2,678 reads
Is PowerShell Intimidating?
Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.
2016-03-30
184 reads
Examining SQL Server 2016
Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.
2016-03-31 (first published: 2016-03-29)
283 reads
Track Your Consultants
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
86 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