S3OLV July Recap
This month we had our first adventure in LiveMeeting presentations. We had the pleasure of listening to Jack Corbett give...
2010-07-12
431 reads
Blog Posts
Settling or Pushing On
I read a blog recently that was titled: Time to Stop Settling. I think that the author (a friend) was...
2010-07-12
382 reads
Should DBAs Be the Protectors of Data?
Originally published in the Database Weekly newsletter.
I used to work at a large organization ($8 billion in revenues) as a...
2010-07-12
412 reads
Speaking at Greater New Orleans .Net User Group (GNO.NET)
This week I will speaking at the Greater New Orleans .Net User Group. My topic is Introduction to the SQL...
2010-07-12
678 reads
Speaking at Nashville, St Louis, and Baton Rouge in August
In August, I will be presenting at the following events:
DevLINK, August 5-7, 2010
How and When to Use Indexed ViewsIdentifying SQL...
2010-07-12
558 reads
SQL Lunch Presentation Today and Wednesday
A heavy week for SQL Lunch with two presentations!
There is another SQL Lunch presentation scheduled for today at 12:30 EDT. Join...
2010-07-12
572 reads
SQL Saturday #28 “Refer a Friend Contest”
With all the MSDN give away contests, I decided to add another. Here are the official rules for the twitter...
2010-07-12
562 reads
SQL Server DMV Starter Pack E-Book Published
Red Gate Books has published a new e-book called “SQL Server DMV Starter Pack”, which you can download for free...
2010-07-12
2,075 reads
SQLSaturday #49 – Orlando Pre-Conference with Louis Davidson
The planning team of SQLSaturday #49 – Orlando and OPASS are proud to announce that there will be a pre-conference seminar...
2010-07-12
774 reads
SSIS - Enabling Logging
Have you ever had a scheduled run of one of your SSIS packages fail? Have you ever wished you had...
2010-07-12
2,041 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