Let’s Talk
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
871 reads
Blog Posts
March 2012 – Monthly SQL Server Checklist
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can...
2012-03-08
1,769 reads
March Madness – SQL Server style
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
635 reads
Moving MASTER Database
In my previous post we see how to move MSDB database, today we will see how to move or relocate...
2012-03-08
1,070 reads
SQL Server – netstat monitoring and tuning performance
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,320 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites...
2012-03-08
789 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong? I would dare say that...
2012-03-08
4 reads
Why I am excited about SQL Server 2012
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
673 reads
Backing up a Certificate
If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....
2012-03-07 (first published: 2012-02-27)
10,713 reads
Enabling Filestream in SQL Server 2012
Filestream is a cool feature, albeit one that’s cumbersome to use in SQL Server 2008 and R2. However the FileTable...
2012-03-07
3,642 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