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,...
2016-07-27
2,886 reads
Koen Verbeeck
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...
2016-07-22
480 reads
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Docs.com. For the abstract, see the blog post Speaking about Power...
2016-06-28
531 reads
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...
2016-06-14 (first published: 2016-06-09)
4,733 reads
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...
2016-06-07 (first published: 2016-05-31)
2,744 reads
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...
2016-06-03 (first published: 2016-05-24)
1,177 reads
Speaking about Power BI @ ITPROceed 2016
I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this...
2016-05-19
484 reads
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...
2016-05-04
553 reads
Dynamic Security in Power BI
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.
In...
2016-04-28
2,801 reads
Power BI Service error: “This visual has unrecognized fields”
Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power...
2016-05-03 (first published: 2016-04-22)
2,543 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers