Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
4 reads
Blog Posts
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
13 reads
A New Windows Terminal
Watching the Build keynotes, I saw that the new Windows Terminal has been released. It looks mildly interesting, as I really like ConEmu, but it’s something that will be...
2020-05-22
70 reads
Daily Coping 22 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-22
9 reads
Executing PoSh line by line in VS Code
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve had to relearn this trick multiple times,...
2020-05-22 (first published: 2020-05-04)
363 reads
Quickly Blocking Inbound Connections to SQL Server
Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about...
2020-05-22
4 reads
Using Logic Apps in a Data Factory Execution Framework – Part 1
Data Factory allows parameterization in many parts of our solutions. We can parameterize things such as connection information in linked services as well as blob storage containers and files...
2020-05-22 (first published: 2020-05-07)
559 reads
A Byte of Redgate
When the global pandemic shut down much of the world, we started the Community Circle at Redgate, with the idea that we would try and help others cope with...
2020-05-21
18 reads
Daily Coping 21 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-21
5 reads
Download SQL Server Developer / Evaluation / Express Editions
[MSSQLFUN & Decote ITeS becomes a family of 1400 individuals across the globe. Please join us onFacebook & YouTube.] Today, I will take you to the steps of downloading...
2020-05-21
297 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers