You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
730 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Dealing with Frustration in the Workplace
Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...
2011-05-11
3,022 reads
Vote for My PASS Summit Sessions
Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...
2011-05-11
952 reads
Know Your Limits
A little over a week ago I roughed up my back moving sound equipment after a ministry event. I have...
2011-05-10
1,707 reads
I Won't Be at SQL Rally
I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...
2011-05-05
860 reads
My PASS Summit Submissions
Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...
2011-05-05
787 reads
Outlook Productivity Tricks
I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...
2011-05-05
2,100 reads
Writing Better Emails
In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...
2011-05-04
2,927 reads
How often do you check email?
If you read the experts, most folks check their emails too many times during the day. Today, while giving a...
2011-05-03
789 reads
Love What You Do
I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...
2011-04-29
1,539 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