Powershell Charting with MS Chart Controls
Richard MacDonald's demonstrates using Microsoft Chart Controls with Powershell in his post, Charting with Powershell. The chart controls are free and work with...
2009-07-09
3,470 reads
Blog Posts
Whitepapers – Good or Evil?
I was having a discussion with Brian Knight yesterday about whitepapers and thought I’d share some of it – from my...
2009-07-09
436 reads
A Laptop is nice
It's almost 9, I've been working for over an hour, and only one foot has left the bed. It touched...
2009-07-08
454 reads
I Need a Logo
I've been doing the Voice of the DBA podcasts for over a year now, and I really enjoy them. I've...
2009-07-08
895 reads
PASS Update #11 (Networking Seminar at the PASS Summit)
If you haven’t seen the news yet we’ve got something new on the schedule this year – a 2 hour seminar...
2009-07-08
563 reads
SSC Site Issues
It was kind of amazing to see SQLServerCentral have issues over the last few days. We’re still not sure what...
2009-07-08
476 reads
The Criminals are Always Ahead
A new scheme to get ATM PIN numbers using automated systems and VOIP is in play. It's described here and...
2009-07-08
287 reads
Booked for SQLSaturday #17 - Baton Rouge
I finally made the call today to reserve my room in Baton Rouge for SQLSaturday #17 in Baton Rouge, LA....
2009-07-07
568 reads
Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
368 reads
Shrinking the Log
It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to...
2009-07-07
1,850 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