The meaning of Database Administrator
In two blogs I follow, Andy Leonard's blog on SQLBlogs.com and Sheeri Kritzer's The MySQL She-BA, the question of what...
2007-07-16
1,568 reads
Blog Posts
SQL Server Reporting Services (SSRS) Templates and Styles
Ever wanted to change the default template and style for the Reporting Services Wizard? Just think how much time this...
2007-07-15
8,433 reads
Beta Testing
I'm not big on beta testing, or at least haven't been for a number of
years because I can't afford the...
2007-07-13
1,383 reads
Buy a $10 Raffle Ticket to Help Katie
Not a happy story, but if you've got a child I suspect it will be easy to decide to buy...
2007-07-12
1,389 reads
The Business of Software
It's interesting being at a software company, especially one that's
building on another platform. I've never done this before, having
worked for...
2007-07-12
1,409 reads
Working in solitude
If you've spent much time at all reading Steve Jones's blog posts and SSC editorials, you quickly glean that he...
2007-07-12
1,486 reads
Reminder: Midlands PASS Chapter Meeting Tomorrow Night
What: Midlands PASS Chapter July Meeting
Where: Training Concepts (250 Berryhill Road, Suite 502, Columbia, SC)
When: 6:15-8:00 PM
Speaker: SQL Server MVP...
2007-07-11
1,447 reads
Upgrade or Wait
Lots of debate and disagreement on my recommendation to wait for SQL
Server 2008 instead of upgrading to SQL Server 2005...
2007-07-11
1,442 reads
SQL Server 2008
Just when I was about to start a pool for the release date, Microsoft announced today it will release on...
2007-07-10
1,395 reads
The Business of Publishing
Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...
2007-07-10
631 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
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