Refresh QA Database with Manual Scripts
Couple of week back Megha Sharma send me an email with a document attached, this document is all about how...
2011-10-27
700 reads
Blog Posts
SQL University: SQL Agent Jobs That Run at SQL Agent Start
Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...
2011-10-27
2,954 reads
A Bit of a SQL Saturday 99 Update…
I’ve been a bit busy while planning this year’s SQL Saturday in Minnesota. Unfortunately, that hasn’t led to a lot...
2011-10-26
757 reads
Applied SQL: Demonstrate Simple Backup and Restore
Let’s apply a little backup and restore knowledge, eh wot?
I introduce this whole concept in Applied SQL: You Have Homework....
2011-10-26
799 reads
Buckets for Disaster Recovery
Disaster recovery can be a huge project at any company. Considering the ways in which you build a plan that...
2011-10-26
1,330 reads
Dimensional Modeling Financial Data in SSAS
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I...
2011-10-26
5,522 reads
I’m a winner!
Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog...
2011-10-26
811 reads
Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
853 reads
SQLInspireNYC - You can still REGISTER for FREE! - Embarcadero Give-a-way
You may have missed the big announcement yesterday on SQLServerCentral.com, that thanks to one of our great event sponsors, Red Gate, we...
2011-10-26
951 reads
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your...
2011-10-26
7,396 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