70-444 Exam Prep Book
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
733 reads
Blog Posts
Blogs
One of the suggestions I saw today was to add blogs to the user profile on the site and not...
2007-07-05
646 reads
The Journey to Katmai
I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming...
2007-07-04
662 reads
Breaking Up is Easy to Do
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
602 reads
Who said that breaking up is hard to do?
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
613 reads
Working Remotely
Most people I know tend to work in one of two places consistently: work or home. So they've built a...
2007-07-03
570 reads
Earthquake
This is pretty cool, a, earthquake test for Project Black Box from Sun. They take one of their systems to...
2007-07-01
632 reads
SQL Server Error Logs
The active SQL Server error log is one of the first places people look when there is a problem. For...
2007-06-29
1,594 reads
The War Begins :: Reporting for duty
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we...
2007-06-29
1,338 reads
Walking the Line
I have the best job here at SQLServerCentral.com. I work from home, I get to be creative, writing about what...
2007-06-28
1,374 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers