Vista Woes
So my DVD drive in the new laptop appeared to be dead. It didn't appear in the "Computer" list with...
2007-12-28
1,466 reads
Blog Posts
Comments on "The Exceptional Presenter"
I purchased The Exceptional Presenter recently as part of my professional development spending. I currently work primarily as a trainer...
2007-12-27
1,488 reads
PCMagazine Goes to Monthly Format
I don't have a URL handy for it, but in the latest print issue of PC Mag they announced changing...
2007-12-26
1,393 reads
Assimilated
Maybe I'm succombing, maybe I'm lazy, most likely I don't want to mess with it.
I found some instructions for nLite,...
2007-12-25
1,487 reads
Planning a SQL 2008 Launch Event
As a user group leader I see new products as a chance to make sure our members know about the...
2007-12-25
1,483 reads
XP Struggles
My new laptop came with Vista Home and I messed with it for awhile last night, but I didn't see...
2007-12-24
1,459 reads
Quismo F40
My new laptop showed up today at my desk. Actually it probably showed up yesterday, but since I never went...
2007-12-23
1,536 reads
70-431
I finally sat for 70-431 on Thursday. I know, I am at least a year behind everyone else. There is...
2007-12-22
1,361 reads
Last Minute Learning
Someone posted a question about what should they try to learn for an interview coming soon, but the company was...
2007-12-20
1,536 reads
Upgrading to Office 2007
I've put this off for a while, but I needed a break from the routine and I'm starting to get...
2007-12-20
1,384 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