Azure Container Instance and SQL server
Being heavily involved with Microsoft Azure and database technologies it was only a matter of time that I would enter the world of Azure Container Instances (ACI). The same...
2021-07-05
35 reads
All About SQL
Azure SQL Managed Instance Versions
Just a really quick FYI for the readers. If you are using Managed Instances in Azure (If not, why not?) and you connect vis SSMS (SQL Server Management Studio)...
2021-06-23
328 reads
Azure SQL Database – Secondary Database and Tiers
On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe....
2021-06-11
95 reads
Azure SQL Database – Cancel Scale Up Request
You have an Azure SQL Database, it could be a single database, it could be a primary database within a failover group. Regardless of the context, what would you...
2021-06-07
76 reads
Azure SQL Database Restore to different server
It is quite a common requirement to restore a copy of a database to the same Azure SQL server, you just issue a COPY OF command. What if you...
2021-06-03
327 reads
Snowflake in Azure
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that is Azure SQL Database or Azure Database for MySQL for your relational database, it does not matter...
2021-04-12
18 reads
Error creating Azure SQL Database
A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”, “message”: “Operation on server x and database y is in progress. Please wait a few minutes before trying again.” What is going on here? Well for this example (and maybe yours) I created a database...
2021-04-16 (first published: 2021-04-09)
405 reads
Azure SQL – Saving Costs
When moving to a cloud model for your database stack no doubt you will be involved in a costing exercise. The good news is if you have Software Assurance...
2021-04-01
20 reads
SQL server BIGINT
It has been a while since I wrote a blog post for TSQL Tuesday and there is no better time then now following on from Brent Ozar’s Invite about...
2021-03-09
155 reads
Azure SQL Database – Contained user Model
I always follow a contained user model when setting up users within my Azure SQL Database. I do this so the user in question has access to only specific...
2021-03-12 (first published: 2021-03-09)
333 reads
Blogs
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
Forums
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Using Heaps
Comments posted to this topic are about the item Using Heaps
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers