SSWUG SSIS Expo Slides and Scripts
You can find the slides and scripts from today’s sesson at the SSWUG SSIS Expo, the materials can be downloaded...
2011-11-18
539 reads
You can find the slides and scripts from today’s sesson at the SSWUG SSIS Expo, the materials can be downloaded...
2011-11-18
539 reads
Last Friday, Minnesota had it’s second SQL Saturday event, on a Friday. Hopefully, those that were able to attend had...
2011-11-18
574 reads
Stuff me in a wood chipper, I have an idea. And this idea involves Fargo, Fargo, and SQL Saturday.
As many...
2011-11-17
723 reads
Home Sweet Cubicle
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave...
2011-11-16
600 reads
I’ve been a bit busy while planning this year’s SQL Saturday in Minnesota. Unfortunately, that hasn’t led to a lot...
2011-10-26
755 reads
I’ll be posting a summit wrap-up after I return next week from my honeymoon. Until then, though, I wanted to...
2011-10-15
582 reads
Final day at the PASS Summit. That means it’s time to hear from David Dewitt. This is the keynote of...
2011-10-14
585 reads
Since I put up the lyrics for “SQL and I Know It”, it only makes sense to continue the tradition...
2011-10-11
525 reads
A couple weeks back, I drove out to Madison to present at the MADPASS user group. These guys have a...
2011-10-10
525 reads
I’ve been meaning to follow-up with links to the presentations that I delivered at SQL Saturday 98. It’s a few...
2011-10-10
578 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