David, how about just having your powershell script round the freespace to the nearest 10 (or whatever you want as a reasonable switching threshold)?

For example if there were two servers...

The MERGE command is helpful:

"Runs insert, update, or delete operations on a target table from the results of a join with a source table. For example, synchronize two tables by...

If I understand your question, one solution could be to generate a date/calendar table with a column to return the English Quarter for a given date. Then just Join to...

• This reply was modified 4 years, 5 months ago by  kcecil 47772.

1.)  You can have heap tables in SQL Azure.

2) You can do SELECT @@VERSION to see that it is not quite the same as what you get with on-premise servers.

Perhaps try removing/deleting all the schedules and re-adding them back to the jobs to see if this clears up.

For quick and dirty monitoring when you can't afford something else you can just follow the advice to:

1. Define your measurements and queries to get the value.
2. Create a generic...

Some of the obvious things are.

1. Did the SQL services restart and are running (if not, review error logs)
2. Run SELECT @@VERSION to confirm the build id is updated to...