My First Computer
OK, I’m not going to make a huge habit of responding to these chains, but I have a few spare...
2009-02-27
1,655 reads
Blog Posts
BoiseCodeCamp and TechFest to be Held March 28, 2009
The BoiseCodeCamp and TechFest will be held Saturday, March 28th at Boise State University. This free event include 57 one-hour...
2009-02-26
1,384 reads
Featured Blog - Linchi Shea
If you haven't visited yet, you definitely want to read Linchi's blog - it's packed full of on topic posts about...
2009-02-26
1,806 reads
The Downsides of e-Commerce
Last year I was in a bookstore and looking through some books with Andy Warren of End to End Training....
2009-02-26
1,658 reads
Upcoming Speaking Engagements
I've got three speaking engagements lined up in next two months:
Wed, March 11 @ oPASS: The Truth About Disk Performance & Configuration....
2009-02-26
1,407 reads
A Cloudy Story
The other day Paul Neilson wrote a simple post making predictions about SQL Server in the Cloud. That got a...
2009-02-25
1,619 reads
Business Is More Than Code
Chris Shaw, owner of SQL Oncall, recently had an issue in his business. Chris provides DBA services on a remote...
2009-02-25
1,651 reads
devLINK Call for Speakers to End March 13, 2009
If you are interested in speaking at the devLINK Technical Conference in Nashville, TN, August 13-15th, you need to get...
2009-02-25
1,348 reads
Fear Based Decisions
Most of us aren't good decision makers. We make decisions based on emotion rather than facts, and for many decisions...
2009-02-25
2,280 reads
Finding a Work-Life Balance
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance...
2009-02-25
1,594 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers