20 May 2015 SQL Server Upgrade Advisor 2014

Wondering where to start with your dinosaur database servers that are still floating around somewhere in your highly state-of-the-art environment? Oh yes, everyone else may have forgotten about them, but these machines still exist. While everybody is happily doing their job, you still need to maintain the old servers. After all, you're the DBA and your job is to keep these machines alive.

04 May 2015 Webinar: hands-on with Power Query

Microsoft Power Query is Excel-like software from Microsoft that helps you gather, transform and analyse data from a wide variety of sources. In our webinar we explained how to use Power Query in your daily work by guiding you through some examples

20 Apr 2015 Hesitating about the cloud will cost you flexibility (and money)

Cloud computing is fully mature, so we believe that many of your SQL Server systems could be running more efficiently in the cloud. We are convinced that a cloud model, whether hybrid or full cloud, is in fact the best solution for most of our customers. The only questions that remain are: when are you going to migrate and with which model?

06 Apr 2015 Hacking the Central Management Studio (CMS)

With this post I want to show you how you can make a central management server (CMS) selective for different user accounts so that you can use public and management roles, only showing the servers that are necessary to do your job. This enables you to only maintain one CMS, but show different servers (and even groups) dependent of your role (operator, junior DBA, Sys DBA,…) these roles are only limited by your needs and imagination. First I looked into Row- and Cell-Level Security

18 Mar 2015 Boosting self-service BI: Microsoft Power BI

Susan walks into her office and wants to assign a job to Tom about absenteeism. But ironically it seems he's not at work because he's ill. So she decides to try doing the job herself. She takes her laptop and opens Power BI Designer for the first time. It looks enough like Excel to make her confident about using it. In no time she works through the data that the IT department has prepared, creates a report about employees and absenteeism over time and publishes it to the internal HR portal.

09 Mar 2015 How to create a date table in PowerPivot with one single value

Calculations that make comparisons to previous quarters or to the same period one year ago are very important in all business intelligence tools. DAX, the formula language in PowerPivot, allows you to define such calculations by means of Time Intelligence Functions . However, in order to use these, you need to include a Date dimension table in your PowerPivot model. When you do not have access to a date table in your ICT network, you will be able to create one on the spot after reading this post.

16 Feb 2015 Transfer AdventureWorksDW2014 into a Document DB Collection

The goal of this blogpost is to transfer a dataset from the Adventureworks DB and query it in the same way that you would on your own DWH, but running on a DocumentDB NoSQL database. This blogpost is not intended to compare any RDBMS based data warehousing to Document-based data warehousing. It’s purely to demonstrate that you can actually migrate a dataset from a pure RDBMS data structure and transfer it into a document-based NoSQL Engine and run data warehouse queries.

09 Feb 2015 Checking availability group status using a Central Management Server

Today I want to show you another powerful way to use your Central Management Server. The CMS can also be used to execute OPENROWSET queries over your complete SQL Server Farm. Now I can hear you all say: “Why would you want to do that?” and “OPENROWSET, you know that you shouldn’t implement that for queries that have to run frequently!”. And to be honest, in most of the cases you’d be right. But it can come in extremely useful in some situations.

31 Jan 2015 How to get Google Analytics data in Power Query

Microsoft Power Query is an Excel add-in that helps you gather, transform and analyse data from various sources. It's a very powerful tool and a must have for anyone interested in BI, no matter how experienced. Microsoft also releases frequent updates of this add-in, including new source connections. Google Analytics is a powerful tool for monitoring and analyzing your website traffic. It helps you know who is visiting, what they are looking for and how they are getting there.