Get Notified When Your Home Router IP Address Changes–With PowerShell!

Readers of my blog over may recall I’m an amateur (ham) radio operator (N4IXT that’s me!). One of my ham radio buddies has a cool radio that can be remotely controlled over the internet. With their software he just enters the IP address of his home (his home router that is, after we setup some port forwarding), and he can connect to and operate his radio remotely, make contacts around the world and more.

The tricky part of all this came in the sentence enters the IP address of his home…. His home router tends to change its address on the whim of his service provider. If the router reboots, it will definitely have a new address when it comes up. You may be thinking “well just get a static IP address”. Unfortunately, his internet service provider can’t give him this, something about him using a bonded pair of 10 mb lines to get 20 mb prevents it.

So how could he get notified when his IP address changes? Well I was fairly certain I could solve his problem with some simple PowerShell scripting!

I’ve now published the solution on my GitHub site:

Rather than going more in-depth here, the ReadMe has the full details describing the scripts that were created. In addition the code is heavily commented.

In addition to solving this particular problem, the code could be used as a template for:

  • Getting the IP Address of your home router
  • Sending emails via GMail
  • Setting up tasks in the Windows Task Scheduler

Hopefully other people with similar issues will find this little project as useful as my ham radio buddy has!


Azure PowerShell PlaybooK: Azure SQL–Now on Pluralsight!

My latest course is now available on Pluralsight! It’s the Azure PowerShell Playbook: Azure SQL. If you aren’t familiar with Pluralsight’s Playbook format, they are fast past courses that are almost 100% demo driven. They are meant to be consumed quickly, my course is just one hour and four minutes long. Great lunchtime viewing!

This course shows you how to use PowerShell to manage and migrate your on premises database up to Azure SQL. In brief, you’ll learn how to:

  • Create resource groups
  • Create and work with Storage Accounts
  • Create a SQL Server in Azure SQL
  • Package up your local database into a bacpac file
  • Import your bacpac file into a new Azure SQL database
  • Execute commands against your new Azure SQL database
  • Cleanup! I even show how to remove everything you’ve created, individually or as a whole

And all of this with PowerShell!

Additionally, I’ve included functions for just about everything listed, so (assuming your subscription gives you access to the samples) you’ll have a great starting point for your own library of cmdlets. (All the code for the functions appears on screen, so if you have to you could always pause and type it in.)

You can find my new course at:

I also wrote an article for RedGate’s SimpleTalk website that aligns well with this course. I dive deeper into the restartability aspect of the way the functions were coded, something I couldn’t get deep into with the video course due to time constraints.

What’s that? Yes you in the back row, you say you don’t have a Pluralsight subscription? Well no worries, just email me, and I’ll be glad to send you a code that will be good for 30 days at Pluralsight. During that time you can watch my courses, indeed you can watch any course at Pluralsight.

Mobile Report Publisher–Dashboards Everywhere

My latest article on RedGate’s SimpleTalk site has just come out: Mobile Report Publisher – Dashboards Everywhere.

In it, I give a quick overview of using SQL Server 2016’s Mobile Report Publisher to create a simple but useful dashboard. Mobile Report dashboards can be assembled easily, and quickly, from SSRS (SQL Server Reporting Services) Shared Datasets.

Reports generated with Mobile Report Publisher are great, as they can be used on, as the name suggests, mobile devices such as phones and tablets, but on websites as well. They fill the need between a traditional report and those analytic reports created by self service tools such PowerBI.

Using the instructions in my SimpleTalk article, you should be able to create your first, simple report. If that wets your appetite for more, I can offer two additional learning paths.

First, there’s my book SQL Server 2016 Report Services Cookbook. In it I have an entire chapter on the Mobile Report Publisher. Being an entire chapter I had more space to go deeper, and provide instructions on pulling data from multiple sources. I also go into the use of other components in the dashboard. You can find the book on both Amazon and my publisher, PactPub’s website.

