(SQL) Tip of the Day: Premium Databases and the Alter Database Command

  • Article

Today’s (SQL) Tip…

Did you know that while the feature is in Preview, or Beta, the “ALTER DATABASE” command article does not list “Premium” as a valid edition for the Modify Edition field?

https://msdn.microsoft.com/en-us/library/windowsazure/ff394109.aspx

If your customers have a premium reservation quota, they can actually use a query through the portal or even through a tool such as Management Studio to upgrade their existing database to Premium edition.

ALTER DATABASE <name> MODIFY (EDITION=’Premium’)

As the Premium Database features approach GA, further updates to this command may be made to allow tier sizing to be specified.