VMware vSphere 5.1 vCenter Data Protection Funny
VMware, why won’t you allow special characters in your root password?
Tweet
2012-09-22
590 reads
Blog Posts
Welcome to Everday SQL
My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years. During that...
2012-09-22
352 reads
Create Database Script
I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...
2012-09-21
1,172 reads
Going to the PASS Summit? Join Us at a Networking Dinner
For the third year Steve Jones and I are coordinating a very informal networking dinner on Monday night the week...
2012-09-21 (first published: 2012-09-15)
1,815 reads
Mac Daddy!
In my Three Strikes post I wrapped up the sorry tale of trying to get an X1 Carbon delivered from...
2012-09-21
789 reads
Notes from My 24 Hours of PASS Presentation
Quick notes:
Because it was scheduled for 7 am local I decided to do it from home. Good plan, except it...
2012-09-21
822 reads
PASS Elections 2012
Yeah, it’s that time again. And we have a magnificent slate of people running. I mean truly amazing and wonderful...
2012-09-21
703 reads
SQL Server Data Tools (SSDT) – September 2012 update
SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225). The SSDT team...
2012-09-21
1,595 reads
SQLTreeo resurrection
I would like to inform you that I transferred all activities around SQLTreeo SSMS Add-In to couple of persons who...
2012-09-21
769 reads
Transact-SQL analytic functions in SQL Server can help solve problems quickly
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical tasks. With the...
2012-09-21
1,530 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