The second resource is my Pluralsight course What’s New in SQL Server 2016 Reporting Services. The report gives a great overview of all the new features of SSRS 2016 (and still applicable to 2017). The bulk of the course focuses on the Mobile Report Publisher, but I also cover other new features such as the new Report Portal, and the ability to host KPIs right on the portal, among other features.

Don’t have a Pluralsight subscription? No worries, just email me, and I can send you a code good for 30 days during which you can watch my courses, or any of the great courses at Pluralsight!

Opening Port 80 in Windows Firewall to Support Calling SSRS From Another Computer

Recently I was working on another article for RedGate’s SimpleTalk site. As part of it, I had SSRS installed on a Windows 10 computer, and needed to connect to it from another computer. I was having a lot of issues connecting, until I remembered SSRS connects using Port 80, and by default Windows 10 (and previous versions) block Port 80 for incoming traffic.

The solution was to, obviously, open Port 80 on the Windows 10 computer. Doing so was not difficult, but did require quite a few steps, and of course administrator rights on the computer.

First, open the Windows 10 Settings. Then, click on Network & Internet.


On the Status window, click on Windows Firewall.


From here, click on Advanced settings.


If prompted confirm you do wish to make changes. When the Windows Defender Firewall dialog appears, click on Inbound Rules.


Now click on New Rule


In the New Inbound Rule Wizard window, change the type of rule to be Port. Then click next.


On the next window, leave the rule applying to the default of TCP. For the port, assuming you are using the default setup, enter 80 for the port number. If you setup SSRS on a different port then obviously use that port number instead.


On the action page we tell Windows what we want to do if it finds incoming traffic on this port. For this development environment we will take the default of Allow the connection. If you had setup https service on your report server, then you could take the second option of allow if secure.


Next, we need to specify what network type the rule should apply to. For the scenario, I am on a small network, such as you might have at home, and that network was setup as private. Thus I am leaving Private checked on, and unchecking Domain and Public.

Unchecking public is especially important if you plan to take your laptop out to a coffee shop, you don’t want someone trying to hack into your machine via port 80. When done just click next.


On the last screen we’ll give the firewall rule a name, and a description. When done, click finish.


As you can see, the new rule now appears in our Inbound Rules area.


Once you have completed working with your SSRS server, I’d suggest you return here, right click on the rule, and either disable it, or if you know it will no longer be needed, delete it.

And with that you should now be able to connect to the computer running SSRS from another computer on your network.

Introduction to DW/BI–My Newest Old Course at Pluralsight

Way back in November of 2010, I published my second course with Pluralsight, Introduction to Data Warehousing and Business Intelligence. Over that time a lot has transpired. While the basic fundamentals haven’t changed, a lot of technology has. In addition, Microsoft’s WideWorldImporters sample provides a great platform for demonstrating many of the concepts.

Additionally, I have to admit that after eight years the slides and accompanying graphics have started to look a bit dated. As a result, Pluralsight asked me to update the course.

I’m happy to announce the new and improved version of Introduction to Data Warehousing and Business Intelligence is now live at Pluralsight!

In case the title didn’t give it away, in this course I cover all the basics of data warehousing and business intelligence. What are facts and dimensions, and what do they actually look like in the database? How should you design a data warehouse?

All new to this course, you’ll see the various tools  from Microsoft to do DW/BI, using the all new Wide World Importers sample database as our platform. You’ll see how to design a database using SSDT, and see how the concepts of DW/BI were implemented.

You’ll also see how SSIS was used to achieve ETL, as well as SSAS to create an analytic cube to do BI. Multiple tools are then explored for reporting; SSRS, Mobile Report Publisher, Excel, and PowerBI.

So, who is this course for?

As a DBA, you’ll be asked to implement new data warehouse projects. The design of a data warehouse is very different from a traditional database, and it’s important to understand these differences. In addition, you’ll be asked to install and configure the data warehouse tools. We’ll talk about the tools included with SQL Server, such as SQL Server Integration Services, Analysis Services, and Reporting Services.

