# Friday, October 06, 2006

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

by 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.

by 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

by 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.

by 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.

by 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.

by 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.

by 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.
by 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?).

by 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

by 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
# Saturday, June 17, 2006

It seems a number of people are having problems installing this service pack. There are a couple of solutions (here, here and here) that may work. There is also anecdotal evidence that exctacting the files from the SP executable using WinRAR andf running HotFix.exe manually may work.

Alternatively, I have found that the following works for me:

  1. Download the service pack and start the installation by double-clicking the downloaded executable.
  2. Once product enumeration is complete click Next at the Welcome page.
  3. At the End User License Agreement page, check the box to accept the terms and conditions before clicking Next.
  4. Select All Instances, Windows Authentication at the Authentication Mode page and click Next.
  5. Click Install to begin the installation.
  6. During the install you will be told about pending file operations. Click Yes.
    Pendingfileops
  7. A further message appears complaining about processes locking files. At this point, stop the SQL Server Full Text Search service and click Try Again. You may also need to click Try Again additional times depending on what SQL Server processes happen to be running.
    Lockedfiles
by This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Saturday, June 17, 2006 12:01:48 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
# Friday, June 16, 2006
CDM Day Presentation
CDM Day Presentation, originally uploaded to Flickr by James Snape.

We had a customer day this week where we get 50 to 60 customers along and tell them about all the cool stuff being released in the next year or so. Then we go and race around a kart track for a couple of hours. The picture is of me giving my presentation on Office 2007 System and SharePoint. I had a couple of demos on Windows Workflow and Excel Services to show plus some slides on the new XML file formats, Ribbon UI and other enhancements.

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