How to Speak to a Tech
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-14
625 reads
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-14
625 reads
We had a cozy (read: small) UnSQL Friday this time around, and I’m good with that. Every entry we got...
2011-06-09
840 reads
This month’s Meme Monday is “dumb SQL questions”. Here’s the one that gets under my skin the most these days:
Let me...
2011-06-06
638 reads
This is my contribution to UnSQL Friday #004: Speaker Lessons Learned.
I got my SQLRally session evaluation back last week. I’d...
2011-06-06
584 reads
I began writing a story about, shall we say, a less than positive speaking experience…and then I realized: This is...
2011-06-02
1,086 reads
On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon! I moderated, and our...
2011-05-26
1,009 reads
If you’re already a MidnightDBA Groupie, then you’ve probably already heard about my fabulous inspiration: a new SQL community podcast! Now...
2011-05-23
1,622 reads
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
550 reads
I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”. The idea is that there’s...
2011-05-17
788 reads
Look at the cute bunny. Now go vote for me.
I can see October from here, and it’s coming at about...
2011-05-10
523 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