Midlands PASS May Meeting - Speaker Brian Knight
Tuesday, May 27, 2008
Speaker: SQL Server MVP Brian Knight
The Midlands PASS chapter will hold a special meeting on...
2008-05-15
629 reads
Tuesday, May 27, 2008
Speaker: SQL Server MVP Brian Knight
The Midlands PASS chapter will hold a special meeting on...
2008-05-15
629 reads
I was able this Saturday to head down to Jacksonville and speak at the SQL Saturday there. There were a...
2008-05-07
722 reads
The purpose of The Citadel, the Military College of South Carolina, is to prepare South Carolina's citizen soldiers. It is...
2008-05-02
868 reads
The recent slate of attacks on IIS servers don't seem to be an attack directly against IIS or against SQL...
2008-04-26
2,194 reads
Security was a major focus of SQL Server 2005 during its development, both in terms of making the product secure as well as enhancing the options. Security expert Brian Kelley brings us a look at how the paradigm of logins has changed and what you need to look for in SQL Server 2005.
2008-04-11 (first published: 2006-07-05)
118,199 reads
If you're looking for the Charlotte SQL Server User Group web page, the link on the PASS HQ site is...
2008-04-09
586 reads
The Heroes Happen Here launch event for Charlotte, NC is tomorrow. It looks like there are still registration slots open:
Heroes...
2008-04-07
1,005 reads
Red Gate's schema comparison tool, SQL Compare, is in beta for the newest version, SQL Compare 7. You can find...
2008-04-07
1,194 reads
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based...
2008-04-05
532 reads
I logged into Safari today to download some chapters I want to be able to review when I'm offline. I...
2008-04-05
1,262 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...
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
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
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