Cross Database RI Issues
I had an issue with a user recently. Actually it has been going on over a few weeks, due to...
2010-02-23
962 reads
Blog Posts
Database Weekly Week
I used to build the Database Weekly newsletter and write the editorial every week. It was a chore, and it’s...
2010-02-23
800 reads
Day 1 - Pragmatic Works Webinar Series
WOW – what a great turnout for our webinar series today. We had two sessions on Monday, looking for some great...
2010-02-23
584 reads
Find Ultimate Parent at any Level From Any Level
Recently I got a forum question that I thought would be a good blog entry for others to share.
The question...
2010-02-23
865 reads
IntelliSense Slow to Refresh
IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more...
2010-02-23
7,495 reads
MVP Summit Review
I was lucky enough to attend the MVP Summit held last week in Redmond and Bellevue. I attended the Summit...
2010-02-23
852 reads
Quest POTW Webcast on SQL Injection Now Available
Back a couple of weeks ago I had the privilege of participating in a Pain of the Week webcast with Kevin...
2010-02-23
1,376 reads
Self-Managed Oracle Databases – Good or Bad ?!
Should we as DBAs be worried that we will become surplus to requirements if Oracle continues to enhance its capabilities to deliver a self-managing...
2010-02-23
384 reads
Setup a Database Snapshot
I have been tinkering lately with database snapshots and I thought the subject warranted a short post on the subject....
2010-02-23
751 reads
SQL Server 2008 R2 Gets a Real Date
Hot Off The Presses !
This isn’t like when you stood in line at the kissing booth in high school. SQL...
2010-02-23
498 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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