Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS 2016, using the Mobile Report Publisher. I created the following query on top of the Wide World Importers data warehouse: SELECT c.[City] ,c.[State Province] ,c.[Country] ,c.[Sales Territory] ,c.[Region] ,c.[Subregion] ,c.[Location] ,[Latitude] = c.[Location].Lat ,[Longitude] = […]
Tag: syndicated
Bigger Fact Table for Wide World Importers
Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary feature) is included but only features you’d actually use, lots of sample scripts are provided and – most importantly – you can generate data until the current date. One small drawback: it’s quite tiny. Especially […]
Webinar – What’s new in SSIS 2016
I’ll be giving a webinar on the new features of Integration Services 2016. When? August 11, 2016 Where? On the MSSQLTips.com website. You can register here. Abstract: SQL Server Integration Services is Microsoft’s leading data integration and transformation tool. In this webcast, we will take a look at which exciting new features SQL Server 2016 has […]
An update on AutoAdjustBufferSize in SSIS 2016
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible. Anyway, one of the particular updates that caught my attention was Adds the adjusted […]
Overview of Published Articles – 2016Q2
Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016: Approval Workflow in SQL Server Master Data Services 2016 using Change Sets – Part 1 Approval Workflow in Master Data Services 2016 using Change Sets – […]
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Onedrive. For the abstract, see the blog post Speaking about Power BI @ ITPROceed 2016.
My first SQL Server 2016 POC
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of course 🙂 One of the first things I noticed, is that installing SQL Server 2016 is quite fast. Installing the database engine, SSIS, SSAS and SSRS is just a matter of minutes. In contrast with […]
Conditional Formatting and Quick Calcs in Power BI Desktop
There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official announcement yet. However, two great new features have been spotted by Chris Webb: @marcorus a few things – quick calculations (only seen % shares) and conditional formatting in tables for example — Christopher Webb (@Technitrain) […]
Reblog: Unexpected result with the File System Task
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies. 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 […]
SSRS and MDX: Think about Cell Properties
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about the cells of the result […]