Moving Forward with Nuclear
We use a lot of power in our computing infrastructure. And while I’m mindful of the concerns over safety, environment,...
2009-04-24
894 reads
Blog Posts
PASS Summit Sessions Submitted
It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see...
2009-04-24
659 reads
Patterns & Practices SIG starting up in Columbia, SC
C# MVP Chris Eargle (@kodefuguru on Twitter), who is also an INETA community champion and president of the Columbia Enterprise...
2009-04-24
1,006 reads
SQL Server Security Basics: Why Would I Use SQL Server Authentication?
The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL...
2009-04-24
3,805 reads
Book Review: The Speed of Trust
I finally finished up reading the Speed of Trust and have to say I struggled with it. I'm a big...
2009-04-23
790 reads
Building Something Fun
A little further off topic than usual today, something not about technology and work for a change. Woodworking is one...
2009-04-23
1,406 reads
Simple Maintenance Tasks for Non-Production Databases
Log File Sizes:
It's not unusual to see cases where database backups are taken from production and restored to a development or QA environment....
2009-04-23
1,344 reads
Spring Still Not Really Hitting Montreal Yet, thus More Time to Hunt Down Useless Indexes
Hopefully, by the time we have our annual family vacation in May, the Cherry Blossoms will be out – until then...
2009-04-23
749 reads
The Google Containers
After my editorial on portable data centers, I had a number of people knock down the idea, saying it doesn’t...
2009-04-23
814 reads
The Twitter Ripples
I saw this post on The Business of Software Blog about a use of Twitter to spread the word for...
2009-04-23
645 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
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