Midlands PASS Job Board
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,342 reads
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,342 reads
If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early...
2007-02-13
2,658 reads
I have put the Midlands PASS site online temporarily at Truth Solutions. You can reach it here:
http://www.truthsolutions.com/MidlandsPASS/
The slides from Paul...
2007-02-12
1,611 reads
Maintaining SQL Server security is fast becoming a big part of a SQL Server DBA's job. Longtime security expert Brian Kelley takes a
look at a security scanner: Typhon III
2007-02-05
5,752 reads
We are postponing
due to the weather. Training Concepts has shut down for the day due to the wintry
mix....
2007-02-01
1,284 reads
I meant to blog on this last month but work has been just a touch short of insane. I like...
2007-01-31
1,499 reads
Our next meeting will be on
Thursday, February 1, 2007, at 6:30 PM.
It'll be at the Training Concepts facility once...
2007-01-30
1,513 reads
I've been looking at getting an MP3 player for a while now because I want to make better use of...
2007-01-27
1,539 reads
Our next meeting
will be on Thursday, February 1, 2007, at
6:30 PM. It'll be at the Training Concepts facility once...
2007-01-26
1,403 reads
I recently had the opportunity to review NGS Software's updated Typhon III general vulnerability scanner. I had previously reviewed it...
2007-01-25
1,730 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
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