SSRS 2008 R2: Show Column Meta-Data in ToolTip
First, I want to apologize to the three people that read my blog. Sorry for going dark for such a...
2011-10-06
3,650 reads
SQLDownSouth
SSRS 2008 R2: How to dynamically size your INDICATORS
The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS...
2011-05-25
28,517 reads
SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)
I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...
2011-05-20
1,128 reads
WHERE HAVE YOU BEEN, patrick leblanc????
Ok, so what have I been up to?Well a lot has changed for me over the past couple of months,...
2011-05-19
1,128 reads
Report Builder: Change Report Server Connection
A question that I have been asked quite often is, “How can I change the Report Server that I am...
2011-05-19
6,492 reads
SQL Lunch #51–SQL U Presents Women in Technology
This week I am happy to announce the second SQL University SQL Lunch presentation. What’s makes this exciting is that...
2011-03-17
1,150 reads
SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
2011-03-14
5,718 reads
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-07
3,350 reads
SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)
Join us tomorrow on the SQL Lunch for a little SSIS.
Topic: #50-Solitary Containment - An Overview of SSIS Containers
If you’ve ever...
2011-03-02
753 reads
I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
653 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