Accept Failure
Today Steve Jones talks about the risk inherent in any project, and how we should be aware of our mistakes, learn from them, and sometimes just give up when we've made too many.
2016-06-03 (first published: 2012-02-22)
223 reads
Editorial
2012-02-21
156 reads
Putting JSON on an equal footing to XML
In SQL Server, we treat XML with a reverence that is disproportionate to its importance. The SQL Server team have indeed gone big on XML, as Michael Cole’s book reveals. The industry has gone big in another direction: JSON.
2012-02-20
626 reads
Programmers v Salespeople
This Friday Steve Jones asks whether you think the salespeople or the technical people are more important to the success of a company. And if they should be better compensated.
2012-02-17
242 reads
Too Tired to Work Smart
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy looks at the ways we can cope when we have been working too much.
2023-09-13 (first published: 2012-02-16)
355 reads
Use Your Tools
It's easy to get stuck in a rut and not learn to use the new features and capabilities of your tools are they evolve. Steve Jones reminds you it's worth a little time investment to learn about your tools.
2012-02-15
216 reads
A Valentine for the Community
This Valentine's Day Steve Jones wants to thank everyone in the community for their efforts.
2012-02-14
90 reads
Upgrading Your Career
Certification is on Steve Jones' mind this week after quite a few training opportunities have popped up lately.
2012-02-13
276 reads
Anonymous Research
Anonymizing data is hard, and Steve Jones talks about some of the problems with trying. Is this something we should be more concerned about this with our corporate data?
2012-02-13
112 reads
Encryption in Production
This Friday Steve Jones wants to know if you are using encryption in your production system and if so, how is it working? Can you handle DR situations?
2012-02-10
261 reads
Blogs
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
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...
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