Salaries and Experience
Experience matters in setting your salary, but Steve Jones reminds us there are different types of experience, and there's more to life than money.
2015-02-16 (first published: 2010-08-31)
1,086 reads
Editorial
I Love the SQL Community
Steve Jones talks about the SQL Community and why it's so great. Hint: it's the people.
2010-08-30
168 reads
Project Phoenix
A great new project kicked off by MVP Arnie Rowland is available to people out there struggling with their careers, but looking to continue to grow them.
2010-08-30
226 reads
If You Had To Pick a Super Hero...
Today we have a guest editorial from Andy Warren that looks at a lighter topic that's fun for most geeks: super heroes.
2010-08-27
142 reads
Individual Contributions
Each person on a team, or even in a company, can contribute something. Steve Jones reminds us not to assume we are better than others because of our job.
2010-08-26
166 reads
The DBA Financial Analyst
Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing.
2010-08-25
225 reads
When To Touch
When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.
2010-08-24
136 reads
Rating Bugs
How do you triage and rate the bugs that come in for software? How should Microsoft do this for SQL Server. Steve Jones has a few comments.
2010-08-23
99 reads
DMVs: are they worth the effort?
Many of the SQL Server DMVs still have a wild, unfinished feel but they are an incredibly useful tool for DBA, well-worth the sweat and toil required to learn and query them effectively.
2010-08-23
447 reads
Personal Investments
This Friday Steve Jones talks about your career, and training, and what you are doing about it.
2010-08-20
293 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