I Give Up: What IS an MVP?
I’m so glad you asked!
Here’s how it works: Microsoft makes products. (The one I talk about the most is SQL...
2011-03-02
495 reads
I’m so glad you asked!
Here’s how it works: Microsoft makes products. (The one I talk about the most is SQL...
2011-03-02
495 reads
We at MidnightDBA sure do love a blog party, and what’s better than a blog party about love? I invited the...
2011-02-21
640 reads
The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16...
2011-02-20
1,623 reads
Last week I asked you: What Tech Companies Are Doing it Right?
Which SQL (or SQL-adjacent) tech companies are doing right,...
2011-02-14
874 reads
Tim Ford, SQL MVP and all around Good Guy, has been having a really hard time so far in 2011....
2011-02-12
572 reads
Last week, I asked the Twitter hive-mind about its favorite tech companies: “Which SQL (or SQL-adjacent) tech companies are doing...
2011-02-11
498 reads
I’m not gonna lie to you, Marge…I haven’t exactly been keeping up with the RTFM365. And when I have read,...
2011-02-07
605 reads
Dallas’ first SQL Saturday ”was full of nothing but smooth, rich #awesomesauce.” And we had Italian gelato.
Dallas’ second SQL Saturday (BI edition) ”had over...
2011-02-03
470 reads
SQL Saturday #57 was this weekend! Sean and I went, talked, webshow-ed, and then presented a total of SIX sessions!
Travel
Sean and...
2011-01-31
1,634 reads
The invitation for Un-SQL Friday #002 (Tech Giants) was, like, a week ago! I’ve gotta get this train a-rollin, or...
2011-01-28
958 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