Beyond Automation
Are there some things that are beyond automation in your company? Steve Jones comments on the difficulty of changing things with automation in some cases.
2010-08-19
277 reads
Editorial
Penalties
Terry Childs gets sentenced for refusing to turn over passwords to his boss. Steve Jones reminds us that we work for someone and that we have to remember that when taking a stand.
2010-08-18
291 reads
Keeping Engaged
How can you better keep employees engaged in your company? Keep them happy and hopefully retain them for a long time? Steve Jones has some comments today.
2010-08-17
159 reads
Turn a Bad Job into a Good Experience
Today we have a guest editorial from Tim Mitchell that tells you how to turn a bad job into something more.
2010-08-16
370 reads
A Server is Not a Machine
With cloud computing use growing, and SQL Server Azure becoming more popular, Steve Jones wishes this would become a product that the rest of us could deploy.
2010-08-16
158 reads
The Value of Blogging
Today we have a guest editorial from Andy Warren that talks about the value of blogging.
2010-08-13
134 reads
Failed IT Projects
A new theory of why some IT projects fail has Steve Jones intrigued, however he thinks we can do better, and not just with better developers.
2010-08-12
316 reads
The Bottom Line
A good employee should try to affect the bottom line in their company, striving to make a difference. Steve Jones passes on some advice on how to do that today.
2010-08-11
167 reads
Fooling SQL Server
Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.
2010-08-10
465 reads
(Un)Common Speed Phreakery
Is there such a thing as too much attention to the performance of SQL? It isn’t only a question of time and inclination, but also of the resilience and flexibility of the code.
2010-08-09
156 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