Getting Started with Azure Data Factory - Part 1
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
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 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 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
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
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
Transparent Data Encryption in Azure SQL DatabaseJULY 26, 2015
Introduction
Transparent Data Encryption (TDE) is a security feature of SQL Server that...
2015-07-26
1,626 reads
Transparent Data Encryption in Azure SQL Database
JULY 26, 2015
IntroductionTransparent Data Encryption (TDE) is a security feature of SQL Server that has been around since SQL Server 2008. With TDE,...
2015-07-26
28 reads
SQL Azure has T-SQL Jobs - Well Almost
JUNE 25, 2015
IntroductionOne thing that has been lacking in Azure SQL Database is the ability to write database jobs in Transact-SQL. Recently,...
2015-06-25
12 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015
For those of you who have been following along with this series of posts,...
2015-05-28
96 reads
Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager DatabaseMAY 1, 2015
In my last post, I discussed some...
2015-04-30
4,941 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