bedpost - It's Business Time
Further off topic than usual, but I ran across this as I browsed Springwise after a friend suggested it might...
2009-04-01
588 reads
Blog Posts
Congratulations to Grant Fritchey
He was awarded MVP status today, no joke, for his work in the community.
According to his blog, it’s not a...
2009-04-01
940 reads
Congratulations to MVP Grant Fritchey
Announced today on his blog at http://scarydba.wordpress.com/2009/04/01/mvp/. Well earned in my opinion between his participation with PASS, SSC, and his...
2009-04-01
417 reads
LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
513 reads
Moving to MySQL
It’s time. After years of building this site to work with SQL Server, I sold it to Red Gate Software....
2009-04-01
491 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
539 reads
Buying A Plane
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,469 reads
Keeping Relevant in the Face of Changing Technologies
I was recently asked by a co-worker on my team at work what he should do to keep up with...
2009-03-31
1,887 reads
Lunch in Town
One of the guys I met at the Denver User Group pinged me last week for lunch, and I agreed....
2009-03-31
1,814 reads
Microsoft Project Migration Template for the move to SQL 2008
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,822 reads
Blogs
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...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
Forums
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
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
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