Phil Factor SQL Speed Phreak Competition
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,150 reads
Blog Posts
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,873 reads
Red Gate Has 10th Birthday
I first met Simon Galbraith, one of the co-owners of Red Gate Software at PASS in 2002, when they had...
2009-10-24
408 reads
Another Year, Another Missed PASS Summit
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,667 reads
Download the Free eBook “The SQL Server Tacklebox”
Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts...
2009-10-23
583 reads
Just Submitted Session for South Florida Code Camp
I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for...
2009-10-23
359 reads
Not Pointing Fingers - Microsoft and Sidekicks
Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They...
2009-10-23
810 reads
PASS Summit One Week Away
It’s just a week and a couple of days before I’ll be hopping a plane for Seattle and the 2009...
2009-10-23
582 reads
Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,491 reads
Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,328 reads
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers