On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!!
What could be better than bacon...
2012-12-25
1,135 reads
SQL RNNR
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!! What could be better than bacon wrapped frog legs? Oh yeah, more Virtual lab...
2012-12-25
On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies...
2012-12-24
1,020 reads
On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies while improving his/her own skill set. Today we will...
2012-12-24
On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season.
Silver and Gold also...
2012-12-22
1,253 reads
On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season. Silver and Gold also seem to represent something of greater value. We...
2012-12-22
On the Ninth Day…
It’s the end of the world as we know it. And as the song goes…I feel fine! But hey, we...
2012-12-21
1,226 reads
On the Ninth Day…
Creating a custom data collector can be very handy for a DBA. Especially in times of troubleshooting. These collectors are also quite useful for trending and analysis. Consider this...
2012-12-21
10 reads
On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll...
2012-12-20
1,553 reads
On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll explain about that later in this post. This should...
2012-12-20
3 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Lessons from the Postmark-MCP Backdoor
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Question of the Day
The Maximum Value in the Identity Column
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