The Work of the Ancients
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
2019-10-11 (first published: 2015-10-02)
309 reads
Editorial
Have a Think
It's easy for most of us to get caught up in work and not stop to think about the larger picture, or the longer term. Steve Jones thinks you should make time for both of these.
2019-10-24 (first published: 2015-10-01)
267 reads
2015-09-30
489 reads
Are you a Data Scientist?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
2019-05-01 (first published: 2015-09-29)
580 reads
No Time for Testing
Testing software is important, but we always seem to find reasons not to. Steve Jones has a few thoughts about testing.
2023-01-02 (first published: 2015-09-28)
246 reads
2015-09-28
118 reads
Logging Tables
Today Steve Jones looks at the need to log data from an application or process. Are there good and bad ways to design the structures to log information?
2019-11-05 (first published: 2015-09-25)
610 reads
Data Masking for Convenience
Steve Jones talks a bit about the new data masking feature in SQL Server 2016 and how useful it can be.
2015-09-24
134 reads
Everyone is a Target
Today Steve Jones looks at the targeted attacks by hackers against individual security professionals.
2015-09-23
121 reads
Data Sprawl
The challenges of data growth and sprawl can be compounded by the variety of tools and platforms available. Steve Jones notes that you might need to learn a bit about different technologies.
2015-09-22
128 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
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
Building a Simple SQL/AI Environment
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
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