Lesson Learned #8: Monitoring the geo-replicated databases.

We received multiple requests in order to have answered the following questions: Is there needed a maintenance plan for geo-replicated databases? How to monitor the geo-replicated databases Answering the question: “Is it needed a maintenance plan for geo-replicated databases?”, No, there is not needed because is you have a maintenance plan for rebuilding indexes and update statistics…


Lesson Learned #7: Monitoring the transaction log space of my database

In many support cases, our customers want to monitor the available space for the transaction log space for their database or to know what caused an error when the transaction is full. Unfortunately, there is not supported to use DBCC SQLPERF(LOGSPACE) nowdays. For this reason, I would like to share with you another view where you could find out…


No Azure SQL V2 (or as called sometimes V11) anymore

I just want to share quick update that Azure SQL DB V2 cannot be created anymore After long time V2 database is deprecated, this version cannot be created anymore The option is still there on the portal, but as the message states this is not permitted anymore. Hare is a screenshot that shows that: But…


Create SQL Login and SQL User on your Azure SQL DB

There are multiple options to authenticate with your Azure SQL, in this post I want to discuss only SQL Authentication option That’s true that we recommend to use Azure Active directory for authentication but yet this is very common to use SQL Authentication with databases. There are two main options to setup this type of…