Building a PASS Voting Solution – Part 5
Today we move over to the web side of things. I put this together with VS 2010, and it’s a...
2010-06-23
578 reads
SQLAndy
Building a PASS Voting Solution – Part 4
We’re almost at the end of the SQL side of things, just needing to send out notifications/reminders. I was torn...
2010-06-22
540 reads
PASS RSS Feeds
Another “didn’t know” for me, we have multiple feeds from PASS HQ that focus on various areas – grab the entire...
2010-06-21
666 reads
PASS 2010 Election Nominating Committee Announced
Actually came out last week and I missed it, here is the link to the details of the nominating committee...
2010-06-21
650 reads
SQLSaturday Schedule Changes
As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches...
2010-06-21
486 reads
PASS Update #34 (The “Spring Event”!)
The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed...
2010-06-18
670 reads
Building a PASS Voting Solution – Part 2
Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should...
2010-06-18
748 reads
Notes from the June 2010 oPASS Meeting
We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may...
2010-06-17
543 reads
PASS Update #33
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
703 reads
Building a PASS Voting Solution – Part 1
Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst...
2010-06-17
516 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