2012-10-05
4 reads
Blog Posts
2012-10-05
5 reads
Reblog: September 28 to October 4
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-05
484 reads
SQL Azure–Failed to Update because the database is read-only
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...
2012-10-05
2,340 reads
SQL Saturday #149 Session Materials
This past weekend I attended this year’s SQL Saturday in Minnesota. It was a good time, and it was on...
2012-10-05
676 reads
Create a portable virtual machine with OVF or OVA
Today a great client asked me how to export a VM to an OVF or OVA so he could transport...
2012-10-04
1,532 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I...
2012-10-04
2 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
941 reads
Jacksonville Code Camp 2012
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...
2012-10-04
1,173 reads
Master Data Services (MDS): Bug deleting an attribute
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has...
2012-10-04
1,411 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