oPASS Meeting Tonight, July 13, 2010
Our regular monthly meeting is tonight featuring David Pless from Microsoft. Here are some notes about his presentation:
This discussion will...
2010-07-13
230 reads
SQLAndy
Access Annoyance – Bit Columns
Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe...
2010-07-13
332 reads
Old McDonalds and The Cow Store
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
509 reads
SQLSaturday #49 Pre-Con Announced
We’re pleased to announce that Louis Davidson will be our pre-con speaker this year at SQLSaturday #49 in Orlando. Louis...
2010-07-09
220 reads
PASS Update #36
We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth....
2010-07-09
1,153 reads
PASS Summit 2010 Sessions Accepted
Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building...
2010-07-09
412 reads
Why Would They Coach Me?
During a recent call I was talking with someone about achieving a career goal (coaching in itself, though unplanned) and...
2010-07-08
765 reads
Life Lesson: Pay Your Dues
This is one of the lessons you don’t want to hear when you’re 18, or the newest member of a...
2010-07-07
293 reads
SSC Editorial – Learning From Experts
Another story with a lesson today, this one about learning to work smarter and not just harder. Easy to say,...
2010-07-07
256 reads
MS Access Annoyance: Yes, Save the Password, Again
Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables,...
2010-07-06
304 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...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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