Queues in Databases
The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.
2016-02-03
184 reads
Editorial
Maybe Security is Harder than Rocket Science
It's hard to build strong security over time, but it's worth the effort. Steve Jones notes that even smart people have problems implementing strong security.
2016-02-02
112 reads
Bogging Down in the Minutia of Minutes
Rodney Landrum gets lost in the fourth dimension, while coding the infinite possible combinations of SQL Server dates and times.
2016-02-01
75 reads
What is the True Version of Code?
What version of your code is the true one? Steve Jones talks some version control today.
2016-02-01
180 reads
Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
374 reads
Training at the Top
Today Steve Jones looks at security training and the need for understanding from upper management.
2016-01-28
92 reads
DeveloperBall
Steve Jones looks at the challenges of putting a team together of wildly different skill levels.
2016-01-26
114 reads
Crafting Your Resume
Today Steve Jones talks about how you can present yourself better within the confines of a resume.
2016-01-25
183 reads
Design a Better SQL Server Pricing Model
Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.
2016-01-21
160 reads
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
407 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