Kalen Delaney’s Weekly Webinars
Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...
2017-12-07
337 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Webinar: Understanding SQL Injection and Its Consequences
On Thursday, December 14, at 3 PM Eastern, I will be giving a presentation on SQL injection. Registration is required...
2017-12-06
470 reads
Geek Sync Recording: Taking Control of Your SQL Server Sprawl
Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:
Take...
2017-11-17
443 reads
Learning to Give Presentations Well (Part 1)
I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...
2017-11-17 (first published: 2017-11-06)
1,505 reads
Learning to Give Presentations Well (Part 2)
Presentation Zen cover
In Part 1, I gave some advice from Toastmasters. We’ll return to the Toastmasters advice in Part 3....
2017-11-15
526 reads
Don’t “Test” Against Production
A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...
2017-10-30 (first published: 2017-10-18)
2,060 reads
If You’re Stuck at Home for the PASS Summit
Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...
2017-10-30
669 reads
Automating Everything with PowerShell – Getting Started #tsql2sday
I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...
2017-10-17
900 reads
Randomness in Security Configuration
We were deploying a new web service. Because of the nature of the service, we wanted it to listen on...
2017-08-24 (first published: 2017-08-14)
1,409 reads
Just Say No to Social Engineering Memes
These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...
2017-08-11
1,412 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