SQL Server: Sending Email in HTML Table Format Using TSQL
As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about...
2012-10-04
1,505 reads
Blog Posts
Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,287 reads
Webcast on SQL Server Auditing on October 9th
Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...
2012-10-04
1,059 reads
2012 PASS Board of Directors Elections - It's Time To Vote!
It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...
2012-10-03
1,193 reads
Blog Changes
I have made a few changes to the blog over the past couple weeks The changes have come about as...
2012-10-03
648 reads
Dealing with orphaned users
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,711 reads
Get a Free SQL Server Indexing Book
What would you say if I offered you the best indexing book on the market for SQL Server 2012?
Wow, right?...
2012-10-03
704 reads
PASS 2012 Countdown – 5 Weeks To Go – Addendum
One thing to add for the 5-week countdown… are you an alumni to the PASS Summit? If so, why don’t...
2012-10-03
512 reads
PASS First Timers Guide and Schedule – 2012 edition
Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!)one (ONE!!) week until the 2012 PASS Summit in Seattle,...
2012-10-03
1,220 reads
ReFS || next generation file system for Windows
Q) Why is it named ReFS?
ReFS stands for Resilient File System. Although it is designed to be better in many...
2012-10-03
606 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
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
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