Schedule Announced for SQLSaturday#3 in Jacksonville
Brian has just posted the schedule of sessions for SQLSaturday #3. I haven't gone through to see how many are...
2008-03-31
1,338 reads
Blog Posts
T-SQL Course
I am here in sunny Orlando at End to End Training. I am very impressed with the new training facility....
2008-03-31
1,369 reads
Practices Does Make a Difference When Speaking
As I've mentioned a couple times previously I teach a free 'how to be a speaker' course, mainly to encourage...
2008-03-30
1,378 reads
SQL Saturday
I've just received notice that I will be a presenter at the upcoming SQL Saturday event in Jacksonville, Florida. I'll...
2008-03-30
1,530 reads
How Should It Work?
I was following a debate on the new Merge syntax in SQL Server 2008 with interest. It was somewhat of...
2008-03-28
1,509 reads
More Code Per Module = More Bugs, But More Complex Code <> More Bugs?
SDTimes has an article up about Debunking Cyclomatic Complexity that talks about the results of some research that supports what I...
2008-03-28
1,512 reads
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,530 reads
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...
2008-03-28
1,446 reads
The Shadow Knows What Procedures Lurk in the SQL Plan Cache
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...
2008-03-28
1,474 reads
Getting Reporting Services to work on Vista
I recently ordered a new laptop and this one came with Windows Vista Ultimate. I knew about having to install...
2008-03-26
2,744 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