Recently a friend had an issue with their SQL Server as a result of a file change in their SQL Server database. In this short piece, I want to highlight the dangers of making some changes to an online database that might cause an unexpected outage. This is really the same whether you are changing […]
2019-07-09
5,109 reads
2019-07-05
822 reads
2019-07-01
837 reads
2019-06-28
859 reads
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
702 reads
2019-06-24
793 reads
2019-06-10
1,101 reads
2019-06-06
1,176 reads
In this blog we would learn how to fix Msg 4353 - ...
2019-05-24
Learn how you can configure clean and size management for your SSIS catalog database.
2019-05-23
14,437 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers