Protesting government web surveillance: Feb 11 Blackout
We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the...
2014-01-13
448 reads
We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the...
2014-01-13
448 reads
Regular expressions are searches on steroids, the wildcats of the wildcard world*. Even if you never ever write CLR, regex...
2014-01-10
1,240 reads
One of my children is very literal, a true pedantic. “Is there any homework you need to do?” “No.” “Really?...
2014-01-04
579 reads
I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a...
2013-12-18
530 reads
John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish...
2013-12-16
936 reads
In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets...
2013-12-12
663 reads
John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice,...
2013-12-10
516 reads
You know what? You’re doing a good job. You’re reading blogs, and that’s generally the sign of a person wanting...
2013-12-09
566 reads
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
536 reads
I had a great comment (Ryan McCauley’s) on yesterday’s post that led to a great conversation on Twitter. The comment mentioned...
2013-11-27 (first published: 2013-11-19)
2,062 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