Cláudio Tereso

I'm from the Spectrum generation. I started copying programs from books so I could play them when I wasn't even 10 years old. From there, programming my own programs was a leap. As a teenager I did programming work for university students and when I started working it was in programming.

My interests changed and I entered the area of databases, SQL programming and network administration, areas in which I obtained several Microsoft certifications. Along the way I also published the books, by the Portuguese Editor FCA, "Local Networks in Windows 98 & 95 - Complete Course" and the corresponding update for the hated Windows Me.

I now work with SQL Server, Power BI, Azure and related Microsoft technology. I'm also having some fun with Python.
  • Interests: orienteering and all things mountain :)

Blogs

Fabric Mirroring doesn’t start copying Rows

By

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

By

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

By

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Read the latest Blogs

Forums

Breaking SQL Server for disaster recovery practice

By chapwolff

Hey all. I understand if this gets taken down due to the subject matter...

Creating a JSON Document I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document I

Who is Irresponsible?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who is Irresponsible?

Visit the forum

Question of the Day

Creating a JSON Document I

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933
If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers