The following are a few tips for managing your Azure subscription. Start by navigating to the Subscription blade and then click on a Subscription you wish to manage:
From here you have a clear overview of your Subscription ID and the current spending with a breakdown by resource.
Renaming your subscription
To rename your Subscription, in my case I want to change it from “BizSpark-$70” to “MSDN-Professional-$70” as that is a new MSDN subscription I purchased and changing the name properly reflects that subscription and the Azure credits associated with it.
To rename the Subscription, click on the Subscription name:
You can now enter in a new Subscription name and when you’re done click on the Save button. The subscription name change can take up to 10 minutes to be reflected on the Azure portal.
After the subscription has successfully been renamed, you’ll receive an alert:
Configuring email invoices
The Azure portal recently allowed you to opt in and configure email invoices. This means instead of receiving an email each month that your invoice is ready which required you to login to the Azure portal, now you can have the invoice emailed to you instead, which is awesome!
If you haven’t already setup email invoices, from the Azure Subscription blade, click on Invoices:
From the Invoices blade, you can now click on the Invoices button and then from here you can opt-in and configure it:
If you already opted in, you can review your current configuration and also configure the list of recipients (maybe you want the invoice sent to your accounting department also). When done, click the Done button at the bottom:
There is a new release of SQL Server Management Studio (SSMS) now available – version 17.0. It feels like yesterday when SSMS 16 was released (June 2016). I’m not going to complain as it’s refreshing to see such the constant updates to SSMS now that it’s not tied in with the database engine installer.
To get the latest version, head to the download page and install the web-installer. SSMS 17 will install side-by side with previous versions of SSMS.
This latest release includes a lot of new functionality, namely with support for connecting to SQL Server on Linux. Please see the full SSMS changelog for a complete listing of enhancements and bug fixes. Sadly this release still doesn’t support the Dark theme. Hopefully this is something they add in a future release.
Installing SSMS 17:
Updated splash screen:
SSMS 17 icons have been updated to be consistent with VS Shell provided icons and support High DPI resolutions:
One of the nice additions to this release is the inclusion of “Presentation Mode”. There are 3 new tasks available via the Quick Launch (Ctr-Q):
- PresentOn – Turns on presentation mode where the editor and environment fonts are larger
- PresentEdit – Allows you to edit the presentation font sizes
- RestoreDefaultFonts – Reverts back to the default settings
If you are familiar with these commands in Visual Studio then you will notice that there is currently no PresentOff command. Use RestoreDefaultFonts to turn off Presentation Mode.
Download SQL Server Data Tools (SSDT)
SSMS Release Notes