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..
Great post! Thanks for sharing this amazing post on Web Design & Development, keep blogging. Business Intelligence Consulting Services
ReplyDelete