2021-05-17
221 reads
Work environment
Office FOMO
There are many things we may miss about the office, but one of them is the chance to interact with and impress management.
2021-04-23
124 reads
2021-04-22
74 reads
Finding a Break
A year of remote work has made life hard, and harder to get a break from the same environment you are in most of the time.
2021-04-16
77 reads
Easing Back to the Office
Companies are starting to bring people back to the office. Microsoft has announced their policy, and Steve wonders if more will follow.
2021-04-12
121 reads
2021-04-09
138 reads
Working in a Distributed Fashion
With many of us working in a distributed fashion, Steve wonders if things have changed for the process flow you follow.
2021-03-22
133 reads
Every IT Organization is a Snowflake
Some people think every IT department is unique. While that might be literally true, Steve doesn't think that is actually the case.
2021-03-17
196 reads
Viva
Microsoft is working on the future of work, and adapting to remote work. Steve isn't sure this will work, but they have at least one interesting technology idea he likes.
2021-03-01
121 reads
The Pandemic Work Load
With the new year proceeding along, we are still in a pandemic. Is that affecting your work load?
2021-02-12
123 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