# Monday, October 16, 2006

I celebrated my 35th birthday at the weekend with dinner at  The Club Bar & Dining in London. Interesting place but I expect we may see it appear in the next series of Ramsay's Kitchen Nightmares. We waited forever to get our food; items we ordered were "out" when the meal arrived and had to be swapped for other choices; the food was cold and we were even told that the chef had burned the potato gratin which had to be swapped for fries. Our complaints, alas, fell on deaf ears and we didn't even get one of the many bottles of wine (which was the only item available for most of the meal) knocked off the bill. The music volume was such that you could hardly talk to the person next to you. The place has only been open for a couple of months so I hope they get things sorted or it could be a short life for them.

Despite the above, it was really nice to see everyone and I had a really great time. Thank you too for the gifts.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Monday, October 16, 2006 8:56:34 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Monday, October 09, 2006

It's not immediately obvious but after spending half an hour trying to get my laptop to display Aero Glass instead of the opaque Aero theme I finally discovered that Glass is automatically turned off whilst using the Power Saver power plan. If you got to "Window Color and Appearance" and the "Enable Transparency" checkbox won't stay selected, check your current power plan.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Monday, October 09, 2006 9:13:37 AM (GMT Daylight Time, UTC+01:00)  #    Comments [2] Trackback
# Friday, October 06, 2006

Trackbacks are disabled whilst I figure out a way to stop the !***!!! spammers.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Friday, October 06, 2006 12:00:58 AM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Monday, October 02, 2006

Abamar BeachClaire and I have just returned from two weeks in Sardinia at the Mark Warner Abamar resort. It's been a while since I have had a summer holiday abroad and this was a welcome break from work. We had a fantastic beach, sailing, windsurfing and I learned to scuba dive too. For those that wanted there was tennis, water polo, aerobics and spa facilities.

More on the scuba in a later post but in the meantime I have uploaded all the pictures to Flickr.

The hotel was full board and the food was excellent but we did manage to leave the resort a couple of times to visit the local area. Pula is quite a small town with not much around. However, Cagliari (the capital city) is much larger. The bars up in the old city are great for a sundowner.

If you like a beach holiday with plenty of optional activity then this is a great holiday to have. Also, if you are single then this looks to be a great place to meet people as there were quite a few who had come on their own.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Monday, October 02, 2006 11:06:36 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Monday, September 11, 2006

Jools Holland and The Rhythm And Blues Orchestra, Groove Armada, Brazilian carnival dancers, Mexican buffet, champagne, free bar, chill-out zone and 2000 people all under a massive circus big top at Stratfield Saye. The event was awesome and a really cool plus for working at Microsoft. Hopefully the pictures below can give a sense of what it was like. Sorry for the quality though - they were taken from my Smartphone.

Jools Holland Groove Armada , the crowd Groove Armada, 'At The River' Groove Armada

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Monday, September 11, 2006 8:02:39 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Sunday, August 27, 2006
A room at the Lowry hotel
A room at the Lowry hotel, originally uploaded to Flickr by James Snape.

Much better than the one from a few weeks ago.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Sunday, August 27, 2006 8:19:25 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Saturday, August 26, 2006

Because of the way you assign FullTrust permissions to an InfoPath form, the correct permissions are not assigned when running the form under the Visual Studio debugger. You might see errors such as "That assembly does not allow partially trusted callers". The solution is to use a macro that ships in the InfoPath 2003 Toolkit called IPFullTrust. See the macro page for more detail.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Saturday, August 26, 2006 11:03:19 AM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Thursday, August 10, 2006

In addition to RSS, I've also added email distribution to the site. If you read via a feed reader then please carry on as normal. But...

...if you don't know what RSS is and would prefer to have these posts sent via e-mail instead then either click the orange "email readers" button on the right or go directly to the sign-up page.

This is a spam free opt-in newsletter service and you can even keep your e-mail address hidden from me. Any further questions can best be answered by FeedBlitz themselves.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Thursday, August 10, 2006 10:00:10 AM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Saturday, July 29, 2006

It is possible to use report models as a report data source from within Business Intelligence Development Studio (BIDS) although you have to jump through a few hoops to make it happen.

The connection string to use is:

server=<report server url>;datasource=<path to report model>;

e.g.

server=http://localhost/reportserver;datasource=/Report Models/Adventure Works DW;

Note that the connection string has two components that must be specified and neither component uses quotes around the values. You can then use the Report Model query designer.

This is all you need for SQL Server models but those using Analysis Services cubes require a bit of hacking because the Visual Studio version of the report model designer doesn't automatically specify a perspective and the query will fail without one. There isn't a user interface mechanism for doing it so you need to manually add a custom property to the query definition. The easiest way of doing this is to design a report using Report Builder and extracting the definition from the query that it generates. The bit to look out for in the query XML is:

<CustomProperties>
  <CustomProperty Name="qd:PerspectiveID">
    <Value xsi:type="xsd:string">
      http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:
        Perspective_Cube_Adventure_Works</Value>
 </CustomProperty>
</CustomProperties>

Note that the <Value> field should not have any newlines in it and the query XML is actually embedded and not part of the RDL schema to the text above needs escaping (< becomes &lt; etc). The best way to create these reports is with the report wizard as the query text is displayed on its own before being put into the RDL. Then you can merge the perspective without having to escape it.

Using this mechanism you can edit any report created by Report Builder. Just open the report in BIDS and replace the connection with a Report Model data source. One thing you can't easily do is round trip from reports created in BIDS to Report Builder because much of the metadata that Report Builder needs is missing. Still, it's useful to be able to create a large number of basic reports using the builder and then finish those that need it in BIDS.

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Saturday, July 29, 2006 4:34:01 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Thursday, July 27, 2006
This is the third update since release and contains both new and updated material. See "New and Updated Books Online Topics" for details. Get it the update here.
This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Thursday, July 27, 2006 5:10:07 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Monday, July 17, 2006

Some links to keep:

The last one should be of particular interest to anyone doing multi-tenanted systems (Doug?).

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Monday, July 17, 2006 3:16:24 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Friday, July 14, 2006

If you want to get up to speed with Analysis Services 2005 then the following resources may be of use:

Learning MDX Books

The first book, Fast Track to MDX, is an excellent starter and learning guide. The second, MDX Solutions, contains much more advanced topics.

Analysis Server 2005 Books

The first book is a beginner reference and guide to Analysis Services. The second, Applied Microsoft Analysis Services 2005 provides a more BI focused approach that integrates reporting and analytics. The final book is probably the best as it is very detailed and provides guidance in relation to the Kimball method to creating data warehouses.

Project REAL

Project REAL is a best practices implementation for creating BI applications based on SQL Server 2005.

Webcasts and Online Learning

Kimball Webcasts on Data Warehousing and Business Intelligence
Course 2942: New Features of Microsoft® SQL Server™ 2005 Analysis Services
Course 2943: Updating Your Data ETL Skills to Microsoft® SQL Server™ 2005 Integration Services
Course 2944: Updating Your Reporting Skills to Microsoft® SQL Server™ 2005 Reporting Services

Web Sites and Forums

Analysis Services Homepage
Microsoft Business Intelligence Homepage
Business Intelligence Developer Center at MSDN
Analysis Services MSDN Forum
Reporting Services MSDN Forum

This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Friday, July 14, 2006 1:29:46 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback