All About SQL

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

12 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: )

233 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

142 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Volunteer For Something

By Grant Fritchey

Comments posted to this topic are about the item Volunteer For Something

Linked Server location?

By pkarandi

I have inherited a SQL Server that makes a call to a Linked Server...

Merge issue

By DaveBriCam

I have a merge stored procedure that may be conflicting with the structure of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers