lbravo

I have spent all my life creating applications, writing software and automating processes. My entire career has been an exciting journey that I'm very proud of. I had the privilege of creating one of the first websites in the world, built an application that was used to estimate traffic volumes in large cities such as Rome and Sao Paulo, created an accounting system, received a national award for my IT contributions.

Collaborating closely with exceptional talents from across the globe, I proudly hold the distinction of being a Microsoft charter member. My credentials encompass Microsoft certifications in SQL Server, database development, and Azure. Currently, I am diligently pursuing an Artificial Intelligence certification from Microsoft.

I have also embarked on a journey of knowledge sharing, with the publication of my inaugural technical articles, with more in the pipeline.
Outside the domain of computers, I enjoy cooking, going to the beach, jogging, writing, teaching and contributing as much as I can to make this world a better place for us all. If I don't feel passionate about something, I just don't do it.

Technical Article

Simple T-SQL implementation for running SSRS subscriptions.

I created this stored procedure to be able to run SSRS subscriptions using T-SQL code instead of adding a component in the SSIS package with the subscription id. Let's say we have a set of report subscriptions named like this: ClientReport1, ClientReport2, ClientReport3. To run them using the stored procedure, all we need is this […]

(1)

You rated this post out of 5. Change rating

2023-11-29 (first published: )

1,340 reads

Blogs

Data Engineering Books Worth Having on Your Shelf (or your tablet)

By

Good documentation gets you started. Good books get you deep. After years of working...

SSMS Evaluation – future ready

By

In previous posts, we looked at the SQL Server engine. for us DBAs, the...

Claude.ai vs Claude API

By

You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...

Read the latest Blogs

Forums

Creating a JSON Document IV

By Steve Jones - SSC Editor

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

Permissions Removal When Changing Object Schema

By Brandie Tarvin

When the schema of an object is changed, SQL Server wipes out the previous...

Visit the forum

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      1960
If I run this code, how many rows are returned?
SELECT 
  YearEstablished,
  json_objectagg(city : TeamName)
FROM dbo.NFLTeams
GROUP BY  YearEstablished;

See possible answers