A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in my blog post How I prepared myself for the MCSE certification. As you might know, this certification is only valid for 3 years. My certification should have expired a couple of months ago, but […]
Overview of Published Articles – 2016Q3
Here is an overview of the articles I published in the third quarter of 2016. What’s New in SQL Server Integration Services 2016 – Part 1 What’s New in Integration Services 2016 – Part 2 Installing new SQL Server sample databases: WideWorldImporters Install SQL Server 2016 Sample Database: Wide World Importers Data Warehouse Generate more data […]
Upcoming Webinars: What’s New in SSRS and MDS 2016
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.