In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.On this post we will create an Azure SQL...
2023-09-20 (first published: 2023-08-28)
215 reads
There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read...
2023-09-19
4 reads
If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...
2023-09-19
42 reads
I sent some code to a customer recently to help them decrypt some stored procedures. I sent a quick and dirty set of code, noting at the bottom that...
2023-09-18 (first published: 2023-08-23)
225 reads
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
484 reads
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
10 reads
As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts...
2023-09-18 (first published: 2023-08-23)
226 reads
This week the cost of the PASS Data Community Summit jumps up to full price, on Sep 21. This is your last chance to save big, so get someone...
2023-09-18
32 reads
Today I’m presenting at DataMospit, the most metal conference in the data space! You can download the Sea of Madness bingo card from here: https://github.com/spaghettidba/CodeSamples/raw/master/SQLServerInfernals/InfernalBingo.xlsx The winner will get...
2023-09-16
72 reads
justing – n. the habit of telling yourself that just one tweak could solve all your problems – if only you had the right haircut, if only you found...
2023-09-15
16 reads
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...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
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 OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers