November 2005 Entries

[via Mosha] Writing multiselect friendly MDX calculations Only a couple of weeks ago I was telling someone on the newsgroup that you cannot write multiselect friendly calculations in AS 2000. Well Mosha just published the post above to show how it can be done in AS 2005 using some of the new MDX features. Well worth the read if you are into writing MDX ......

I had a request recently from someone for information on performance of Oracle 10g vs SQL Server 2005. I don't think there is too much around on SQL 2005 yet as it has not been officially released for that long and the Beta and CTP releases were not really meant to be used for benchmarking (in fact I think the license agreements explicitly states that this is not allowed). I can't actually claim credit for this as the topic came up on the SQLDownUnder mailing list a couple of weeks ago and two of ......

Well, I have been trying to register for one of Microsoft's free e-Learning courses for SQL Server 2005 for the last 24 hours. But each time I try to access I get told I need to register and each time I try to register I get the following: There was an error while registering you as a Learner. Please try after some time. I have registered before for other similar courses without any problems, so “after some time” I come back, but still no luck. Darn it! I had set aside some time this ......

[via the Support Alert newsletter] $50 FolderShare Web Service Now Free I've reported favorably about FolderShare in previous issues. It's a web service that allows you to automatically synchronize and/or share files in a given folder across multiple computers. It also allows you access these files from any computer. FolderShare used to offer a cut-down service for free but a full- featured service with unlimited file space and individual files up to 2GB cost $50. Not anymore. FolderShare has just ......

[via Stefan Gossner] You can check out Stefan's post here. There are a few nasty little quirks in there with regard to MCMS SP2. I think I might hang off installing it for a little bit yet. I'm busy playing with AS2k5 in my spare time anyway. I think I feel a psychic moment coming on... yes... I think I see something... SP2a :) Note: This IS NOT official I am just mucking around, but I cannot see MS leaving these sort of issues hanging around for too long ......

This was an announcement up on the website for my local SQL Server user group [via Australian SQL Server User Group] From Lubor Kollar in the SQL MVP forum this morning: Scalable Shared Database (SSD) is ability of SQL Server Enterprise edition to access the same database hosted on SAN from several server instances. It enables scaling read-only workloads by adding additional servers accessing the same database. This feature is available in the currently shipped RTM version of SQL Server 2005. The ......

[via Chris Webb] The other day I was looking for the OLE DB for OLAP v9.0 Provider to install on a client machine but couldn't find it on the AS2005 install CD (which is where it was in the June CTP, and where you got PTS for AS2000); I then found a newsgroup post stating that it was only going to be available as a separate download from now on. Here's where you can now get it and other useful stuff like ADOMD.Net, the latest PTS for AS2000, various other OLE DB providers etc: http://www.microsoft.com/do... ......

I have been to a couple of events in the last few weeks and have been a bit slack in getting information up here about them. I went to the SQL Server User Group meeting in Melbourne and heard a talk from Itzik Ben-Gan from Solid Quality Learning about uses for row numbers and specifically how the new Row Number function in SQL 2005 makes these techniques a whole lot easier to implement. The one standout demo for me was where he showed how you can use row numbers to calculate median values, with just ......

If you are at all involved with Microsoft CMS, you have probably heard of Stefan Gossner. For the uninitiated, he is the guru of all things CMS, he is a Microsoft escalation engineer and he pretty much “owns” the cms new group. In fact I think they could rename the group from microsoft.public.cmserver.g... to microsoft.public.cmserver.a... :) He has just published a number of informative posts on his blog, here is a list of the recent ones worth checking out mainly focusing around ......

News

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.