Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensional. However, one of the instances also has Master… Read more
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great audience, fantastic speakers and nice booths by the sponsors (especially the bar with Belgian beer was pretty awesome). It was great meeting up with the #sqlfamily again.
Anyway, I gave… Read more
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The most important one is my switch to a new employer. After almost 3 years being happily employed at Ordina Belgium, I’ll move to element61 in November. element61 is a…
I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The biggest SQL Server event of the year in Belgium, with lots of learning opportunities for developers, BI folks and DBAs. This event is organized by SQLUG, the Belgian SQL Server… Read more
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services. He used a variable to specify the name of the directory to be created and this variable was populated by a parent package configuration. If… Read more
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this… Read more
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL Tuesday which is hosted this month by Rick Krueger (blog | twitter). The topic is about that one time we did a hack to get something sorted out,… Read more
With the release of the revamped Integration Services in SQL Server 2012, a bunch of new deployment methods were introduced for the project deployment model. My article SSIS Deployments with SQL Server 2012 gives an overview of these deployment methods. One of these methods is using PowerShell to deploy your… Read more
The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions directly to the teams responsible for those products. People can vote on items to indicate them as more important.
At least, that’s the theory. It’s been known that the communication… Read more
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll give a short review for each one of them.
Information Dashboard Design
This month’s T-SQL Tuesday is hosted by Bradly Ball (blog | twitter) and the topic is second chances. The idea is to pick one of those moments in our career we wish we could do once again. A second chance to make it all better, or at least… Read more
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here’s a nice overview:
- BIDS or Business Intelligence Development Studio. The most non-confusing name…
In the final part of this series, we will create a BI subsite in our site collection. You can use this site as the starting point for your SharePoint BI demos. Browse to the PowerPivot site we created earlier in part 7 and go to Site Contents. Click on… Read more
Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in SharePoint integrated mode. The steps we are going to follow are described in the following MSDN document: Install Reporting Services SharePoint Mode for SharePoint 2013.
Attach the SQL Server… Read more
After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works correctly. The verification process is described in the following MSDN article: Verify a PowerPivot for SharePoint Installation. First of all let’s start by verifying the site level integration.… Read more
In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration Wizard in order to configure our SharePoint installation. If you followed the previous walkthroughs, you can find the wizard in the start menu. It is not necessary to run the… Read more
Before we can configure SharePoint, we will have to install the Analysis Service instance that will host the PowerPivot workbooks used in SharePoint, also known as “the PowerPivot instance”.
The first step is to create a service account for this instance. I named it SP2013BI\SPPowerPivot.
The next step is attaching… Read more
Let’s get started with the next step in the series: installing SharePoint. We will install only the software, but we do not configure it. We will do this later with the PowerPivot Configuration Tool, which is explained in another blog post.
The first step is to create a farm account.… Read more
This part of the series will focus on installing the Windows Server 2012 OS on the virtual machine. In most cases, you have an image file with the installation media available. In the VM settings, go to the DVD drive and attach the image.
Now start the VM.
While the… Read more
In this blog post I’ll explain how I build the VM and VHD for my virtual demo environment. I use Hyper-V locally on my Windows 8 OS to run my virtual environment. If you have Windows 8 Enterprise, Hyper-V is a feature you can simply enable in the control panel. Read more