New article: Identifying What Runs at Startup on SQL Server
Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when...
2012-01-30
934 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
You require WHAT for a license?
I was trying to acquire a license for a product I was trying to look at using a free program....
2012-01-26
1,024 reads
Clicking on Links in Email
Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...
2012-01-24
1,247 reads
New Article: How to audit sysadmin members on multiple servers using PowerShell
My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...
2012-01-23
1,938 reads
Speaking at Charleston PASS on January 19th
I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at...
2012-01-04
855 reads
Renewed as MVP for SQL Server
I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...
2012-01-02
1,259 reads
January Midlands PASS meeting - Hosting Ed Wilson, the "Scripting Guy"
On January 10, 2012, Midlands PASS is pleased to welcome back PowerShell expert and teacher, Ed Wilson (blog | twitter), and...
2011-12-30
1,689 reads
What is SQL Saturday?
I saw the following post from Andy Warren (blog | twitter), one of the creators of SQL Saturday. He was trying to...
2011-12-29
2,784 reads
SQLRally 2012 - Dallas Registration Is Open!
Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price...
2011-11-30
2,027 reads
No SQL Saturday - Columbia, SC in 2012
Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...
2011-11-14
1,659 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