Long time, no posts
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
17 reads
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
17 reads
I believe that language matters, and that it is worth our effort to move away from language associated with slavery and racism whenever possible. Azure DevOps doesn’t technically allow...
2020-06-26
387 reads
I used to make fun of YAML because I was scared of it. I still make fun of YAML, but I’m not scared of it anymore now that Rob...
2020-06-25
107 reads
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required — we don’t...
2020-05-11
67 reads
I have an idea! Let’s have a “Worst Code Contest.” Why do this? Bad code is really fun — at least, when you write it on purpose. And other...
2020-04-24
23 reads
People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And...
2020-03-24
22 reads
We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking...
2020-03-23
13 reads
I’m giving a session on index tuning at the upcoming Redgate Streamed free online conference. The conference will be held April 1-3 2020, register here and join us! I...
2020-03-20
26 reads
We’re thrilled to announce Redgate Streamed: a 3 day online virtual community conference, to be held April 1-3, 2020. Register at Redgate.com/RedgateStreamed In this 9 minute livestream, I give...
2020-03-19
9 reads
I’m introducing a series of “learner’s guides” — overviews of a given topic, chock full of links and references. For this first post, the information is based on what...
2020-03-19
58 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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
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:...
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