Consolidation Matters
Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.
2014-04-21
131 reads
Editorial
Advice for Newcomers
If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.
2017-12-12 (first published: 2014-04-18)
691 reads
One Database to Rule Them All
Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?
2014-04-17
299 reads
2014-04-16
728 reads
Doing What It Takes To Get The Job Done
It can be a point of pride in technology that we work ourselves to get the job done. Is that a good thing? Andy Warren has a few thoughts.
2014-04-15
205 reads
2014-04-14
150 reads
How Long Before You Upgrade?
This Friday Steve Jones wants to know about the lifetime of your instances. Do you have some idea on how long you'll run a particular version of a platform?
2017-11-10 (first published: 2014-04-11)
334 reads
If or When?
Are data breaches a question of if they will happen to you or when will they happen to you?
2014-04-10
165 reads
Problems with Big Data
Today Steve Jones notes that Big Data isn't a panacea. It's not going to just solve all problems.
2014-04-09
220 reads
Lobbying for Change
The Connect system from Microsoft doesn't work that well, but that doesn't mean we shouldn't continue to press Microsoft for change.
2014-04-08
122 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