I recently started full time learning of Amazon Web Services (AWS). I found that AWS's Relational Database Service
(RDS) is really user-friendly. RDS simplifies many of the
complicated aspects of...
2024-05-06 (first published: 2024-04-20)
395 reads
In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.In Part 3, we deployed our fist solution (Azure...
2023-12-28 (first published: 2023-12-27)
42 reads
Continuing our Part 1, we already set up our environment, we can now setup our very first example (do not worry if is too simple at this point, but...
2023-09-20 (first published: 2023-08-23)
191 reads
In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.On this post we will create an Azure SQL...
2023-09-20 (first published: 2023-08-28)
229 reads
IntroductionOne integral part of modern Continuous Integration and Continuous Development (CI/CD) pipelines is the ability to create the underlying infrastructure as part of the pipeline in a consistent and...
2023-09-11 (first published: 2023-08-22)
309 reads
Python is the most famous development language today.
This is because is open-source, scalable and robust. It can run in almost any device with a processor (or microprocessor, we will...
2021-01-21 (first published: 2021-01-14)
872 reads
If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...
2020-07-20
3,911 reads
If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...
2020-07-20
89 reads
Nowadays, data is a precious asset for companies today. If you are a database administrator (by decision or by mistake) or simply you are the "IT guy," you have...
2020-04-08 (first published: 2020-03-30)
431 reads
Nowadays, data is a precious asset for companies today. If you are a database administrator (by decision or by mistake) or simply you are the "IT guy," you have...
2020-03-30
20 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers