Spring Connections and Learning at PASS On Tour
The spring PASS On Tour event is coming to Chicago in a few weeks.
2026-04-27
71 reads
career networking
Your Value from a Conference
Today Steve asks what value you get from attending conferences or other events.
2025-12-19
48 reads
Building Bonds with Entertainment
Over the years I've had the chance to work in a lot of companies, and I've seen a lot of different team-building attempts take place. In restaurants, these were often nights out with too many adult beverages. At a power station, we had some large outdoor BBQs, where again, sometimes there were too many adult […]
2023-10-04
113 reads
2022-06-17
122 reads
Finding New Employment
You can find new employment with a little work and choose the best job for you.
2022-05-07
138 reads
Getting Started Remotely
Today Steve wonders what advice you might give someone starting out their career in technology.
2021-05-07
104 reads
It's More Than What You Know
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
2019-12-03
1,958 reads
2019-07-22
773 reads
Ports that DBAs Need to Know
This article lists the essential TCP/UDP ports that an administrator running SQL Server or a cluster should know.
2011-10-28
23,381 reads
Find which port SQL Server is using to establish connections
This article will show you how to determine which network port that SQL Server is listening on for connections
2011-09-08
10,572 reads
Blogs
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers