How To Participate In The PASS Summit When You Can't Be There
Bummed that you can't go to the PASS Summit in Seattle this year? Turn that frown upside down because there...
2010-11-03
688 reads
Blog Posts
Kilt Day
A week from now will be Kilt Day at the PASS Summit. It’s probably way too late to order a...
2010-11-03
668 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
841 reads
More PASS Summit Tips For First Timers
Yesterday I posted my tips for PASS Summit First Timers, and of course as soon as I did I remembered...
2010-11-03
1,786 reads
My PASS Summit Schedule
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
665 reads
PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,755 reads
PASS Update #45 (Agenda for SQLSaturday Roundtable)
If you’re attending the 2010 Summit and are interested in helping improve SQLSaturday, I hope you’ll register and attend our...
2010-11-03
341 reads
PASS Update #46 (What Should PASS Be?)
I’ve been wanting to write this for a while, and I haven’t because I felt that I just didn’t quite...
2010-11-03
408 reads
Powershell and Policy Based Management
If you haven’t looked at Policy Based Management (PBM), and you manage multiple instances, you ought to really look at...
2010-11-03
971 reads
Service Broker – SQL Server Connections
These are some notes and thoughts from sessions and my time at SQL Server Connections/DevConnections in Nov 2010.
Denny Cherry gives...
2010-11-03
1,602 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Bulevar Hijau Lyn Cs 083835110341
Ruko Sentra Niaga 2, Jl. Harapan Indah Raya No.1A Blok SN-2, Pejuang, Kecamatan Medan...
BCA KCP Summarecon Bekasi Lyn Cs 083835110341
Jl. Bulevar Ahmad Yani, Graha Bulevar Signature (GBS) Blok C No. 3, RT.001/RW.011, Harapan...
BCA KCP Juanda Lyn Cs 083835110341
Jl. Insinyur H. Juanda No.54, RT.003/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers