Virtual SQLRun for PASS Summit 2020
Just because we aren’t all together in Houston doesn’t mean we can’t have a #SQLRun at this year’s Summit. It might even be easier for some folks as there’s...
2020-07-02
9 reads
Blog Posts
VM firmware matters for Windows Secure Boot
The Register is reporting that future versions of Windows Server OS is going to require the TPM 2.0 chip and Secure boot enabled by default. Secure boot is quite...
2020-07-02 (first published: 2020-06-23)
196 reads
Canada Day 2020
It’s Canada Day here, the commemoration of the country’s confederation in 1867. Given events over the last few months such as the worldwide pandemic, followed by a number of...
2020-07-01
11 reads
Daily Coping 1 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-01
11 reads
Delete a 2020 GitHub Repository–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I have a lot of GitHub repos, sometimes...
2020-07-01
24 reads
MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just...
2020-07-01
6 reads
MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just...
2020-07-01
28 reads
MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just...
2020-07-01
6 reads
MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just...
2020-07-01
3 reads
MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just...
2020-07-01
10 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