SQLSaturday #2 (Tampa 2008) Notes
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
Blog Posts
Turning off a server causes a flood of memories
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server...
2008-02-17
402 reads
Software Engineering
Some see this as a misnomer, or even an oxymoron. Many countries don't allow "engineer" to be a title for...
2008-02-16
1,087 reads
Speaking updates
If you are anywhere near St. Louis next Wednesday night, I will be speaking at the St. Louis Visual Basic...
2008-02-16
512 reads
Is SQL Server Dead?
Someone sent me this note about a talk they'd had at their user group and the guest speaker mentioned the...
2008-02-14
2,257 reads
Getting Geeks (IT Pro's) To Talk at User Group Meetings
User groups have to be about more than technical content if you want to sustain them over the long term,...
2008-02-14
487 reads
Should Code Camp/SQLSaturday Be Free?
Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend...
2008-02-13
632 reads
Change Data Capture
I started working through some labs for my SQL Server 2008 class and one of the labs was on the...
2008-02-12
1,154 reads
Computed Columns Published on SSC
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
444 reads
Speaker Eval Form, Part 2
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
978 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