Certain DBs in an AG not Backing Up
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
970 reads
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
970 reads
This is the final post of 3 on SSRS 2016. This time I’m looking at the new SSRS 2016 mobile reports.
Post 1 covered...
2016-03-14
6,269 reads
Yesterday Microsoft made the earth shattering news that a version of SQL Server with the “core relational database capabilities” will be...
2016-03-08
414 reads
I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...
2016-03-01
654 reads
The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales...
2016-02-25
605 reads
This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...
2016-02-22
1,123 reads
Whilst working on an upcoming post I realised that I needed a decent data set on which to test some...
2016-02-15
706 reads
This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I...
2016-02-03
1,330 reads
This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim...
2016-01-28
1,157 reads
This post is designed to explain the installation steps of some of the new features in 2016 and just how...
2016-01-20
754 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