Availability Group round-robin read-only routing isn't magic
I've been hearing about round-robin read-only routing ever since SQL 2016 came out but whenever I tried to test if...
2018-03-08
296 reads
Blog Posts
Catch up on SQL in the City 2018–GDPR Edition
The videos for our SQL in the City 2018 broadcast from last month are up on the Redgate channel in...
2018-03-08
392 reads
Finding Composite Primary Key Columns
You never know when the idea for a script will make an appearance.
I had to work with composite primary keys...
2018-03-08 (first published: 2018-02-23)
3,545 reads
Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead...
2018-03-08
1,222 reads
Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead...
2018-03-08
141 reads
Set New Errorlog File location – SQL Server on Linux
For SQL Server 2017 RTM, the fourth cumulative update was released on 20th February, and it is available for download...
2018-03-08 (first published: 2018-03-01)
1,599 reads
Using the Analysis Services Execute DDL Task
My grandfather used to say, “There’s more than one way to skin a cat.” I always thought it was a...
2018-03-08 (first published: 2018-03-02)
4,752 reads
Win at IT Contracting: The recruitment Agent Business Model
WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships
Welcome to WIN at IT contracting: A...
2018-03-08
522 reads
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....
2018-03-07 (first published: 2018-02-22)
2,602 reads
Dates and Times in SQL Server: DATE
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
398 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers