-
Today I wrote a procedure to drop all views from a schema (and the schema itself) in SQL Server 2005. I use views to expose objects to SSAS DSV and it's useful having a cleanup code. Here's the script: DropSchema drop all the views and the schema itself, Read more
-
The short answer is yes. The long answer is that Microsoft should still improve in many ways. I thought about this many times before writing this post, because I want to be constructive and I hope that my words will not be misunderstood. My consideration Read more
-
BIDS Helper is an addin for Visual Studio that really improves productivity developing solutions for Analysis Services. Today I tested it and looking for its feature I encountered a page describing the "Show Extra Properties" feature... and it links a Read more
-
I and Alberto have posted a suggestion on Microsoft Connect to improve aggregation wizard behavior in a future version of SQL Server. The idea is to give an aggregation usage priority to dimension attributes for each cube or measure group. If you find Read more
-
David Shroyer published an interesting paper about a Different Approach to Implementing Time Calculations in SSAS . It is something I would have found the time to write since Analysis Services 2000 (I have being using a similar approach since then) and Read more
-
During the Microsoft Business Intelligence Conference 2007 we distributed a free printed copy of The Many-to-Many Revolution to attendees who visited our booth. Now the same book can be ordered on Lulu.com paying only the print and shipping costs (we Read more
-
The Microsoft Business Intelligence Conference 2007 has been a good conference. Not very good, probably as a result of its success. Microsoft wanted to send the message "we are serious in the BI market" with this event. From my perception, half of attendees Read more
-
Now that our presence as exhibitor is finished (Day 3 is only for keynote and breakout sessions), we can say that we had a great success! We distributed all the 300 copies of The Many-to-Many Revolution paper we printed just to show the kind of content Read more
-
The first Microsoft BI Conference started today and we received a lot of people at our booth. Thank you to all the people who came to visit us! Read more
-
Usually I blog about Business Intelligence, but BI is not the only field I work on. I born as developer and I recently co-authored a book about LINQ with Paolo: the title is Introducing Microsoft LINQ , we created a dedicated site where you can find blog Read more