Running a document database on Sql Server
Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...
2012-09-26
14,744 reads
Blog Posts
SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,420 reads
SQL Server: Part 4 : Approaching Database Server Performance Issue
In the last three parts, we have discussed about different queries that can be used to list the current state...
2012-09-26
1,745 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
900 reads
WIT Wednesday
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-09-26
1,126 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond,...
2012-09-25
8 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday...
2012-09-25
1,171 reads
Master Data Services: Resources
Here are some of my favorite Master Data Services (MDS) resources:
SQL Server Master Data Services Utilities: A set of useful...
2012-09-25
2,560 reads
SQL In The City: Austin
So, No SQL Saturday in Austin This Year.
I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in...
2012-09-25
1,042 reads
SQL Server || Change Batch separator
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is...
2012-09-25
2,057 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
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