Management Article Posted on SSC
I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for...
2008-02-18
651 reads
Blog Posts
SQLSaturday #2 (Tampa 2008) Notes
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
Turning off a server causes a flood of memories
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server...
2008-02-17
402 reads
Software Engineering
Some see this as a misnomer, or even an oxymoron. Many countries don't allow "engineer" to be a title for...
2008-02-16
1,087 reads
Speaking updates
If you are anywhere near St. Louis next Wednesday night, I will be speaking at the St. Louis Visual Basic...
2008-02-16
512 reads
Is SQL Server Dead?
Someone sent me this note about a talk they'd had at their user group and the guest speaker mentioned the...
2008-02-14
2,257 reads
Getting Geeks (IT Pro's) To Talk at User Group Meetings
User groups have to be about more than technical content if you want to sustain them over the long term,...
2008-02-14
487 reads
Should Code Camp/SQLSaturday Be Free?
Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend...
2008-02-13
632 reads
Change Data Capture
I started working through some labs for my SQL Server 2008 class and one of the labs was on the...
2008-02-12
1,154 reads
Computed Columns Published on SSC
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
444 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