Check Pause/Resume status of DataWarehouse using T-SQL
It is great that I can check the scaled performance level of my data warehouses using a T-SQL query from the Microsoft SQL Azure master datebase:
SELECT db.name, ds.edition, ds.serviceobjective, db.statedesc
FROM sys.databaseserviceobjectives ds
JOIN sys.databases db ON ds.databaseid = db.databaseid
WHERE ds.edition = 'DataWarehouse'
Please make it possible to check the true state of the data warehouse as well. This query always reports the data warehouse to be 'Online' even when it is really in a 'Paused' state.
P.S. For the life of me, I can't understand why this functionality isn't already built in? Why force a user to use an API or PowerShell applet to check the state of a data warehouse when they are already connected to their SQL Azure instance via Microsoft SQL Server Management Studio?