All posts by arcanecode

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 @ arcanetc.com. 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

Advertisements

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

I recently installed iTunes 12.7.2.60 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: https://support.apple.com/en-gb/HT204095 .

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

Suicide_Prevention_Charity_Splash_Screen_v3

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  http://tinyurl.com/MCStopSuicide 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 (https://www.youtube.com/channel/UC4qYM4ZIwaEKg0Ti0ah-OJA). 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! 

http://tinyurl.com/MCStopSuicide 

Robert / ArcaneCode / ArcaneMining

Adults Only Minecraft Links

YouTube: https://www.youtube.com/channel/UC4qYM4ZIwaEKg0Ti0ah-OJA

Twitter: https://twitter.com/AdultsMinecraft/

Facebook: https://www.facebook.com/ForAdultsOnlyMinecraft/

Google+: https://plus.google.com/u/1/+Adultsonlyminecraft

SQL Server 2016 Reporting Services Cookbook–On Sale Until 2018!

SQL Server 2016 Reporting Services CookbookHappy  Holidays! As a gift to everyone, PACKT Publishing has put the e-book version of my SQL Server 2016 Reporting Services Cookbook on sale for just $5.

Yes, that’s right, for the same price as a pumpkin spice chai tea latte with extra whip cream, and a quick trip to http://bit.ly/ssrscook, you could be reading this magnificent tome of wisdom.

Now, I can year some of you going “but Robert, SQL Server 2017 is out now, is this still relevant?” Yes, absolutely! Very few changes were made to the 2017 version of SSRS, so everything in this book is just as valid.

And it’s not just my book that is on sale, all the e-books at PACKT are on sale for the same low low price. So after you get done adding the SQL Server 2016 Reporting Services Cookbook to your shopping cart, be sure to check out the other awesome titles on PACKT Publishing.

This book, by the way, makes an excellent companion to two of my Pluralsight courses.

The SQL Server Reporting Services Playbook, https://www.pluralsight.com/courses/sql-server-reporting-playbook, is designed for people who are totally new to SSRS and need to get up to speed FAST.

Already know SSRS, and just want to learn what’s new with SSRS 2016? Then my appropriately named What’s New in SQL Server 2016 Reporting Services course, https://www.pluralsight.com/courses/sql-server-2016-reporting-services, is just the thing for you. It goes over just the new features in SSRS 2016 (and still applicable to 2017) and does it fast. With this short course you can be up and running with 2016/2017.

What? You don’t have a Pluralsight subscription? Well I’m shocked, but OK I can help you out. Just send me an email to

free@pluralsight.com

and I can fix you up with a code good for 30 days during which you can watch my courses, or any of the fine courses at Pluralsight. (If you want to see all my courses, just click the About Me link at the top, or go to http://arcanecode.me).

If you have some free time during the holiday season, and want to avoid the in-laws, then curling up with a great book (like the SQL Server 2016 Reporting Services Cookbook) beside the yuletide fire can be a great way to spend your time!

A Walk Around SQL Operations Studio

In my latest article on RedGate’s Simple Talk site, I take you on a walk around the brand new SQL Operations Studio, or SQLOPS for short.

If you haven’t heard about it, SQLOPS is the new open source, multiplatform tool for using SQL Server, think of it as SQL Server Management Studio for the PC. And the Mac. And even Linux!

My article walks you through the critical components: Where to get it, how to install it, and some basics on how to use it. Even though it is in preview, there are some features it has, which SSMS does not, that make it worth looking at today.

You can read the article at http://bit.ly/acred02, or the full URL is https://www.red-gate.com/simple-talk/sql/sql-tools/walk-around-sql-operations-studio/ .

You can see all my Simple Talk articles at http://arcanecode.red

Creating Azure Resource Groups Safely With PowerShell

A few posts back I mentioned that I had become a SimpleTalk author, and that my first post for them was PowerShell Functions For Reusability and Restartability in Azure (read it at http://bit.ly/acred01)

I’ve created a companion video for it, which focuses on creating Resource Groups. You can see it below, or on YouTube at http://bit.ly/acredyt01.

As I mention in the video, you can find the code samples on my github site, at http://bit.ly/acredgit01

Fixed! PowerPoint 2016 Presenter View Not Showing

I purchased a new laptop earlier this year, a pretty sweet Lenovo ThinkPad. The only thing that annoyed me was PowerPoint 2016 wouldn’t show the presenter view. Well I finally got around to tracking down the issue. I found a post in an MSDN forum that was close, but not quite right in the instructions. In fairness the answer was several years old so the interface likely changed in that time.

The issue relates back to the NVIDIA driver. I did see some posts suggesting you uninstall the NVIDIA driver and roll back to an older version, but I didn’t find it necessary to do anything that drastic. Solving it was just a few simple steps.

image01First, if you have PowerPoint open, you should close it. Now, right click on your desktop, then select nView Desktop Manager. If you don’t see this option, then the this solution won’t solve your issue as you either don’t have an NVIDIA card, or don’t have the right NVIDIA software installed.

image02

Next, click on Applications, on the left in the tree view (1). Then, click the Enhancements button in the lower right (2).

image03

Finally, uncheck the box beside “Add PowerPoint slide show extensions”.

Click OK to close the Application Enhancements window, then OK again to close the nView Desktop Manager window.

And that should be it, open PowerPoint, start your slide show, and the presenter view should now appear for you (don’t forget to check Presenter View on in the Slide Show options tab before you start the show).

Note that I’ve only tried this with PowerPoint 2016, although I’m guessing it would likely work with older versions of PowerPoint as well (if it does, leave a comment letting everyone know what version of PowerPoint you were using).

Hopefully this solution will work for you too!