Knowing Someone Makes a Difference-Part 2
How long does it take you to get comfortable at a new job. How long to figure out who is...
2011-07-20
911 reads
Blog Posts
PowerPivot - Measure Grid
There are a lot of fantastic new features in the latest CTP 3 release of PowerPivot, which you can download...
2011-07-20
2,510 reads
SQL Server “Denali”: New Certifications
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the...
2011-07-20
1,724 reads
SQL Server 2008 SP2 cumulative update 5
AdvertisementsSQL Server 2008 SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it.
Cumulative Update 5 for SQL...
2011-07-20
715 reads
SQL Server Denali Installation Change
Tonight I took my first crack at getting SQL Server Denali up and running on my machine.From what I had...
2011-07-20
1,413 reads
Upcoming Webinar on Using SQL Monitor in the Real World
Recently at SQLServerCentral.com, I have been running a series of articles called the SQLServerCentral.com Best Practices Clinic, which describe how...
2011-07-20
531 reads
A Big Milestone-SQLSaturday #100
Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years...
2011-07-19
772 reads
A Guest at the Ranch
From the other side of the world, I had a guest at the ranch today.
Pinal Dave, a friend from...
2011-07-19
814 reads
Denali–IIF and CHOOSE
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
795 reads
Knowing Someone Makes a Difference-Part 1
I’ve put a lot more emphasis on networking in the last few years and I’ve always considered it an investment,...
2011-07-19
616 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Lingkar Timur TLP/WA 08216977749
Jl. Salak No.99 & 100, Lkr. Tim., Kec. Singaran Pati, Kota Bengkulu, Bengkulu 38226
BCA KCP Pondok Indah Telpon/wa:0813.7887.595
BCA KCP Pondok Indah Telpon/wa:0813.7887.595.Jl. Metro Pondok Indah No.60 & 61 UA, Pd. Pinang,...
BCA KCP Kas Pagar Dewa TLP/WA 08216977749
Jl. Depati Payung Negara Ruko No.2, RT.025/RW.005, Pagar Dewa, Kec. Selebar, Kota Bengkulu, Bengkulu...
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