Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re gonna get. Recently I ran into some troubles (or woes) when configuring MDS at a client. The installation went smoothly, as well as the installation of other prerequisites (like… Read more
SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing:
- new look ‘n feel for Report Builder: Report Builder Changes in SQL Server 2016
- new chart types (check out my sunburst, treemap and heatmap articles)
- a (somewhat) customizable parameter pane
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
I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.
The title is What’s New for Business Intelligence in SQL Server 2016 and its abstract goes like this:
The preview of SQL Server 2016 has been released right before the summer and it already seems this will be…
Recently I gave a session on the SQL Server Days about the new features for business intelligence in SQL Server 2016. I have always found that the design of the slide deck matters and this time I was fortunate enough to have the assistance of 356labs, a presentation design… Read more
Here is an overview of the articles I published in the third quarter of 2015.
- Retrieve file sizes from the file system using Power Query
- Create a Treemap Graph in SQL Server Reporting Services 2016
- How to create a heat map graph in SQL Server Reporting Services 2016
- How to…
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too many to mention, and I saw some interesting sessions. My favorites were David’s session about loading data faster and Catherine’s session about BIML (yes, both are related to SSIS). I… Read more
SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager at Microsoft because some of the MSDN documentation pages are already updated. One of those pages is What’s New in Reporting Services. There we can see three new features… Read more
The pie chart should be avoided at all costs. Why?
- you can only display a limited number of slices (although that doesn’t really stop people from creating pie charts with dozens of slices)
- they take up a lot of space
- the human brain cannot easily compare slices based on radial…
SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live action? You can watch my MSSQLTips.com webcast on-demand where I demonstrate this trick. Start watching at around minute 38.
Lately I have been using more and more the awesomeness… Read more
I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI in SQL Server 2016. I uploaded the sample models into MDS and I opened up Master Data Manager in Internet Explorer to try out some of the new features. The… Read more
When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS, SSAS & SSRS) projects. If you have a full blown Visual Studio installation, you needed the BI templates; if you didn’t have Visual Studio (or the right version), you would… Read more
I’ll be giving an SSIS webinar for MSSQLTips.com on Tuesday 15th September 2015.
The title is SQL Server Integration Services Best Practices and Tuning Tips and its abstract goes like this:
Did you ever inherited a slow running un-maintainable mess of an SSIS package? Or do you want to knock…
As a lot of features, Report Builder will improve as well in SQL Server 2016. At the moment of writing CTP 2.3 has been released and Report Builder has the following changes:
- more up-to date look ‘n feel
- high dpi in the preview
- HTML5 support
Screenshot of the look ‘n… Read more
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime I ran a package in the SSIS catalog, it ended with the dreaded “unexpected termination” message. In such a case,… Read more
I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post I received the award last year, so I have a… Read more
A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the official SQL Server 2016 page currently still links to CTP 2.2).
There isn’t any official documentation out yet describing which features have been added or improved, but thanks… Read more
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime Read more
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today.
Last week (this is a repost, so not actually last… Read more
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon). As sample data, I used the different folders containing the drafts for all the tips I ever wrote. As measures, I have the number of kilobytes and the number of… Read more