New DBA type: Test DBA
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,888 reads
Blog Posts
New Benchmarks
There are new TPC-E benchmarks available for SQL Server 2008. And it's not even out!!!!
The 3rd place, the IBM entry,...
2008-02-28
1,479 reads
Notes From My Visit with the Charlotte SQL Group
I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my...
2008-02-28
1,296 reads
Snapshots Part 1 Published on SSC
Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In...
2008-02-26
1,249 reads
The Launch
The launch event is tomorrow in LA and I'm not going, and find myself a little disappointed. There will be...
2008-02-26
1,392 reads
Using TripIt for Travel Plans
Not a SQL related topic today.
I first noticed Tripit on Joels Blog and so far it solves a problem I've...
2008-02-26
1,288 reads
Perks at Work - A Good Thing?
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,417 reads
Lessons Learned from SQLSaturday #2 - Tampa 2008
I posted earlier about the event being a great success with more than 200 attendees, in this post I want...
2008-02-24
1,477 reads
The Advantages of Telecommutting
It isn't often that I see what the real advantages are, and I've been doing it so long that I...
2008-02-22
1,346 reads
Call for Speakers for PASS Summit is Open Through March 28, 2008
The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's...
2008-02-21
1,427 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