Reporting Services - Disable Loop Back Check
I have been installing and configuring SSRS since the initial release. I have always encountered several different caveats when upgrading...
2010-02-17
727 reads
SQLDownSouth
Technet and MSDN coming to Baton Rouge
On March 4th Microsoft will be hosting two half-day events in Baton Rouge, LA.These free live learning sessions will explore...
2010-02-15
725 reads
Set your Warehouse Database to Read Only
In most environments new data is added to the data warehouse daily, weekly or even monthly.Even further, these changes typically...
2010-02-15
725 reads
Recap - SQL Saturday #32 Tampa
This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa.First, I just want to...
2010-01-24
501 reads
PASS Virtual Meeting - Zero to Cube in 60 Minutes
PASS Virtual Meeting
Speaker: Adam Jorgensen
Topic: Zero to cube in 60 Minutes
Date and Time: 1/22/2010 12:00 PM EST
Meeting URL: Join Meeting
Description:...
2010-01-21
680 reads
Speaking at SQL Saturday Tampa and Richmond
Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...
2010-01-21
575 reads
Scripting Indexes
I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.In the posting the author explained...
2010-01-15
1,457 reads
SSRS Data Driven Subscriptions Cryptic Job Names
When you create and schedule a Data Driven Subscription for a SQL Server Reporting Services (SSRS) report a job is...
2010-01-14
828 reads
MVPs on the SQL Lunch
On January 19th and February 25th the SQL Lunch will have two well known authors, speakers and MVPs presenting at...
2010-01-14
614 reads
SQL Lunch #8 – SSRS Data Driven Subscriptions (Devin Knight)
Join Devin Knight for a SQL Lunch at 12:30 EST today to hear about using the SSRS Data Driven Subscriptions!...
2010-01-12
809 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