My Intro to PowerShell

I grew up on DOS back in the mid 1980's, PC-Dos, not MS-Dos.

So I've heard of the language called Power Shell, but never got around to learning.

So at the SQL Saturday over the weekend in Tampa, #326, I bumped into Max Trinidad, a Microsoft MVP for Power Shell.

We spoke about the power and awesomeness about Power Shell and I attended his session.  He showed how to incorporate Power Shell into SSIS using the Execute Script component.  Said you can administer services in Microsoft Azure, create exe files as well as Debug scripts.  You can also write Power Shell scripts within Visual Studio using a plug-in.

So today, I watched an Intro to Power Shell video on YouTube.

And I found a TechNet article on "Overview of Cmdlets Available in Windows PowerShell".

I knew you could perform database backups, move files and create scripts., but I did not realize that the entire set of commands runs on the dot net framework.  So that means that anything you can do in c# or VB, you can do in Power Shell.

I also watched this video "Basics of Power Shell"

And "Learn Power Shell in a Month of Lunches"

It seems to be that it's all about learning how to use the "Help".

It's funny that we started at the command line, went to windows, and now back to command line.  Full circle!

New stuff.  Lots to learn.  This well is deep, but powerful.

At least we're off and running~!


#Microsoft #Excel 2013 #MDS Add-In Install Error (Fix)

At a client site, we had an issue of loading the add in for Microsoft Master Data Services (MDS) for Excel 2013.

To get the MDS Add In for Excel, this article assisted.

The trick was to download and install many of the items listed here:

I can not tell you which file specifically solved the problem, however, it's safe to say that the combination of files for either x64 or x86, depending on your Excel version, solved the problem, on more than one computer.

Happy coding~!


Speaker at IT Pro Camp Tampa

This morning I presented at the Tampa IT Pro Camp .  Topic of conversation was - Intro to Business Intelligence.  Started at 9am.  The room was small to mid size.  Just about ever seat was full.

I thought it went well, one of my best presentations.  However, I did not use a Power Point deck.  I simply had a Word doc with the outline of topics of conversation. With each bullet point, expanded upon real life scenarios.

Also, the other interesting thing is I had absolutely no demos.  I've been bitten by the demo bug, while giving a presentation on Power BI at USF for SQL Saturday.  The Internet kept going out, which my demo was 100% dependent upon, and it was quite not so good.

This time, people asked questions along the way.  And of course I threw some jokes in as well.

It was a good crowd and I felt like it was more of a conversation than a speech, people seemed to be engaged.

I also co-presented Intro to SSIS with Jose Chinchilla at the 10am session.

And finally, I spoke with some of the other speakers, had a few donuts and coffee and thought the event was well run.  One of the event organizers asked if I'd like to present next year at the Sarasota IT Pro Camp.  Sure, sounds great.

See you then~!


#SAP Project on the Horizon

I viewed the menu for next week.  It consists of SAP.  Some Webi, some Crystal Reports, some ETL and some spec gathering.

That's right.  A new project is starting up.

I've been working with Crystal Reports since about 1995 / 1996.  Version 5 was just being released.  Working for the bank, we had just aquired a bank in St. Louis and one of their consultants was onsite and I spent the entire day locked in a room asking him questions.  By the end of the day, I was fluent in Crystal.

Fast forward a couple of decades, man has the product evolved.  With Business Objects CMS, which I was a former admin working at the County, to WeBi to Universes and of course, trusty Crystal Reports, which hasn't changed much to be honest.

Universes are simply meta data layers in between the front end reports and the back end OLTP database.  It doesn't actually store a copy of the data like Microsoft SQL-Server Analysis Services OLAP does.  However, Universes allow end users to build ad-hoc reports without having to know about databases, SQL, joins, etc., which is a nice feature.  Except it's basically a pass-through to the OLTP database.  And you have to do some magic to handle date hierarchies, like build summary tables at each level.

There's two ways to work with Universes, as the product has evolved.  And there's an Explorer utility.  And Predictive Analytics.  And SAP Hana, an in memory database.

So the SAP offerings have all the bells and whistles.  And next week I'll be in the deep end of the pool.

Should be fun~!

Mountain Living