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 […]
Tag: sql 2016
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a separate installation. You heard that right (read, probably), no more dragging along those bulky .ISO files with the entire SQL Server set-up just to install some client tools. Just like SSDT, you can now just […]
Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015: Integrated Logging with the Integration Services Package Log Providers SQL Server Integration Services Best Practices and Tuning Tips Webcast Q&A Retrieve Error Column in SSIS 2016 Customize the SQL Server Reporting Services 2016 Parameter Pane SQL Server Integration Services 2016 Control […]
Reporting Services redesign – it’s the little things
SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing: new look ‘n feel for Report Builder: Report Builder Changes in SQL Server 2016 new chart types (check out my sunburst, treemap and heatmap articles) a (somewhat) customizable parameter pane HTML 5 support and many, many […]
What’s new for BI in SQL 2016 – Session materials
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too many to mention, and I saw some interesting sessions. My favorites were David’s session about loading data faster and Catherine’s session about BIML (yes, both are related to SSIS). I gave a session on the new […]
New SSRS features in SQL 2016 CTP 2.4
SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager at Microsoft because some of the MSDN documentation pages are already updated. One of those pages is What’s New in Reporting Services. There we can see three new features will be added: PDF replaces ActiveX […]
MDS 2016 CTP 2.3: tiles greyed out in Manager
I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI in SQL Server 2016. I uploaded the sample models into MDS and I opened up Master Data Manager in Internet Explorer to try out some of the new features. The Manager has received a make-over […]
SSIS – Unexpected Termination
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime I ran a package in the SSIS catalog, it ended with the dreaded “unexpected termination” message. In such a case, nothing is logged to the catalog, so […]
Speaking at SQL Server Days 2015
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The SQL Server Days is the largest SQL Server conference in the Benelux (and maybe beyond :)) and is hosted by sqlug.be. It will be great to see the #sqlfamily again. A lot of amazing speakers […]