About me

I work as SQL Server DBA / Developer and BI Consultant in Toronto, Canada.Canada Flag More...
Vidas Matelis picture


Report Portal

My tweets from SQL PASS Summit 2009 – SSAS, PowerPivot, DAX and more

November 7th, 2009 by Vidas Matelis

I just came back from SQL PASS Summit 2009. About a week before that I started to use Twitter and I tried to “tweet” during the conference as much as I can. My Twitter ID is: http://twitter.com/VidasM. I decided that some of my posts could be interesting to people who do not use Twitter, so I cleaned them up a bit and posted them here.

Read the rest of this entry »

Posted in Gemini, SQL Server 2008 | 3 Comments »

Part 2 – Gemini – how it performs with bigger tables

August 19th, 2009 by Vidas Matelis

Yesterday I posted about my tests working with Gemini and bigger tables. I realized myself and Chris Webb also suggested that my method of generating new records by simply duplicating them probably affected my results. So I ran more tests with different data. Read the rest of this entry »

Posted in Gemini | 1 Comment »

SQL Server 2008R2 Self Service BI – Gemini – how it performs with bigger tables

August 18th, 2009 by Vidas Matelis

Gemini was released about a week ago and I was playing with it almost every evening. I am still trying to understand what it is, how it works, what its limitations are, how to use DAX, etc. And I can say that I like what I see so far. Kasper de Jonge and Chris Webb already posted their initial Gemini reviews. In this post I will share my experience with Gemini so far.

First of all I want to point that for Gemini tests all you need is Excel 2010 and the Gemini Add-in file (it is just about 30MB). You do not need SQL Server 2008R2. I am pointing this out because as I was setting up my testing environment I installed SQL Server 2008R2 and later realized that it is not required. It is quite amazing that this 30MB add in file contains such powerfull software – the Gemini front-end, and the in memory Analysis Services server. Of course for Enterprise level installation you will need SQL Server 2008R2 and Sharepoint 2010, but such setup is not part of my current tests. Read the rest of this entry »

Posted in Gemini | 18 Comments »