Switching blog website
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
190 reads
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
190 reads
The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data...
2018-10-31
253 reads
I am pretty hyped to be able to finally announce a new project of mine that I have been working on for...
2018-03-13
344 reads
In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In...
2017-12-25 (first published: 2017-12-11)
2,006 reads
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and...
2017-10-17
2,000 reads
When you are working with Machine Learning there are many things you need to keep an eye on. You need...
2017-07-21
2,263 reads
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...
2017-05-24 (first published: 2017-05-14)
3,913 reads
Good news!
The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago...
2017-05-19 (first published: 2017-05-05)
1,406 reads
I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1....
2017-05-01 (first published: 2017-04-23)
1,764 reads
In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely...
2017-03-08 (first published: 2017-02-27)
2,368 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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
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:...
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