The Time Thieves
Learning to efficiently manage time in a team is hard. Steve has a few ideas today, based on a book.
2022-12-12
166 reads
Work environment
Life Organization
For years, those of us in technology have often worked outside of the core working hours for the rest of our organization. Whether this is being on-call, staying late, or coming in when asked. It's not uncommon for many developers and Ops staff to work 60, 70, or more hours to get things built/deployed/supported for […]
2022-11-04
172 reads
Remote Remote Work
Working remotely can be more than working at home, which Steve thinks helps the work-life balance.
2022-10-21
147 reads
Being Reasonable
Most of work in teams, which means we are accountable to reach other, but we should also treat each other as we'd want to be treated.
2022-07-29
150 reads
A Culture That Allows Mistakes
The culture in which we work is important. Having a culture that accepts and allows mistakes can help your organization. Not having this can make the environment much worse.
2022-07-20
245 reads
Which Work Is Suited for In-Person?
What is the best way to use an office? Or is there even a best way? Steve asks the question today.
2022-07-15
144 reads
2022-07-09
165 reads
A Third Space
We used to work in offices, now we work at home. Do we need a third space? Steve does.
2022-04-18
176 reads
Making Video Chat Better
Video chat is how many of us see our colleagues every week. It's not a great system, but maybe it can get better.
2022-01-31
92 reads
Poor Work Management
The future of work is uncertain, but not everyone is ready for remote work to continue.
2021-09-20
287 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