I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2025-03-31 (first published: 2025-03-17)
490 reads
This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated...
2025-03-31 (first published: 2025-03-14)
207 reads
zverism – n. the wish that people could suspend their civility and indulge in the physical side of each other first, sniffing each other’s hair like dogs, staring unabashedly...
2025-03-28
13 reads
I’m not looking for a job, but I ran across an article about using AI tools for a job search. So I decided to try it out. I followed...
2025-03-28 (first published: 2025-03-17)
390 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s all happening on August the 21st! We’ve open our call for speakers, you can submit...
2025-03-28 (first published: 2025-03-17)
253 reads
Core skills depends on the position, but the point is that ensuring you have a strong foundational base for your chosen area is better than reaching for emerging skills.
2025-03-28
91 reads
The Source Control Dilemma Every DBA has been there. Trying to keep track of database schema changes while developers have their fancy Git repositories and version control workflows. Meanwhile,...
2025-03-27
123 reads
I received a sobering reminder this week of a lesson we all have learned or should have learned long ago. Something I said online came back around months later...
2025-03-26 (first published: 2025-03-17)
381 reads
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping everything running smoothly. When SQL Server performance becomes an issue, a common reaction is often...
2025-03-26 (first published: 2025-03-13)
6,942 reads
Often we find out about a problem reported by a customer after the incident has passed. This might be from a trouble ticket or even an email that we...
2025-03-24
65 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
Comments posted to this topic are about the item Cleaning Up the Cloud
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')
I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON
INSERT dbo.TravelLog
(
TravelLogID,
CityID,
StartDate,
EndDate
)
VALUES
(25, 5, '2025-09-12', '2025-09-17')
SET IDENTITY_INSERT dbo.TravelLog OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers