Enterprise Reporting Services Jump Start Guide

by dennyglee Categories: Reporting ServicesTags: · · Leave a comment

While there is a lot of deserved and great interest with Power View, almost forgotten is the IT workhorse SQL Server 2012 Reporting Services for your corporate / managed reporting infrastructure.  For great references on SQL Server 2012 Reporting Services, my suggestions include: What’s New In SQL Server 2012 Reporting Services SQL Server Reporting Services Team Blog Robert Bruckner’s Reporting Services and Power View Blog – Principal Architect within SQL Server Reporting with excellent insight into both Reporting Services and Power View. In my former life, I had worked on some pretty complex Reporting Services customer projects.  While these references…

Rate this:

Installing Hadoop on OSX Lion (10.7)

by dennyglee Categories: BigDataTags: · 31 Comments

For starters, this isn’t a production setup, this is just so that I can do some quick Hadoop demos on my Macbook Air (2011).  In this case, my configuration is OSX Lion, 4GB RAM, and 256GB SSD.   As well, a serious shout out to the authors below whom I had referenced to create this post. References: • Installing Hadoop on Mac OSX Lion by Ritesh Agrawal • Flume and Hadoop on OSX by Arbo v. Monkiewitsch (@arbovm) . In fact, originally I was just going to provide links to their blog posts but ran into some hiccups along the way. …

Rate this:

Connecting Hadoop on Azure to your Amazon S3 Blob storage

by dennyglee Categories: BigData · CloudTags: · · · · 8 Comments

When working with Hadoop on Azure, you may be used to the idea of putting your data in the Cloud.  In addition to using Azure Blob Storage, another option is connecting your Hadoop on Azure cluster to query data against Amazon S3.  To configure Hadoop on Azure to connect to it, below are the steps (with the presumption that you already have an Amazon AWS / S3 account) and have uploaded data into your S3 account. 1) Log into your Amazon AWS Account  and click onto Security Credentials 2) Obtain your access credentials – you’ll need both your Access Key…

Rate this:

PowerPivot for SharePoint: Existing Farm Installation

by dennyglee Categories: PowerPivotTags: · Leave a comment

So the fate… of the entire human race depends upon my wild guess      — Doctor Gaius Baltar (Battlestar Galactica)     Actually, the quote that I really wanted to say was “So the fate… of the entire PowerPivot deployment depends upon my wild a** guess?!  WTF!!!”   Yet, this is not the time for us to go quietly in the night!  Do not go gentle into that good night! (Dylan Thomas)   Okay, I’ll stop now. But seriously, PowerPivot for SharePoint for an existing farm installation can be complex and mind numbing at times – especially with the 20…

Rate this:

Delegation, Claims, Active Directory…Oh My!…Aw Crap!

by dennyglee Categories: PowerPivot · SharePointTags: · · · · · · 9 Comments

Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state  😉 Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written by yours truly) and Excel Services delegation (by PowerPivotTwins partner Dave Wickert).   More importantly, if you want to debug and troubleshoot your way through the PowerPivot / Excel Services delegation issues, the coup-de-grace is Lee Graber’s excellent post: that The data connection uses…

Rate this:

Update SharePoint 2010 Farm Credentials Tips

by dennyglee Categories: PowerPivot · SharePointTags: 6 Comments

Within your SharePoint environment – such as your PowerPivot for SharePoint single server install – a common task that you will need to do is to update the SharePoint Farm credentials  when the password changes.  You may be able to do this automatically by using the new SharePoint 2010 feature to plan automatic password change.  But if you need to change your farm credentials, you can follow the instructions: How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0. But in the process of updating a PowerPivot for SharePoint single server…

Rate this:

Ramblings about missing time … and #PowerPivot sneak peek!

by dennyglee Categories: PowerPivotTags: · · · · · · · · 4 Comments

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But I do have a good excuse!  Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…

Rate this: