SQL Server

ARTICLE

SQLIO analysis on Excel charts

I tend to use twitter when I have to notify an interesting link or tool. But sometimes a blog post (even if short) is better, because allows me to easily find it on search engines (Bing/Google/whatever) months or years later. I know PInterest is growing

ARTICLE

Approaching events #mstc11 #ppws #sqlbits

The spring season is always full of events and I’m just preparing for a number of them. First of all, we are getting very good interest for the PowerPivot Workshop in Copenhagen on 21-22 March 2011. Tomorrow (Friday March 4) will be the last day to take

ARTICLE

And sometime Connect works… slowly…

Almost two years ago I wrote a post about the abuse of the “it’s by design” answer Microsoft gives to many bugs. You know, I think that a bug in design produces the same results (if not worst) than a bug in implementation. I also had a long discussion

ARTICLE

SSAS: Reference materialized dimension might produce incorrect results

Reference dimensions let you create a relationship between a measure group and a dimension using an intermediate dimension to act as a bridge between them. In the Adventure Works demo, for example, they are used to link reseller sales and orders to the

ARTICLE

SQLBits 2009

This the second time in a row I will not able to attend to SQLBits – but don’t lose this event if you can go to Manchester on March 28th, 2009. The conference is free, but registration is required. A training day (with a reasonable fee) is also scheduled

ARTICLE

Methodology comparison: Kimball, Inmon and SQLBI

This post is part of a Methodology discussion – other posts will follows. I will be happy to get your feedback! I am proud to announce a public draft of the first paper about the SQLBI Methodology . I and Alberto Ferrari tried to define a consistent methodology

ARTICLE

SSIS: living in a parallel world? Not yet…

Today I come into a nice bug (misfeature?) of SSIS 2008 and I’d like to share it with you. Let’s start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce

ARTICLE

Generate date dimension that support working days calculation

I just wrote a T-SQL query based on CTE that generates support information to calculate working days in a period. Simply look at the WorkingDaySequential measure, which difference between two dates is the number of elapsed working days. In the real world:

ARTICLE

Visio and SQL Extended Properties: a tool to marry them

Visio database models have column descriptions, SQL Server has extended properties where to store them but, even if they share the same producer, it seems that Visio is unable to store column descriptions in extended properties so that other tools can

ARTICLE

SQL: Merge two "history tracking" tables

If you have two columns in a table that “remember” their old values in two different historical tables, as it is the case in AdventureWorks with EmployeePayHistory and EmployeeDepartmentHistory, you may need (or just wonder how) to merge these two tables