Month: May 2017

Uncategorized

CosmosDB: The New DocumentDB NoSQL Database in Microsoft Azure

Build5Nines

DocumentDB has been around for awhile now in Microsoft Azure. It’s a Document based, NoSQL database in the cloud. There’s been tons of advancements to the service over time, including MongoDB API support so you can use it in place of MongoDB for existing code bases. It’s always been called “DocumentDB” since initial release of the service, but for a time it was labeled as “NoSQL (DocumentDB)” in the Azure Portal. It seems there was some indication that Microsoft wasn’t happy with the name they first chose.

Today, we wake up in the morning to updates that have been made to the Azure Portal where DocumentDB is no longer there. Well, it actually is there, but has undergone renaming / rebranding. From this day forward, DocumentDB will no longer be called DocumentDB. Instead we will call this NoSQL, Document based database service….. Azure Cosmos DB.

From this day forward, DocumentDB…

View original post 388 more words

Azure

Tips to managing your Azure subscription

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:

image

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:

image

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.

image

After the subscription has successfully been renamed, you’ll receive an alert:

image

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:

image

From the Invoices blade, you can now click on the Invoices button and then from here you can opt-in and configure it:

image

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:

image

Enjoy!

Resources

Azure Portal

DatabaseDevelopment

SQL Server Management Studio 17.0

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:

sshot-280

Updated splash screen:

image

SSMS 17 icons have been updated to be consistent with VS Shell provided icons and support High DPI resolutions:

sshot-284

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.

Enjoy!

References

Download SSMS
Download SQL Server Data Tools (SSDT)
SSMS Changelog
SSMS Release Notes