The Cost of Data Loss
The cost of data loss is higher in the US than other countries. That's good and bad for DBAs.
2010-05-03
167 reads
Editorial
Would You Like a Stay Interview?
For this Friday poll, Steve Jones talks about an interesting concept. The "stay interview."
2010-04-30
378 reads
Man in the MIddle
Are you worried about man in the middle attacks on your database server? If you run Oracle you should be, but SQL Server DBAs should not assume they are safe. Adding communication encryption can be a good idea for SQL Server DBAs.
2010-04-29
282 reads
Regular Service
Steve Jones feels that we ought to get regular service packs from Microsoft to support SQL Server. Not everyone agrees. Do you?
2010-04-28
99 reads
Concrete Code
When building a new database or system, are you designing concrete code? Should you be? Steve Jones comments on matching your needs with your architecture.
2010-04-27
178 reads
Financial Data in the Cloud?
Phil Factor believes that there will have to be further compromises between the pioneers of The Cloud and the regulators, before companies feel safe in entrusting their financial data to such an abstract service, seemingly 'remote from sand and iron'.
2010-04-26
347 reads
Minimal Meetings
Too many meetings happen in software teams. Steve Jones says that when scheduling meeting, you should be aware of the cost, and only include those people that need to be there.
2014-11-27 (first published: 2010-04-26)
205 reads
Spring Cleaning
For a Friday poll this week, Steve Jones is looking at those spring cleaning or annual maintenance activities that you might perform on your systems.
2010-04-23
147 reads
What Do We Want?
Today Steve Jones talks about the challenges of deciding what to include in that next software release. Something that likely isn't as easy as we might think it should be.
2010-04-22
84 reads
Speed Racer
Speed is critical. That's the theme for today's editorial, using the NYSE as an example.
2010-04-21
129 reads
Blogs
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...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
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