CozyRoc announces the release of the SSIS+ 1.6 Beta 1 Library. I installed this on my SQL Server 2012 RC virtual machine and have started testing. So far, I like it! :{>

(As with all of these types of posts, check the date of the latest update I’ve made here. Anything older than 6 months is probably out of date, given the speed with which we release new features into Windows and SQL Azure) I don’t normally like to discuss things in terms of tools. I find that whenever you start with a given tool (or ...

A new term - well, perhaps not that new - has come up and I’m actually very excited about it. The term is Data Scientist, and since it’s new, it’s fairly undefined. I’ll explain what I think it means, and why I’m excited about it. In general, I’ve found the term deals at its most basic with analyzing data. Of course, we all do that, and the term ...

Last week Microsoft announced a new licensing schema for SQL Server 2012. If you are interested in an extensive discussion of the new licensing scheme, Denny Cherry wrote a great blog post about that. I’d like to comment about the new BI Edition license. Teo Lachev already commented about the numbers and I agree with him. I generally like the ...

Just reading from all posts and tweets it’s quite clear that this year’s PASS has been a great success. Despite of the bad cold that I had from Monday , I’ve enjoyed it at lot. All the parties, the friends, the community and the great content make PASS an appointment one that should not to be missed. I’ve also enjoyed a lot delivering “Temporal ...

I’m very happy to announce that my proposal for the Spotlight session I’ve been invited to deliver at PASS 2011 has been accepted! Temporal Snapshot Fact Table You are designing a BI Solution and your customer ask you to keep a snapshot of the status of all their documents (orders, insurances, contracts, bills...whatever the word ...

During TechEd 2011, Microsoft announced an important update to its BI roadmap. The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit 2010 the announcement regarding the next version of SQL Server, codenamed ''Denali'', ...

I’ve just released on SkyDrive (http://bit.ly/ghPeaa) all the demo material I’ve used in my BI Workshop at the PASS Summit. The zip file also contains the DLPC tool and the latest revision of the slide deck (only some minor syntax errors corrected). As the related “Readme.txt” file says, the zip file is protected with a password. The password is ...

I’ve returned from PASS 2010 on late sunday and yesterday I spent pretty much of the time just catching up with all the ongoing projects. I’ll probably need some more days on this, but for the beginning of the next week I’ll be able to answer all the email received that concerns PASS Summit  and also put online the latest updated demos so ...

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...