TSQL Challenge #14
A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12
2009-10-01
3,616 reads
Press Release
Free Training in October - SQL Saturdays Around the US
There are a number of SQL Saturday events around the country in October: Redmond, Gainesville, Orlando, Louisville, and Cedar Rapids. Read more about these events.
2009-09-24
1,903 reads
Grow Your Network - Come to the PASS Summit!
The 2009 PASS Summit is Nov 2-5, 2009 in Seattle. Come and grow your network, while learning about SQL Server.
2009-09-17 (first published: 2009-05-12)
724 reads
T-SQL Challenge #13
Take T-SQL Challenge #13, Break a batch of invoices into multiple parts based on rules.
2009-09-15
4,471 reads
Less Than a Week - PASS 2009 Summit
A last push for the 2009 PASS Summit before registration goes up.
2009-09-10
12 reads
SQL Bits
The next SQLBits conference is being held Nov 19-21, 2009 in Newport, UK. If you want to attend or even speak, read more about this event.
2009-08-27
1,542 reads
SQL Lunch with the Baton Rouge Area SQL Users Group
It's on Livemeeting and open to everyone. Get some lunch time training in with this group.
2009-08-25
391 reads
The 2009 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2009 PASS Summit. Read more about this and learn how to get a ticket.
2009-08-19
91 reads
TSQL Challenge #12 - Build sequential ranges of dates with propagation to missing values
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
2009-08-18
4,515 reads
Curacao SQL Server User Group
A new PASS chapter is now on the island of Curacao. Roy Ernest, longtime SQLServerCentral contributor, runs it. Come support this chapter in the Caribbean.
2009-07-28
369 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