SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness
A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...
2006-06-21
2,139 reads
A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...
2006-06-21
2,139 reads
Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...
2006-06-15
2,048 reads
I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...
2006-06-13
2,325 reads
It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...
2006-06-12
1,578 reads
This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...
2006-06-11
1,489 reads
I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...
2006-05-27
2,139 reads
Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:
Project Managing Latency or: How to...
2006-05-25
1,447 reads
In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...
2006-05-24
1,492 reads
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,620 reads
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,646 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
I've noticed several instances of what looks like a recursive insert with the format:...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
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 OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers