The latest SQL Server 2008 R2 systems views map poster is available here: 2008 R2 Poster It’s available in a pdf or xps format so have fun with it.   Andy

On the next 20th Semptember I’ll deliver a session on a topic that is IMHO really important but is not yet covered enough: Adaptive BI: Engineering a BI Solution Are you starting to create a BI solution....but where do you begin with? How to setup everything correctly so that you'll be able to handle new features required by the customers ...

Yesterday I had to install PowerPivot on my new machine since I would have liked to use it to process some data, but after having succesfully run the installation package, the PowerPivot menu wasn’t visibile in Excel . Looking in the Event Log for errors I found the following one: Exception: Customization could not be loaded because the ...

PASS Summit 2010 Pre & Post conference are out! This year I’ll deliver the “Creating BI Solution from A to Z” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional modeling and the creation of the Datawarehouse, the implementation of the ETL process with ...

There have been a few releases over the last few days for some SQL Server 2008 tools that you may be interested in. The first one is the 2008 R2 Best Practices Analyzer found here: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/06/19/sql-server-2008-r2-best-practices-analyzer-is-now-available.aspx And the second one is the 2008 R2 ...

After serveral years of development I’ve finally released the first non-beta version of DTLoggedExec! I’m now very confident that the product is stable and solid and has all the feature that are important to have (at least for me). DTLoggedExec 1.0 http://dtloggedexec.codeplex.com/releases/view/44689 Here’s the release notes: FIRST ...

Today I’ve happy started to install SQL Server 2008R2 on my development machine, which has this software installed Windows Server 2008 R2 Standard SQL Server 2008 SP1 CU5 Visual Studio 2008 SP1 BOL October 2009 AdventuresWorks2008 Databases SR4 Visual Studio 2010 RTM So, all the basic standard stuff. SQL Server 2008 R2 ...

I’ve been playing with Master Data Services quite a lot in those last days and I’m also monitoring the web for all available resources on it. Today I’ve found this freshly released sample available on MSDN Code Gallery: SQL Server Master Data Services Employee Sample Model http://code.msdn.microsoft.com/SSMDSEmployeeSample This sample ...

  The additions or changes in SQL Server 2008 R2 are mostly BI related but there is one I just became aware of that serves a more general purpose but at the same time is fundamental in how the storage engine works related to locking.  I won’t rehash (pun intended) what Sunil Agarwal wrote in the below listed blog but in a nut shell they ...