Clean up all (most) of the orphans on an instance
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,672 reads
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,672 reads
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...
2015-06-01
625 reads
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...
2015-05-28 (first published: 2015-05-18)
5,928 reads
What?
The default database is one of the options when creating a login in SQL Server. This is the initial database...
2015-05-26
1,068 reads
If a user is going to call me about problem, I’d much rather know about it ahead of time. In...
2015-05-21 (first published: 2015-05-12)
4,897 reads
I do a lot of testing with security in SQL Server. And of course to do a thorough job of...
2015-05-20
708 reads
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows...
2015-05-14 (first published: 2015-05-04)
6,477 reads
I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a...
2015-05-14
607 reads
As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of...
2015-05-06
547 reads
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of...
2015-04-29
1,600 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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...
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