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-09
42 reads
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
9 reads
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
133 reads
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)
315 reads
Taking a screen shot from my Azure Portal, you will see the available hardware configurations available for Azure SQL Database. I wrote about Generation 4 and 5 in the...
2021-02-18
17 reads
For the past year Microsoft have said that Generation 4 hardware is soon coming to its end of life. I know many installations that have used Generation 4 over...
2021-02-16
475 reads
When you have the need to find out real time what is causing high CPU issues within your Azure SQL Database, there is nothing better than using TSQL and...
2021-02-10
196 reads
There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server. As...
2021-02-02
83 reads
Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common requirement will be the need to connect to it to issue queries, typically via SQLCMD)....
2021-01-25
25 reads
If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision to make. That being should...
2021-01-19
164 reads
By Steve Jones
I started a poll today on the naming for future SQL Saturdays. You can...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Arun Sirpal
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...
Comments posted to this topic are about the item Easing Back to the Office
Comments posted to this topic are about the item Password Policy
Ask SSC