Introducing the Azure SQL Data Warehouse DWU Calculator

Over a year ago my colleague at Microsoft, Justin Henricksen, introduce the Azure SQL Database DTU Calculator this tool is designed to examine your existing workload and estimate the service tier required to fulfill the workload when migrated to Azure SQL Database.  I discussed this effort with Justin, and we decided it would be a great…

0

Sending events to IOT Hub over HTTP via REST

As you may know Azure IOT Hub is a scalable transport for communicating with Internet of Things devices. While conceptually what it does is quite similar to Event Hubs it actually supports several more scenarios including bi-directional communication and device specific authentication. Furthermore it supports standard IOT protocols including AMQP and MQTT out of the…

0

Long Term Backup with Azure SQL Database

In a previous blog “Extended Backup Retention With Azure SQL Database“, I outlined a method for extending the boundaries of the Azure SQL Database service. To refresh your memory the defaults here are 7 days for the Basic tier and 35 days for the Standard and Premium tier of Azure SQL Databases. While the method…

0

Automating database migration to SQL Azure

Migrating databases to a new environment can be a tedious but necessary task.  For years DBAs have been dealing with the process of rolling out SQL Server upgrades, and have achieved this in On Premises environments in a variety of ways including: 1.       Backup and Restore database 2.       Attach / Detach database 3.       SAN magic…

0

Extended “Backup” Retention with Azure SQL Database

As you may or may not know, Azure SQL Database is a great tiered offering that comes with backup retention capabilities out of the box.  What is awesome about this offering is it makes backing up your database braindead simple, and saves you the administrative effort of creating a maintenance plan to do this.  It…

0