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
102 reads
All About SQL
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
88 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
338 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
23 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)
414 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
32 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
158 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)
341 reads
Azure SQL Database F and M series
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
54 reads
Azure SQL Database Gen4 to Gen 5
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
953 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers