Half a Year
We're halfway through the 2015 year and Steve Jones has a few thoughts for you this holiday weekend.
2015-07-03
76 reads
Editorial
SSMS Maturity
Announcements recently for changes in SSMS mean that the tool many of us rely on is growing up.
2015-07-02
212 reads
Training Computer Scientists
What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.
2015-07-01
244 reads
The Importance of Our Work
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
2015-06-30
130 reads
2015-06-29
313 reads
Not a cloud to be seen
Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.
2015-06-29
127 reads
2023-01-16 (first published: 2015-06-26)
427 reads
#SQLNewBlogger
Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.
2015-06-25
132 reads
2015-06-24
597 reads
Skill Supply and Demand
Finding staff with the proper skills can be a challenge, and it might be a reason why you choose, or remain with, a particular technology.
2015-06-23
195 reads
Blogs
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
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,...
Forums
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
Replication from IBMi DB2 to MS SQL
We have a tool called DB Moto that reads journals (like t-logs) and replicates...
Don't Forget About Financial Skills
Comments posted to this topic are about the item Don't Forget About Financial Skills
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