A Server Bench
This past weekend I was doing some early Spring cleaning and decided it was time to throw out two old...
2014-01-15
631 reads
SQLAndy
Should You Run For the PASS Board? How Do You Decide?
Here are some of the questions I ask when someone is thinking about running for the Board:
Are you eligible? Read...
2014-01-15
544 reads
Google Buys Nest
I was a bit sad to see that Google bought Nest. I like upstarts that see a problem and solve...
2014-01-14
629 reads
Time to Plan For Running For The PASS Board
I know it’s only January, but if you’re at all considering being a candidate you need to get going now....
2014-01-14
434 reads
Security, Compliance, and SQL Server Webinar on January 29, 2014
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
979 reads
Bradley Ball at MagicPASS on January 15, 2014
First meeting of the year with Bradley Ball presenting Locking, Blocking, Latches, Deadlocks, and Spinlocks. Let them know you’ll be...
2014-01-13
663 reads
The SQLSaturday Wiki–Revisited
I saw a discussion on Twitter yesterday where Kendal Van Dyke referenced the SQLSaturday wiki as a resource, I thought...
2014-01-10
385 reads
Schedule Time To Review Your Passwords & Using a Password Manager
I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account...
2014-01-17 (first published: 2014-01-10)
1,807 reads
How To Campaign For the PASS Board
Let’s say you’ve decided to run, good! What do you do next? I’m not going to give you a blueprint...
2014-01-10
391 reads
Two-Factor Authentication
Something you have and something you know – that’s the heart of two-factor, sometimes called multi-factor, authentication. RSA was for years...
2014-01-15 (first published: 2014-01-09)
6,352 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