Come Shake My Hand at PASS
Last year Andy Warren thought about trying to help first timer attendees at the PASS Summit with a little networking...
2011-08-24
1,741 reads
Blog Posts
Correctness and stress test
Stress test SQL Server for new hardware
Download SQLIOSim from http://download.microsoft.com and install on server.
When detailing the file location , use the...
2011-08-24
715 reads
Interview with BI Expert Tim Mitchell
Tim Mitchell will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-24
794 reads
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course...
2011-08-24
702 reads
Microsoft Small Basic
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,061 reads
PASS Update #62
Our most recent Board meeting was Aug 11 & 12 in Ft Lauderdale (located so we could attend SQLSaturday on Saturday)....
2011-08-24
606 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else. In SQL, we should be well aware of Precision...
2011-08-24
7 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else....
2011-08-24
2,884 reads
2011-08-24
6 reads
2011-08-24
6 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
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...
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