Vote for Mr. LaRock
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...
2009-09-29
1,569 reads
Blog Posts
Adding a folder to the SSIS Package Store
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on...
2009-09-28
6,339 reads
Arrive in Sydney To Begin 30-Day Australia & New Zealand Speaking Tour
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9...
2009-09-28
420 reads
Arrive in Sydney To Begin 30-Day Australia & New Zealand Speaking Tour
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9...
2009-09-28
483 reads
Back From Vacation and Making a Big Mistake
I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I...
2009-09-28
656 reads
Don't Tick Me Off...CPU Ticks
OK, there was something that Microsoft did to tick me off. SQL Server 2005 introduced us to so many exciting...
2009-09-28
6,195 reads
MVP book is available for preorder
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going...
2009-09-28
564 reads
Out of Space
It seems that often I see posts that say “I’m out of space on my drive, what do I do?”...
2009-09-28
1,555 reads
Reporting Services - Disable Loop Back Check
I have been installing and configuring SSRS since the initial release. I have always encountered several different caveats when upgrading...
2009-09-28
5,166 reads
Sales vs Operations
It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production....
2009-09-28
952 reads
Blogs
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...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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?
Removing TDE
Comments posted to this topic are about the item Removing TDE
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