Microsoft Certifications and MVP’s – What are they?
I take it for granted that everyone knows all about Microsoft certifications and Microsoft MVP’s. But a few years ago,...
2011-08-05
1,645 reads
Blog Posts
PowerPivot – Perspectives
PowerPivot – Perspectives
Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split...
2011-08-05
4,419 reads
Re-blog – July 29-August 4
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-05
564 reads
Two New TPC-E Submissions
Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three...
2011-08-05
971 reads
Celebrating Mistakes-Part 1
Most of us learn more from mistakes than successes. We talk about taking risks, but what is the average response...
2011-08-04
673 reads
MSSQLTips.com Kindle Contest
I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...
2011-08-04
1,043 reads
The Best Part of My New Job
The Best Part of My New Job
Come to the Dark Side, We have Nutter Butters
If you had told me a...
2011-08-04
912 reads
A Really Bad Day
I was out of town for work one day, literally on the other side of the country, in a car...
2011-08-03
868 reads
All About Execution Plans
If you’re attending the PASS Summit this October, I’d like to make a suggestion. The Summit itself is only three...
2011-08-03
861 reads
Applying a Snapshot -AltSnapshotFolder Parameter
Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter? This means that after...
2011-08-03
545 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
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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