Windows Server 2008 R2 Core supports SQL Server
First saw this because Jason Massietwittered about it. But apparently there are enough bits of the .NET Framework in R2...
2009-01-09
1,254 reads
First saw this because Jason Massietwittered about it. But apparently there are enough bits of the .NET Framework in R2...
2009-01-09
1,254 reads
I have a lot of blogs I subscribe to. Well over 500 at last count. And the truth of the...
2009-01-07
722 reads
Received my notification via email this morning that I've been recognized as a Microsoft MVP for SQL Server. It's been...
2009-01-01
734 reads
With the holidays about over, I'm catching up on my RSS feed reading. This is an article from the beginning...
2008-12-29
1,606 reads
Brian Kelley looks at auditing in this article about SQL Server 2008 and the enhancements made in this version. The new Audit Object allows you to more easily determine what is happening on your SQL Server instance.
2008-12-18
3,311 reads
Back in October I had the opportunity to work with Andy Warren and do a series of SQL Server security...
2008-12-17
1,396 reads
Another diabolical idea of Chris Shaw. I'm actually late to the game because I got tagged a week ago by...
2008-12-16
984 reads
I've been off-line except for hints here and there for the last couple of weeks due to fighting off an...
2008-12-04
1,070 reads
Speaker: Paul Shearer
Midlands PASS Chapter - December 4, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled meeting on Thursday,...
2008-12-04
852 reads
Shortly after I gave my presentation Trigger Happy Database Security down in Jacksonville for SQL Saturday #3, I received an...
2008-11-20
854 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