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 […]

SSMS templates in SQL Server 2012

There is nothing new about using templates in SSMS. Each time you create let’s say a new stored procedure you use a template like this one They have been around since SQL Server 2000. Where is my template parameters pop-up dialog ? In previous versions of SQL Server you wanted to use the key combination […]

SQL Server 2012 Prometric test available for free…

Only a few days left with this special offer from Prometric. These are the beta prometric tests and they go under the number 71 (not 70). Exam name Promo code Exam 70-461: Querying Microsoft SQL Server 2012 DEN461 Exam 70-462: Administering Microsoft SQL Server 2012 Databases DEN462 Exam 70-463: Implementing a Data Warehouse with Microsoft […]

Access to License file is denied

Today I began installing SQL Server 2012 RTM evaluation edition on one of my Virtual Machines where SQL Server 2012 RC0 was previously installed. I started by removing SQL Server 2012 RC0, restarted the machine and started installing SQL Server 2012 RTM. When the installation started I got this error : This actually points at […]