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)
403 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
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...
Cyber Scams and Operation Shamrock
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
The Book of Redgate: Ingeniously Simple
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Forums
BULK INSERT messing up import of CSV file with a comma in it
Hi everyone I am using BULK INSERT to load a CSV. I have noticed...
Users Default Schema in a stored procedure.
One of our systems contains data for multiple organizations. OrgA should not be able...
Calculating Difference between Multiple Dates for a Given Condition in HH:MM:SS
We have the following requirement:- Event_Time ...
Question of the Day
Updating a Data API Builder Connection String
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers