New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check...
2017-04-09
531 reads
Anthony Nocentino Blog
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2017-04-09
6 reads
Speaking at PowerShell Summit!
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit...
2017-03-22
326 reads
Speaking at PowerShell Summit!
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April...
2017-03-22
2 reads
Using dbatools for automated restore and CHECKDB
OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a...
2017-03-22 (first published: 2017-03-04)
4,071 reads
Using dbatools for automated restore and CHECKDB
OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a rock. I strongly encourage you to check it out...
2017-03-04
3 reads
TugaIT – Pre-conference workshop on PowerShell on Linux
Where – Thursday, May 18, 2017
Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your...
2017-02-08
455 reads
TugaIT – Pre-conference workshop on PowerShell on Linux
Where – Thursday, May 18, 2017 Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your Heterogenous Data Center“ ...
2017-02-08
4 reads
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow,...
2017-02-08
310 reads
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow, 600 SQLSaturdays! This one won’t let you down....
2017-02-08
5 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