I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features in Reporting Services 2016. SQL Server Reporting Services is Microsoft’s corporate reporting tool. The SQL Server 2016 release marks one of the biggest evolutions of the product since it’s initial release. In this […]
Power BI Desktop hosted on premises with SSRS 2016
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the SSRS Team blog. You can also find my first impressions of the preview in the blog post First thoughts on Power BI on premises. UPDATE 2017-05-08: you can find more information about the Power BI on […]
SSRS Mobile Reports – JSON error
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] = […]
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) […]