Getting Started with Azure CLI to Manage Azure Resources
Learn about Azure CLI and how to manage your Azure resources using commands instead of using the Azure portal.
2024-07-31
Azure
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).
2024-02-02
2,065 reads
Sending resource alerts on Managed Instance using db_mail
One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don't have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In this post, you will see how you can monitor resource usage and send email alerts if there is a risk that you might reach the limits.
2023-12-20
Identify log write limits on Azure SQL Managed Instance using QPI library
Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify write log throughput issue on Managed Instance.
2023-12-11
Backup and Restore SQL Database to Azure Blob Storage
SQL databases are crucial for businesses, so it's critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let's examine the advantages, the steps involved in backing up to and restoring from a device, recommended practices, and more.
2023-09-15
7,883 reads
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,200 reads
Azure Machine Learning Introduction: Part 1 Overview and prep work
The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data Science with Azure Machine Learning (Azure ML). Readers don’t need prior knowledge of Data Science, Machine Learning, Statistics, or Azure to begin this adventure.
2023-04-26
How to Install the AdventureWorks Sample Database in Azure SQL Database
Learn how to configure Azure SQL Database and setup the AdventureWorks database for code testing and learn how to use features of SQL Server.
2023-03-13
The Azure Carrot
There is a promotion for SQL Server 2012 customers that might be considering the cloud and worried about support.
2022-07-27
123 reads
Advanced Databricks Lakehouse Capabilities
Learn about several different aspects of Databricks Lakehouse such as encryption, row level security, visually viewing query plans, SQL merge, change data capture and more.
2022-06-03
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...