Ft. Worth SQL Server User Group Meeting Recap
I’d like to say thanks to Andy and Judith over at the Ft. Worth SQL Server User Group for having...
2009-11-26
774 reads
Blog Posts
Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3
Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of...
2009-11-26
1,437 reads
PASS European Conference 2010 Call for Speakers is Open
If you are interested in speaking at the PASS European Conference 2010, to be held in Neuss, Germany, April 21-23,...
2009-11-26
583 reads
A good way to learn
I have noticed that one of the best way to learn about a certain topic is to write an article...
2009-11-25
691 reads
Cleaning out Tempdb
I saw a post recently about the tempdb being overly large and causing issues for a user. The person was...
2009-11-25
2,280 reads
In Charge
I had to run our weekly conference call this week. My boss is out of the office, but he’s been...
2009-11-25
741 reads
More on DBAs and Local Administrator Rights
I'm looking over the comments about DBAs and local Administrator rights and I noticed an interesting trend: no one discussed...
2009-11-25
2,602 reads
Thanksgiving This Year, Stress, Cooking Something New, and Others
I know Thanksgiving has some deeper meanings, but at one level it’s all about the food. Food is a good...
2009-11-25
609 reads
To Grant or Not to grant
It is said that you should not give direct table access (even select permission) to a user or group. But...
2009-11-25
525 reads
Balancing Time Today v Time Tomorrow
I’ve always thought that you should invest where you can. Make a little effort now that will pay back later,...
2009-11-24
741 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers