SQLSaturday #41 Announced
Stuart Ainsworth will be coordinating the second SQLSaturday in Atlanta, this time on April 24th, 2010. Registration and call for...
2010-01-29
1,879 reads
Blog Posts
Are You Running the x86 Version of SQL Server 2005/2008?
If so why? Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008,...
2010-01-28
2,900 reads
IN and NOT IN
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-01-28
1,228 reads
SQL Saturday Richmond - Postponed
If you’re anywhere from the southwest to the deep south, you’re probably aware of the impending winter weather bearing down...
2010-01-28
1,397 reads
SQL Search 1.0 Beta Available
Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you...
2010-01-28
1,414 reads
SQL Source Control Early Access Program Open
Managing T-SQL source code has never been easy, and has often been the bane for many T-SQL developers. Later this...
2010-01-28
579 reads
SQLSaturday #39 Announced
SQLSaturday #39 will be held April 24, 2010 and is being coordinated by Melissa Demsak and others from the NJ...
2010-01-28
581 reads
SQLSaturday #40 Announced
SQLSaturday #40 will be held July 31st, 2010 in Miramar, FL. This is the second annual SQLSaturday organized by Scott...
2010-01-28
607 reads
The Black Art of PowerShell V2 Version Numbers
Last week while helping someone in the SQLPSX forums having an issue importing modules I suspected they had a CTP...
2010-01-28
823 reads
The Little Stick
In the end, that was what made the difference. I was typing along one night on my spare Acer and...
2010-01-28
868 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
CDM Bank BCA 9422 Grand Indonesia HUB/WA (08216977701)
Gedung Menara BCA Grand Indonesia, Jl. M.H. Thamrin No.1, RT.4/RW.1, Kebon Melati, Tanah Abang,...
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...
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