---

Filter by type:

• All
• Articles
• Blog Posts

Snowflake in Azure

• by Arun Sirpal

• All About SQL

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

6 reads

Error creating Azure SQL Database

• by Arun Sirpal

• All About SQL

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

65 reads

Azure SQL – Saving Costs

• by Arun Sirpal

• All About SQL

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

Azure SQL Database – Contained user Model

• by Arun Sirpal

• All About SQL

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

SQL server BIGINT

• by Arun Sirpal

• All About SQL

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

Azure SQL Database F and M series

• by Arun Sirpal

• All About SQL

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

Azure SQL Database Gen4 to Gen 5

• by Arun Sirpal

• All About SQL

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

478 reads

Azure SQL DB – Troubleshooting CPU issues

• by Arun Sirpal

• All About SQL

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

197 reads

Azure SQL Database and Long-Term Backups

• by Arun Sirpal

• All About SQL

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

SQL server Linux and SQLCMD

• by Arun Sirpal

• All About SQL

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

Filter by type:

• All
• Articles
• Blog Posts