Fix identities after migrating through SQL Replica

One of the most common migration procedures to SQL Azure is by configuring replication from your previous environment to your brand new SQL DB: https://msdn.microsoft.com/en-US/library/mt589530.aspx   This is a very nice migration process, as it allows original database to be available in Production until very few moments before SQL Database goes live. However, if your…


Lesson Learned #10: Monitoring TempDB usage

We are receiving several support cases when our customers are getting the following error message “The database ‘TEMPDB’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.” and their query ends with an exception. As any SQL Server instance every Azure SQL Database Tier has a…


Azure Support Academy (Spanish): SQL Server, Next Station Azure

Welcome to our session delivered in 24Hours Pass Virtual Chapter – Global Spanish, covering the main aspects to start or migrate from an OnPremise model  to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment  for our requirements. Watch:  SQL Server, Next Station Azure We covered: Red…


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 #2: Do you need SQL Server Agent for Azure SQL DB?

Many questions came to us, about SQL Server Agent for Azure SQL DB. Unfortunately, we don’t have the SQL Agent service in the same way that you have in OnPremise, but we have a multiple solutions for it: If you are able to maintain the SQL Agent, you could create a linked server against to…


How to maintain Azure SQL Indexes and Statistics

There are a lot of work that Azure SQL saves from you, and most of the users we meet seems to believe that maintain the database indexes and statistics is one the missions you can forget when you migrate to Azure SQL. Statistics objects, like in the box version of SQL have by default “Auto update”…