One Week from SQLRally!
SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...
2012-05-02
846 reads
Blog Posts
Presenting at SQL Saturday 119 Chicago!
First thing in the morning Saturday May 19th:
I will be presenting with my colleague from House of Brick David Klee...
2012-05-02
559 reads
SQL Server Indexed Views Explained
Indexed views are a really powerful and possibly underused feature of SQL Server. It’s basically a way of writing a...
2012-05-02
54 reads
SQLFriends in Minneapolis
Ever wanted to hang out and talk about SQL Server over lunch? Maybe get a chance to ask those questions...
2012-05-02
618 reads
Automatic page repair with SQL Server Mirroring
Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...
2012-05-01 (first published: 2012-04-24)
3,202 reads
Checking Your Main BIOS Version
As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....
2012-05-01
1,769 reads
Creating a Sequence in SQL Server 2012
Sequences are a new object in SQL Server 2012 that generate just what the name implies: a sequence of numbers....
2012-05-01
2,933 reads
Denali — Day 1: Tempdb Compatibility – Bug?
Denali — Day 1: Tempdb Compatibility – Bug?
I have installed sql server 2012 express and evolution edition on my personal laptop, and...
2012-05-01
464 reads
How to Configure Database mail
In my daily job as a SQL Server consultant I go to a lot of places, many days on the...
2012-05-01
8,478 reads
How to execute a package from another package?
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows...
2012-05-01
2,151 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