Author Archives: regbac

Changing SSRS 2016 user display language

Working in a Swiss company where German is the language of predilection for formatting numbers, dates and currency I was having a hard time understanding what SSRS 2016 was trying to tell me on the displays of it’s menus and options. Words like Paginierter Bericht don’t really mean much to me and trying to understand […]

SQL Saturday 541 – IV

This September, for the 4th year in a row SQL Saturday is coming to Copenhagen. This year on September 17th, we are moving to a new venue but with an old friend of the event. Microsoft new HQ in Lyngby, north of Copenhagen. This year again, we are offering a full day of free learning, […]

Speaking at SQL Saturday #526 Rochester

This year, I decided to cut down on the number of SQL Saturdays I would attend, SQL Saturday #526 Rochester is one of the few I submitted to and I was so delighted to get selected. I will present 2 sessions at the event on May 14th. I haven’t been upstate New York since 1986 […]

The date demands it or does it?

Quite a while since I’ve been writing…a lot of water under the bridge and a demanding yet rewarding job in Zurich are some of my excuses. This is not a post about : SQL Server written in Javascript, Linus Torvald joining Microsoft or even IT companies investing massively in handwritten procedures, or even Microsoft acquiring […]

Speaking at SQL Konferenz 2016

This year again, I’ve been selected as a speaker for the SQL Konferenz in Darmstadt. The conference is a 3 days event organised by PASS Deutschland running from Febraury 23rd to February 25th. I will present on the second day about the crazy idea of clustering SQL Server Integration Services. Why (or why not) one […]

Connecting SQL Server Mobile Report Publisher

This post is meant as a mental note for not having to struggle with the problem again another time…. Some weeks ago I downloaded and Installed SQL Server 2016 CTP 3.2 and now I want to try the new Reporting Services Experience – with the Datazen part now almost fully integrated to Reporting Services. For […]

SharePoint 2016 – Office Online Server – Error : This product requires Microsoft .Net framework 4.5

I am installing SharePoint 2016 together with PowerPivot and Power View for SQL Server 2016 and I have a 3 servers Hyper-V environment running locally: A domain controller (with a tabular instance of SSAS 2014) A SharePoint 2016 single server farm A SQL Server 2016 CTP 3.1 running the database engine and the tabular instance […]

Dynamic Data Flow using COZYROC component Part II

In the previous post, I explained the problem and the envisaged solution using COZYROC Data flow plus component. This post is the continuation of the required setup for using dynamic data source without the need of knowing its metadata ahead of time. In the foreach loop container that which loop over the data definitions there […]

Dynamic Data Flow using Cozyroc component part I

This is in fact a double double post. Double because it is composed of 2 parts and double because I am writing about two things today: 1 – Open Live Writer (OLW) – The open source version of Windows Live Writer – can be downloaded from there 2 – Cozyroc great SSIS components who had […]

Speaking at SQL Saturday Slovenia #460

This Saturday, I will be back in wonderful Ljubljana to present a session about a new feature from SQL Server 2016 and Azure SQL Database : Always encrypted. It is the first time I am doing this session and I plan on doing mostly demos, which I am quite excited about. I’ve been benchmarking the […]