Burnout
Doing the same thing for too long, and not enjoying it, isn't good for anyone. You might be burned out, or as Steve Jones notes, you might need to change our perspective.
2018-10-29 (first published: 2015-02-09)
410 reads
Editorial
Programming Rules and 'Best Practices' Can't Replace Professional Judgement
In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement
2015-02-09
205 reads
Interrupt Me, I'm Stagnating
Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.
2015-02-05
194 reads
The Number that shouldn't be a number
Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2024-07-12 (first published: 2015-02-02)
697 reads
2019-05-28 (first published: 2015-01-30)
407 reads
You Better Learn to Work at Scale
We are managing more and more systems and databases all the time. To Steve Jones, that means we must be able to work at scale.
2015-01-29
147 reads
Normal Data
More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.
2018-10-10 (first published: 2015-01-28)
194 reads
Time for Learning
How do you find time for learning? More importantly, Steve Jones asks if you find time for actual use of your knowledge.
2015-01-27
263 reads
Deploy the Database First
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
2018-12-17 (first published: 2015-01-26)
182 reads
Which Problem Are You Solving?
This week Steve Jones talks a bit about problem solving and how you should approach the issue.
2015-01-26
103 reads
Blogs
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
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...
Forums
How to use data pre-computed in previous ETL SSIS Nodes?
I'm building ETL packages in SSIS. My data comes from an OLE DB Source...
Building AI Governance and Policies- First Steps
Comments posted to this topic are about the item Building AI Governance and Policies-...
Simple delete causes table scan on other tables with foreign key
Why is sql doing a full scan VS seeking on the index? I've included...
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