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 […]
Category: SQL Server
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 – […]
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 […]
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS. I stumbled upon this MSDN blog post: SQL Server 2016 SSIS Data Flow Buffer […]
Overview of Published Articles – 2016Q1
Here is an overview of the articles I published in the first quarter of 2016. R Services series: SQL Server 2016 R Services: Executing R code in SQL Server SQL Server 2016 R Services: Display R plots in Reporting Services SSIS & AlwaysEncrypted: Reading Always Encrypted Data with SQL Server Integration Services 2016 Writing Always Encrypted […]
SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing packages to this project. So you can right-click the SSIS Packages node and choose Add Existing Package. In the dialog, you choose the File System. All you now have to do is choose the package […]
Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is a fancy term for a live connection to an SSAS cube or model. Anyway, great news, as it drastically improved usability of Power BI Desktop when browsing cubes. On the same day, I also found […]
Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS: 515: A database error has occurred. Please contact your system administrator Too bad I am the system administrator on that machine… Anyway, after some searching it came out the MDS stored procedure […]
Reblog: SSIS Performance Testing
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in a blog post. First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package took to finish. This can probably […]