Ask HN: Would you run SQL Server on Linux?
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
567 reads
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
567 reads
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,769 reads
This is the ninth part in the series: SQL Server and Continuous Integration. In this post I’ll add some unit tests...
2017-07-31
1,816 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-06-22 (first published: 2017-06-13)
6,418 reads
As of CTP 2.1 for SQL Server 2017 a set of new environment variables are available. These variables allow us...
2017-05-17
3,420 reads
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
412 reads
I was once asked to add a new feature to an application. It was installed on multiple SQL Server instances...
2017-05-02
401 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-04-11
599 reads
This is the eighth part in the series: SQL Server and Continuous Integration. This post describes the set-up required for GitLab runners to...
2017-04-07 (first published: 2017-03-22)
8,217 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,870 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