Elastic Database Jobs: Sample for Running T-SQL Code in Multiple Databases

Introduction: After moving from on-premise SQL Server to Azure SQL Database, the SQL Server Agent service is no longer available to you. Administrators are therefore missing the ability to run recurring jobs, in order to execute T-SQL scripts and Stored Procedures on a schedule. Elastic Database Jobs are one way of implementing a scheduled execution on…


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…


Azure SQL DB MAXSIZE – what can I do with that?

Information:  Azure SQL DB max size is limited by the pricing tier for each DB. for instance Basic is limited by 2GB, Standard by 250GB, and Premium by 500GB per database. you can also set your own limit while it’s lower or equal to the level max size and if this is in the list…


Azure SQL DW – column name is case sensitive with hash distribution

Symptoms:  When using PolyBase bulk operation to load data into Azure SQL DW (Data Warehouse)  and using the HASH distribution you may receive this error message: [OLE DB Destination [471]]: The source and target columns must be in the same order in the INSERT BULK statement An OLE DB record is available.  Source: “Microsoft SQL…


Does Azure SQL DB support automatic indexed views?

Are indexed views used automatically in SQL Azure without “WITH (NOEXPAND)”?How does it work?and How the query optimizer decides to use it or not ? The query optimizer uses indexed views to speed up the query execution. Which means SQL Server’s query optimizer realizes the precomputed sums of all the Quantity values for each value are…


Unexpected Select queries seen in the Performance Overview of the Azure Portal

Scenario: During a time of low database activity, you may see an unexpected spike of DTU consumption in the performance graphs on the Azure Portal. Drilling into it through the Performance Overview and Query Performance Insight feature, you identify some queries which you do not recognize. The overall DTU consumption for them is rather low…