BIOS and OS Power Settings to enhance SQL Server Performance
Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive...
2019-01-09
1,525 reads
Blog Posts
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
One of my Code Project article on SQL Trigger has...
2019-01-09
263 reads
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.One of my Code Project article on SQL Trigger has been selected as entry in this contest. I...
2019-01-09
4 reads
Pro SQL Server on Linux–Install
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-09
353 reads
Query memory grants part 2: Varchars and sorting
Why the heck did we make all our columns varchar? That’s a hypothetical question, please.
But now we have to pay...
2019-01-09
133 reads
Source Control using Azure Data Studio and GitHub
You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...
2019-01-09
3,494 reads
Source Control using Azure Data Studio and GitHub
You can maintain and deploy code easily
Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...
2019-01-09
15 reads
SQL Server Removing Duplicates
I know, I know your data could never possibly have duplicates because obviously, you have all the constraints in place...
2019-01-09 (first published: 2019-01-03)
2,991 reads
Store sensitive information with Azure Key Vault
Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....
2019-01-09
282 reads
Testing SQL in the Advent of Code
I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in...
2019-01-09 (first published: 2018-12-28)
2,152 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