Upcoming SQL Events
I realized this morning that I will be participating in three SQL Events this week and I want to share...
2010-05-23
576 reads
SQLDownSouth
Report Builder 3.0 - Using Report Parts
Report Builder 3.0 offers many new features to its users. One of the best features, in my opinion, is the...
2010-05-18
1,830 reads
SQL Server Reporting Services R2 - Publishing Report Parts
SQL Server Reporting Services R2 – Publishing Report Parts
SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish...
2010-05-16
4,189 reads
Upcoming SQL Lunch Webcasts
First, I would like to thank all that have attended and supported the SQL Lunch during our first year. We...
2010-05-13
688 reads
Creating Sparklines in PowerPivot
Sparklines are new to Microsoft Excel 2010 and Reporting Services 2008 R2. In this post I will outline the steps...
2010-05-09
2,534 reads
SQL Server 2008 Performance Tuning Webcast
I recently gave a presentation on SQL Server Performance Tuning via Live Meeting. I discussed how you could use the...
2010-05-07
1,056 reads
2010 1st Quarter Goals Review
I know it’s kind of late to write a review of my first quarter goals, since we are well into...
2010-05-07
1,096 reads
Speaking at Auckland, New Zealand SQL Users Group
On Tuesday Morning at 2:00 am EST time I will be speaking at the Auckland SQLUsers Group. This will be...
2010-04-25
543 reads
SQL Server 2008 R2 Road Show Recap
This past week I had the opportunity to speak at three SQL Server R2 Launch events.I spoke in three cities...
2010-04-23
401 reads
Editing Saved Packages
During my last SQLLunch, Introduction to SSIS, I was asked an interesting question by one of the attendees. He asked,...
2010-04-15
953 reads
Blogs
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...
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...
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