Claus on Code

A data dudes random musings about code, bugs, products, life etc.

  • How to create sql azure login and user

    I use sql azure databases a lot. Both as backend, datamarts and also for data exchange layer with 3. parties. For that, I need to create users fast and easy. There is no interface for doing that in SQL azure, so you have to do it with SQL. Step 1: Connect to sql with manegement… Continue reading

  • How to: Change the length of an attribute in MS MDS

    You would think that it would be easy to change the length of an attribute in MDS, but going to the webinterface might make you think otherwise.   The length parameter is greyed out. But fear not. Instead open the table with your excel plugin Click on the column you want to change, click attribute properties,… Continue reading

  • A quick look at System-Versioned Tables in SQL server 2016

    SQL server 2016 has been available for preview for some time now. One of the more exiting features I am looking forward to is system versioned tables. As a DWH developer, one of the things, you spent a lot of time with, is developing dimension tables with columns that stores history. The history is typically… Continue reading

  • Doing Windows development on my android tablet with Azure

    The scenario: So, I’m on the run, to a family party, a boring meeting, or something similar 🙂 Suddenly, I get this great idea for the BI project I’m working on. I didn’t bring my monster laptop, because it is to heavy & ugly. Instead I’m sitting with my android tablet. What to do now???… Continue reading

  • GOTO day 3 – Keynote: “How to become accomplished”

    Seriousely, the keynotes at GOTO are really good this year. Today was by Chad Fowler. It was about, as the title says, how to become accomplished. To me, Chad Fowler is like a motivational speaker for programmers, and he is really really good.  In short, you are going to spend a lot of your life… Continue reading

  • Funday Monday: Day 1 at GOTO

    So today was day 1 at the GOTO conference. Today none of the tracks related directly to what I work with daily, so I think I was around almost all the tracks for different sessions. Solving Real and Big (Data) Problems Using Hadoop So the first session actually was the only one, that related a… Continue reading

  • My GOTO program

    I have not completely decided on my GOTO program yet, but here is a list of some of the sessions I’m looking forward to 🙂  Some of them are at the same time, so I really hope that they will be available on VOD afterwards. Don’t be religious about the Internet of Things! As an… Continue reading

  • Attending GOTO as a Business intelligence developer

    Back in my .NET developer days, like 100 years or so ago, I went to my first GOTO conference(Or JAOO as it was called back then). Back then, I loved .NET and anything that related to it, but that wasn’t the reason I went to GOTO. If I wanted to know more about the changes… Continue reading

  • Error code: 0x80040E21 Reading from SSAS with SSIS

    So, I upgraded a big project for a customer to 2012 from 2008R2. Everything worked fine, except the last part, where some datamarts was loaded with SSIS from SSAS. They had worked with no problem before, but suddenly, I received the above error code. It made no sense to me, and it was hard to… Continue reading