Recently I was developing a SQL Server Analysis Server cube using Oracle as a data source. Weirdly the the development environment (BI Dev Studio) could see the Oracle schema & let me explore the data. But when I tried to process the cube or one of its dimensions, it died indicating that I...

Action Please consider taking this 1 page survey. & give your feedback to this team. http://survey.constantcontact.com/survey/a07e2shn6xwg6n3fotc/start Why? Recently a number of the Microsoft Data Mining folks decided to start up their own company Predixion Software . This includes two of the 3 authors...

Following on from my review of my library. This week, Programming Microsoft SQL Server 2008. Summary: It appears to me that the authors started this book with the premise “There is a lot in SQL2008 that can dramatically change the way you architect solutions. Many features elegantly remove some of the...

This post is a pointer to a lot of in-depth training on SQL 2008. It includes Virtual PC’s with Demo Scripts, Lab Exercises & a lot of PowerPoint's with notes. To get access to it all click here SQL Server 2008 Training . It is free but you do need to register as helps us to cost justify developing...

Recently I’ve been flying around Australia delivering a 90 min seminar called Boost your BottomLine with SQL Server BI. This post is purely to make the Slides available for the audience. The audience was predominantly technical managers & architects in companies who owned SQL Server. The goal was...