February OPASS Meeting Tonight
It's here! Our February meeting is tonight at 6pm at End To End Training, 225 S. Westmonte Drive, Suite 2010,...
2010-02-09
377 reads
Blog Posts
Interviewed at CSTechCast
The segment should go out in this week’s show, but I spent half a day down in Colorado Springs with...
2010-02-09
360 reads
Isn’t Consulting Risky?
Small Business Ownership. It’s one of the Great American Dreams. Our forefathers, the founders of the country that I call...
2010-02-09
781 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-09
324 reads
Join me at the Memphis SQL Server User Group meeting
For almost a year now, I’ve exchanged emails with the leaders of the Memphis SQL Server User Group, trying to...
2010-02-09
317 reads
Pragmatic Works Foundation Class Introduction
You may have noticed a flux of new blog post entires yesterday from a group of people talking about the...
2010-02-09
804 reads
Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
881 reads
Relationships - T-SQL Tuesday #3
I missed T-SQL Tuesday #1, but participated in T-SQL Tuesday #2. Now it's time for #3, and I'm making my...
2010-02-09
3,377 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
528 reads
Speaking at the Rocky Mountain Tech Trifecta on February 27
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With...
2010-02-09
503 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