SQL Saturday 58 – It’s A Wrap! #sqlsat58
It’s Tuesday after PASSMN’s first SQL Saturday event in Minnesota. After a restful weekend, I’m finally starting to completely wind...
2010-11-03
454 reads
Blog Posts
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
Working on a large DW project, I had the pleasure of...
2010-11-03
818 reads
SQLServerPedia Award Votes
This is just another reminder to please vote for my blog post on using PowerShell Remoting with SQL Server. It’s...
2010-11-03
575 reads
Successful Teams: Everyone Performs
By day I'm a DBA. Nights and weekends I'm a junior high youth pastor and Awana commander. I have the...
2010-11-03
1,472 reads
VLDB Issues at SQL Server Connections
Kim Tripp is a great speaker, with a wealth of knowledge. This session was talking about some of the issues...
2010-11-03
727 reads
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It...
2010-11-02
575 reads
Help! I Can’t Connect to Analysis Services in SSMS
A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well....
2010-11-02
1,603 reads
I’m speaking for the Performance Virtual Chapter of PASS
On January 4, I’m speaking about index internals for the Performance Virtual Chapter
of PASS (http://performance.sqlpass.org).
Here’s my session abstract:
SQL Server provides...
2010-11-02
598 reads
Life Without a Net – My comment
Did you catch the brilliant and thought provoking editorial post Life Without a Net by Rodney Landrum on SQL Server...
2010-11-02
415 reads
Scripting Guy Guest Blog Post
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off a SQL Server week (Nov 1st 2010) with my guest blog...
2010-11-02
584 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