Audio and slides are up for my webinar on SQL Server encryption
The webinar audio and slides/demo scripts are up for the presentation I did for the PASS Security virtual chapter.
PASS Security...
2013-07-19
750 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Presenting for the new PASS Security Virtual Chapter on July 18
The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...
2013-07-17
1,262 reads
Dealing with Auditors: Password Settings
Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...
2013-06-19
8,169 reads
Update Your Audit Queries for SQL Server
I was working with an auditor today who is working through a system with an external audit agency. The external...
2013-06-13
2,121 reads
Personally Identifiable Information (PII) and Data Encryption
Hitting close to home, SC Governor Nikki Haley noted that after the SC Department of Revenue breach was reported, that the IRS didn't...
2013-06-07
5,079 reads
Why Anti-Virus Offers Limited Protection
Sitting in the first Keynote for the 2013 Techno Security and Forensics Investigation Conference, I was not surprised to hear Kevin...
2013-06-06
1,485 reads
From the 2013 Techno Security Conference - Cloud Computing and Digital Forensics
I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...
2013-06-05
1,150 reads
Notes from 2013 Techno Security Conference Tuesday Keynote
There's enough from this morning's 2013 Techno Security and Forensics Investigation Conference to split into multiple blog posts. I'll focus this...
2013-06-04
1,154 reads
SQL Server security webinar series is coming soon!
I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...
2013-06-04 (first published: 2013-05-30)
2,539 reads
Notes from the First Day of the 2013 Techno Security Conference
The Techno Security & Forensics Security Conference is held in conjunction with the Mobile Forensic Conference each year in Myrtle Beach,...
2013-06-03
1,181 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
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:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
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