Top 10 Enhancements to Azure SQL Database in 2015
Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....
2015-12-27
1,003 reads
Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....
2015-12-27
1,003 reads
Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015
Introduction2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an...
2015-12-27
23 reads
Getting Started with Azure Data Factory - Part 1DECEMBER 9, 2015
Introduction
The Azure Data Factory is a means of moving data around...
2015-12-09
4,119 reads
Getting Started with Azure Data Factory - Part 1
DECEMBER 9, 2015
IntroductionThe Azure Data Factory is a means of moving data around in the cloud. In a similar way that...
2015-12-09
10 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob StorageNOVEMBER 11, 2015
Introduction
In my next series of posts,...
2019-08-09 (first published: 2015-11-10)
7,130 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
NOVEMBER 11, 2015
IntroductionIn my next series of posts, I am going to look into processing files in...
2015-11-10
149 reads
5 Enhancements to SQL Runbooks in the Azure Preview PortalSEPTEMBER 18, 2015
Introduction
Runbooks are your SQL Server Agent for Azure SQL...
2015-09-18
1,011 reads
5 Enhancements to SQL Runbooks in the Azure Preview Portal
SEPTEMBER 18, 2015
IntroductionRunbooks are your SQL Server Agent for Azure SQL Database. Lately, Microsoft have been making quite a few...
2015-09-18
16 reads
Setting Up Alerts in Azure SQL DatabaseSEPTEMBER 8, 2015
Introduction
If I've learned one thing with my on premise versions of SQL...
2019-08-09 (first published: 2015-09-08)
3,710 reads
Setting Up Alerts in Azure SQL Database
SEPTEMBER 8, 2015
IntroductionIf I've learned one thing with my on premise versions of SQL Server, it is to automate as much as possible....
2015-09-08
65 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