Code Scanning
Today Steve Jones talks about code scanning and the analysis that tools can do for us today.
2012-03-05
195 reads
Editorial
High Availability Upgrades
Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgrade for your company?
2012-03-02
257 reads
Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-01
333 reads
Use the 4th Dimension
Today Steve Jones talks about the conflicting demands of home and work and how you can reconcile the requirements of both.
2012-03-01
194 reads
The Cloud is good for your career
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
2012-02-29
261 reads
Taking a Sabbatical
Today we have a guest editorial from Andy Warren as Steve is on vacation. Today Andy discusses sabbaticals, and a change in his life.
2012-02-28
153 reads
The Power of Hadoop
Hadoop is an open source framework for working with data, and one that Microsoft has adopted. Is it worth using in your environment? Steve Jones thinks you should investigate it.
2012-02-27
782 reads
Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
2012-02-27
275 reads
A Break from Databases
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
2012-02-24
155 reads
Future Virtual Machines
What's the benefit of virtual machines and hypervisors? Steve Jones has a few comments on them and their future.
2012-02-23
333 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