Intel Haswell-EP Processor Rumors
Intel releases a new processor microarchitecture every two years, which is called a Tock release. One year later, they take...
2012-08-23
1,766 reads
Blog Posts
Learning about Driving with Big Data
This is nice, a year long safety pilot from the University of Michigan. Quite extensive, using 3,000 cars to gather...
2012-08-23
800 reads
Man Vs Machine
Man Vs Machine
Man Vs Machine
Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...
2012-08-23
1,075 reads
Microsoft Store vs Apple Store
Yesterday I went to the new Microsoft store at Florida Mall, mostly out of curiosity and something to do at...
2012-08-23
808 reads
Rant: Applying Common Sense in IT
I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...
2012-08-23 (first published: 2012-08-17)
4,606 reads
Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,599 reads
SQL Server 2005 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....
2012-08-23
1,095 reads
Tips For Minimizing Deadlocks in SQL Server
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,478 reads
Transparent Data Encryption (TDE) with Database Mirroring
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,742 reads
24 Hours of PASS, Fall 2012
It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...
2012-08-22
695 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