Creating an Azure SQL Database Using Azure Cloud Shell
This article will show how to use the Azure Cloud Shell and PowerShell to set up a new Azure SQL Database.
2023-07-07
1,294 reads
cloud computing
Data Oriented Cloud Security Mechanisms
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
2023-04-14
1,406 reads
10 Considerations for a Database Migration to AWS RDS
This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.
2022-10-26
3,600 reads
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
2,388 reads
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,756 reads
Why cloud and hybrid estates are important - but bring complexity
With 92% of organizations now reported to be multi-cloud, a well thought-out approach to cloud migration is imperative. Download our final insights report in this series on database monitoring to find out how 2500+ of your peers are dealing with the challenge.
2021-12-20
Performance of querying blob storage with SQL
It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.
2021-11-12
The Azure SQL portfolio
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.
2021-09-20
How to query private blob storage with SQL and Azure Synapse
Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.
2021-08-13
How to query blob storage with SQL using Azure Synapse
How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.
2021-07-28
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers