Complete guide to setting up Power BI connecting to Postgres w/ refresh enabled.

You may or may not have seen but Microsoft announced a couple new database services, namely Postgres and MySQL. What’s unique about these two database services is they work very similar to SQL Azure, in particular there is no VM for you to provision or manage. When you provision the resource you get an endpoint…

0

Connecting to Blob Storage with a Shared Access Signature in Power BI

As you’re likely aware Power BI supports dozens of data sources out of the box enabling you to mash up data from a variety of sources.  Each one of these sources of data has a unique configuration governed by the capabilities of the source (ie. text files vs. a database).  At times you may also…

0

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