SQL Saturday 649 Session Recap

image001

We had a great session today on SSRS 2016 and all of its new features. As I mentioned this morning you can download and experiment with these tools without having to install SQL2016. Here are a couple links for the downloads that I would like to share with you.

SSRS 2016 Report Builder Download

SSRS Mobile Report Publisher Download

Here’s the download for the slide deck. Whats new in SSRS 2016

Here’s a link to a Microsoft site with an overview of what was covered today. https://msdn.microsoft.com/en-us/library/ms170438.aspx

It’s almost that simple: Changing Azure SQL DW Service Objective (DWU Level) during ETL

Great blog from Bob Rubocki on how to scale up and down your SQL DW using TSQL and SSIS.

Bob Rubocki

A feature of Azure SQL Data Warehouse is the ability to scale (and pay for) compute resources as needed.  This is particularly useful when loading data to a data warehouse.  ETL operations typically put heavy load on the data warehouse, and could benefit from increased computing power.  When the load process completes, however, that extra power may no longer be necessary.

The simplest way to adjust the compute power setting (known as the Service Objective or DWU level) is using the slider in the Azure Portal, shown below.  Sliding up increases compute power, sliding down decreases compute power.

azuresqldwscaling_slider Scale Azure SQL DW Compute with Slider

You could use the slider GUI to manually increase the compute power prior to running the ETL, and decrease the power after the ETL finishes.

Compute power can also be changed with a PowerShell command, REST API call, or SQL command.  Following is a sample of the…

View original post 767 more words

Tracking Hurricane Matthew with PowerBi

We’ve got company and it’s not the type of company that you want! As most Floridians are preparing for Hurricane Matthew I thought it might be neat to track the storm using PowerBi. So I went out and found some public data online and brought that into PowerBi, created a couple calculations and some visualizations.

My goal for this was to create a report where I could track the storm no matter where I was. I also needed the ability to see the latest data without any manual intervention. PowerBi can handle all of this for me utilizing the PowerBi Mobile app and a few other cool features.

So without further ado here’s the final result. Here’s a link to the report if you want to try it and see some other visuals.

*** Use at your own risk. I take no responsibility for the accurateness of this. Don’t use this as your only source of information on this storm. ***

 Click to open the PowerBi reports for Hurricane Matthew

Here’s an image from the PowerBi app so I can track it on the go.

 image001

Here’s a new cool preview feature called ArcGis map. This will be cool once the storm get closer and I can add more layers. For more info on this check out the September 2016 updates for PowerBi. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-feature-summary/

 image002

Here’s an image from my dashboard I created on the PowerBi site.

 image003

 

SQL Saturday 531 Session Recap

image001

We had a great session today on SSRS 2016 and all of its new features. As I mentioned this morning you can download and experiment with these tools without having to install SQL2016. Here are a couple links for the downloads that I would like to share with you.

SSRS 2016 Report Builder Download

SSRS Mobile Report Publisher Download

Here’s the download for the slide deck. Whats new in SSRS 2016

Here’s a link to a Microsoft site with an overview of what was covered today. https://msdn.microsoft.com/en-us/library/ms170438.aspx

I’m Speaking at SQL Saturday #531 Louisville

image001

I will be speaking at SQL Saturday Louisville on August 6th 2016. I will be doing a session on what’s new in SSRS 2016. So come on out and enjoy this free event. There are dozens of different speakers covering a wide variety of topics. Click on the link below to see the full schedule and register.

Here’s a link to the event along with further information.

http://www.sqlsaturday.com/531/EventHome.aspx

 

Here’s a link to the registration, go sign up today.

https://www.sqlsaturday.com/531/registernow.aspx

SSRS 2016 Report Builder RC3

Want to experiment with some of the new 2016 SSRS features without having to install another instance? Well you’re in luck. Try downloading the new report builder RC3 which is now available.

https://www.microsoft.com/en-us/download/details.aspx?id=51935

 

Here are a few of the new enhancements that you can see in the new report builder.

  1. It has a new interface, if you have used it before you have nothing to worry about. It’s mainly cosmetic changes.
  2. It now has a custom parameters pane where to can move the parameters locations to some extent.
  3. Power Point Export
  4. New visualization’s and a few others.

 

Just keep in mind that most of the new fancy dash boarding, KPI and mobile dashboards features will still require you to install SSRS 2016 and setup the web portal.

 

The link below will also go over some other install options as well.

https://msdn.microsoft.com/en-us/library/ff519551.aspx

 

Also here’s a good link covering most if not all of the new SSRS 2016 features.

https://msdn.microsoft.com/en-us/library/ms170438.aspx

 

 

 

I’m Speaking at SQL Saturday #522 Jacksonville

image001

I will be speaking at SQL Saturday Jacksonville on May 7th 2016. I will be doing an introductory session on SSAS multi-dimensional. So come on out and enjoy this free event. There are dozens of different speakers covering a wide variety of topics. Click on the link below to see the full schedule and register.

Here’s a link to the event along with further information. http://www.sqlsaturday.com/522/EventHome.aspx

Here’s a link to the registration, go sign up today.

https://www.sqlsaturday.com/522/registernow.aspx