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


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?

http://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.


Comments (0)

Skip to main content