Speaking at the 2018 Techno Security and Digital Forensics Conference
One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which...
2018-03-01
310 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Settings Goals Professionally
I was reminded of this topic after yesterday’s #SQLChat. Have you set professional goals for yourself? If so, have you...
2018-02-16 (first published: 2018-02-08)
2,059 reads
Tinker as You Learn
In recent weeks I’ve seen my brother from another mother, Andy Leonard (twitter | blog), write or post about his learning...
2018-02-09 (first published: 2018-01-24)
1,920 reads
WIT: A Quick Thought
I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time....
2018-02-02 (first published: 2018-01-22)
1,561 reads
DevOps Does Not Make Admins Obsolete
As a follow up to my tweet, I stand by my belief that DevOps does not make administrators obsolete. I...
2018-01-11 (first published: 2018-01-03)
1,047 reads
BK’s Professional Learning Plans for 2018 #tsql2sday
With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask...
2018-01-01 (first published: 2017-12-12)
1,408 reads
Learning to Give Presentations Well (Part 3)
See Part 1 and Part 2.
Perfect Practice Makes Perfect
I can remember my Air Force ROTC class on communications skills where...
2017-12-29 (first published: 2017-12-11)
1,421 reads
More Beginner / Fundamentals Content
Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts.
I put up the poll based on a...
2017-12-22 (first published: 2017-12-05)
1,892 reads
Security Architecture: Knowing the Adversary
When I present or teach on a security topic, I take the time to cover the mindset of the adversary....
2017-12-13 (first published: 2017-12-04)
1,734 reads
Register for Red Gate’s SQL in the City
Aunt Kathi. Grant Fritchey. Steve Jones. They’re part of five hours of training on SQL Server performance and DevOps with...
2017-12-08
470 reads
Blogs
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...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
The Maximum Value in the Identity Column
Comments posted to this topic are about the item The Maximum Value in the...
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