Speaking Twice This Week
This week I will have the opportunity to speak at two different events. The first is on Monday, April 12th,...
2010-04-11
447 reads
SQLDownSouth
SSRS - Formatting Mutiple Columns
Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix....
2010-03-19
1,575 reads
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-17
814 reads
Using a CTE with a T-SQL Pivot Statement
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a...
2010-03-09
9,605 reads
Speaking at Charlotte, NC - SQL Saturday #33
If you are near Charlotte, NC, I will be speaking at their SQL Saturday on March 6th, 2010. My session, SQL Server...
2010-03-01
500 reads
SSRS – KPIs without Analysis Services
During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...
2010-03-01
2,399 reads
Upcoming SQL Lunch Webinars
If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL...
2010-02-24
1,023 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
735 reads
Free SQL Server Webinar Series
Are you new to SQL Server?Do you want to learn about its many features and capabilities? If so, please join...
2010-02-20
775 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,282 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