If you are a database designer or developer, you’ll be asked to design these data warehouses. As we said, the design is VERY different from a traditional database. You need to understand these differences in order to implement a data warehouse.

Software developers are interacting with data warehouses on an increasing basis, in order to get additional data for their programs. In the past developers had to create custom interfaces to other systems in order to get additional information needed for their applications. In today’s world developers are being told to get that required data from the central repository of the data warehouse.

Finally, this course is valuable for project managers and business users who seek to understand the systems they can pull data from in order to do self service reporting. By the end of the course users will understand what terms like facts and dimensions mean, and how to effectively use them in your reporting.

If you aren’t already a Pluralsight customer, but are interested, just shoot me an email: free @ I can hook you up with a code which will give you 30 days of access to their site, during which you can watch my courses, or any of the courses on Pluralsight. S

iTunes Won’t Recognize iPad/iPhone after upgrade on Windows 10

I recently installed iTunes on Windows 10; after the installation it would no longer recognize my iPad Pros (either one of them). The iPad would ask if I wanted to grant access to photos, etc., but iTunes itself would never show the iPad as being connected. Prior to the upgrade I had no problems connecting.

I found the solution at: .

First, unplug an i-devices you have hooked up. Then, navigate to:

 %ProgramFiles%\Common Files\Apple\Mobile Device Support\Drivers

Find either usbaapl64.inf or usbaapl.inf. Right click on it, and pick Install

Reboot your computer, then give it another try. If it doesn’t work, the link above has a few other suggestions you can try, but this worked for me.

Hopefully this will help someone else with similar issues (or act as a reminder to me in the future Winking smile   ).

Adults Only Minecraft for Suicide Prevention


For some time now I’ve been working with a group of Minecrafters to raise money for the American Foundation for Suicide Prevention. So far we’ve raised over $3,400 dollars toward our year end goal of $3,650, so I’m writing to ask your help toward our goal. Anything you could give at would be appreciated to help out this worthy charity.

What? Minecraft? Robert, you’re telling me you play Minecraft?

OK, I have a confession to make. I LOVE Minecraft. I don’t know why, I just find it relaxing, and it lets me be creative in ways outside what I normally do. I blame my kids, they got me hooked.

I also have to blame Marc over at Adults Only Minecraft ( When my kids first got me to play Minecraft I thought “eh, that’s cute” but it didn’t really grab me. Then I found the Adults Only Minecraft channel. It showed me all the cool, creative things that could be done, and I was hooked.

If you are wondering about the name, Marc used to play on some servers that hosted a bunch of kids who that thought it was great fun to “prank” others by blowing up or otherwise destroying their creations. Marc decided to make an environment for “adults only”, where grown ups would respect each others builds, and work together on creative, interesting projects. I guess it didn’t occur to him at the time that “adults only” might be misconstrued, but I can assure you it’s a very family friendly channel.

I became a follower of the channel, and began joining his live streams on a regular basis (each Wed night at 9pm Eastern). Each week Marc and a group of intrepid Minecrafters participate in a live stream to participate in some building activity. While they stream there is an active chat room that talks about the build, or whatever comes to mind (no politics or naughty language though, to keep it friendly).

Eventually I was honored to be asked to join as a chat room moderator. Since then I’ve gotten to know the group that plays each week, and learned what a wonderful group of people they are both on and off stream.

So I’m writing this to make an appeal. Marc has been working to raise money with his live streams for the American Foundation for Suicide Prevention. So far, Marc has raised over $3,400 dollars toward his year end goal of $3,650.

The holiday season is a happy time for many, but sadly this time of year also sees an increase in suicides. It seems an appropriate time of year to help the American Foundation for Suicide Prevention help those who suffer from thoughts of suicide at this time of year.

No amount is too small, if even a third of my twitter followers would donate one dollar we could blow the lid off the current donation levels. I hope you can help out during this holiday season, by using the link below to make a donation. Thanks! 

Robert / ArcaneCode / ArcaneMining

Adults Only Minecraft Links