Skip to main content

How to Resume Azure SQL Serverless Database Manually?

Problem

It was a horrible experience with a busy day. Suddenly the Developer Database, presumably Azure SQL Serverless Database went off. In another word, it was in Auto-pause mode.  When I search through the internet, I couldn't find any reliable method of turn it back to accessible or resume mode. According to the documentation, If I login to the database then it should be turned it back, but it is not the case. I tried with both Management Studio and Azure Data Studio those options were not in my favor.



Solution

Unfortunately, the solution is pending. Unless you have to trigger manually by doing one of the tasks was in the list I've referenced above. I found that this feature is started to develop, according to the Microsoft Azure forum. But, that is not helpful to get sorted my issue today.

Workaround 

Maybe if you are an Application developer you might not get this issue. Perhaps if you invoke some function which hit to the database, this problem will get sort much faster. But, I'm a BI consultant who are working on application development less frequently. So, I tried to connect to the database via Microsoft Power BI desktop, which you can download for free. Which is the best use case scenario when it comes to Business Intelligence. Surprisingly it worked perfectly. The Azure SQL Serverless database turned back to Online. This is not a solution, at least a workaround till they bring this feature to Live..


Labels:

Comments

  1. Kermit WallerOctober 18, 2020 at 12:53 PM

    Great post! Thanks for sharing this amazing post on Web Design & Development, keep blogging. Business Intelligence Consulting Services

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Visualize Images Dynamically using Microsoft Power BI

One of the challenging part of the Power BI report development is handling dynamic images. We can add a static image within few steps and it is pretty straightforward. But, when it comes to dynamic images, available options are countable. Available options: Upload to the Web : You can upload the images to the web and use the image URLs as a reference. But, you need to make sure the data category  of your column where to store the image URL make it as  I mage URL. When we are dealing with clients data we cannot upload it to the public web. So, need to be accountable for data we are dealing with. Azure Blob Storage : If the security is the concern, you can use Azure blog storage to store image files. Only accessible who are in the same domain or security group. You have the full control over managing the authorization. I have an experience of, there are clients they never want to upload any data to the cloud. And if we are dealing with multiple clie...
49 comments
Read more

Run T-SQL Script Files Using Command Line

Most of the time when we need to execute a SQL script or statement, then we go for SQL Server Management Studio to execute our T-SQL scripts. But the same result we can achieve using Command Prompt. This is very simple way to do that just a matter of write a command and pass few arguments. You can see the process status like as in when you execute a query in Management studio. Use-case : There may be having some situations you won't be able to execute T-SQL script using Management Studio. Most of the time when doing data population. In my case, I had a situation I needed to populate a Database without using backup/restore. Once I generated script with all the schemas and related data it took around 400+Mb sql file.  SQL Server Management Studio will not allow you to run the script unless you execute the query in high-end box. Because, when the file loaded to the memory it will too hard to cater our requirement. You may probably get  memory ...
Post a Comment
Read more

Jump Start with Azure Databricks - Chapter 1

Azure Databricks is the latest and greatest way of processing Big Data in Azure cloud. It is an apache spark based analytics platform allow users to setup spark clusters with few clicks, streamlined workflows, collaborate with data engineers and data scientists. I’ve started to write a set of short articles to demonstrate step-by-step how to engage with Azure Databricks. As the first step, you will find how to get into Azure Databricks. Article 1: How to Create Azure Databricks Workspace How to Create a Azure Databrick Workspace Summary This is the first one of article series: Jump Start with Azure Databricks. In this context, I try to cover high-level aspects of how to getting started and play around with the databricks on Azure.  Please, leave a comment below your feedback, which will greatly help to improve my future work. 
33 comments
Read more