DevOPs and Databases — the one thing you may be doing wrong.
This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b) – for hosting this month’s...
2017-06-13
645 reads
This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b) – for hosting this month’s...
2017-06-13
645 reads
The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...
2017-06-06
650 reads
This blog post is part of T-SQL Tuesday #90 – Shipping Database Changes.
I have decided to write about a client’s SQL...
2017-05-09
384 reads
In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in...
2017-05-18 (first published: 2017-05-07)
1,581 reads
Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...
2017-04-30
621 reads
In this post we will remove some databases located in Azure.
This related to my last post where I am cleaning...
2017-04-30
1,620 reads
This post is about using the brilliance of PowerShell to script the creation of databases in Azure.
Background:
Apart from the obvious question...
2017-05-11 (first published: 2017-04-30)
1,361 reads
For the past 6 months I’ve been paying for my own Azure subscription. My work has a plan but for...
2017-04-24
378 reads
This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...
2017-04-22
1,060 reads
Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...
2017-04-22
244 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