Dynamic Data Masking
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2019-08-09 (first published: 2015-02-26)
8,856 reads
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2019-08-09 (first published: 2015-02-26)
8,856 reads
Dynamic Data Masking
FEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last...
2015-02-26
4 reads
Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...
2019-08-09 (first published: 2015-02-03)
13,480 reads
Index Fragmentation in Azure SQL Database
FEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentation and When Does Index Fragmentation Matter?, and that got me starting to...
2015-02-03
64 reads
Monitoring Geo-Replication in SQL Azure using DMV'sDECEMBER 26, 2014Azure SQL Database comes with a host of disaster recovery options. The...
2014-12-25
5,901 reads
Monitoring Geo-Replication in SQL Azure using DMV's
DECEMBER 26, 2014
Azure SQL Database comes with a host of disaster recovery options. The most robust of these options involves replicating the database...
2014-12-25
282 reads
Runbooks in SQL AzureDECEMBER 2, 2014SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable...
2014-12-10
1,356 reads
Runbooks in SQL Azure
DECEMBER 2, 2014
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable you to use PowerShell Scripts inside of SQL Azure...
2014-12-10
46 reads
SQL Azure Point-in-Time RestoreOCTOBER 26, 2014As a strategic direction, many companies have decided to start moving their SQL Server databases...
2014-12-06
989 reads
SQL Azure Point-in-Time Restore
OCTOBER 26, 2014
As a strategic direction, many companies have decided to start moving their SQL Server databases into the cloud using SQL Azure. This change in...
2014-12-06
11 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