Category 2012

Using aliases for SharePoint databases

Aliases are good. In fact, aliases are excellent. The purpose of this post is to explain why and how to use aliases when working with SharePoint. This is the second post in the series about building an highly available BI setup. A series that will culminate with Mark Broadbent (B|T) and my preconference at SQL Saturday […]

Extending SSIS With .NET scripting

Earlier this year I got embarked on a book project together with Joost Van Rossum (B|T) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. Namely how to extend the capacity of SSIS with […]

Continuous Deployment of SSIS packages from Visual Studio with TFS

I’ve written a few blog posts about Continuous Integration and database development using Visual Studio 2013 and Team Foundation Server. The posts can be read here. It all culminated when I did a session at SQL Konferenz in Darmstadt last week. My session was really well visited (approx 65 people when the session ended) and […]

SSAS Basic at SQL Saturday 341 Porto

SSAS Basics pre-conference day I have the immense honor and privilege to have been selected to do a whole day of preconference on thursday October 16th at SQL Saturday Porto – Rua Dr. António Bernardino de Almeida. During this whole day of training I will give a thorough introduction to SQL Server Analysis Services together […]

23 days to SQL Saturday Edinburgh BI EDITION

This 14th of June 2014 I am so delighted to go to Edinburgh and speak at SQL Saturday #281 BI Edition. Based on the previous years feedback the SQL Saturday team decided to have a dedicated BI edition. Including session on SQL Server 2014, Big Data Analytics, Business Intelligence, Business Analytics and Data Visualization So I […]

Tweaking your Sharepoint databases ?

Have you ever wondered how to optimize your SharePoint databases ? But you are afraid that any changes will result in loss of support from Microsoft, right ? Well, here is the good news. Some changes are supported (and some are not) Mainly what you are not allowed to do is making changes to the […]

DQS and the structure of unstructured data

In these times of Big Data and getting the best out of unstructured data I thought that I will try to get Data Quality Services to get a hold of unstructured data. I read 2 distinct articles where DQS and unstructured data where mentioned together. The first of them is about data matching policies and […]