November 2005 Entries

Writing multiselect friendly MDX calculations
[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 ......

Posted On Tuesday, November 22, 2005 1:53 PM | Comments (0)

Oracle 10g vs SQL Server 2005
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 ......

Posted On Monday, November 21, 2005 1:34 PM | Comments (13)

Trying to register for a Microsoft e-Learning course.
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 ......

Posted On Saturday, November 19, 2005 4:57 PM | Comments (5)

Microsoft buys Foldershare
[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 ......

Posted On Friday, November 18, 2005 1:06 PM | Comments (3)

There are a few kinks in MCMS SP2
[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 ......

Posted On Friday, November 18, 2005 12:13 PM | Comments (3)

SQL Server Management Studio Express November CTP is available
This was another announcement up on the website for my local SQL Server user group - cool :) [via Australian SQL Server User Group] Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances. SSMSE can also manage relational engine instances created by any edition of SQL Server 2005. SSMSE cannot manage Analysis Services, Integration Services, SQL Server 2005 Mobile Edition, Notification Services, ......

Posted On Tuesday, November 15, 2005 11:56 AM | Comments (1)

Microsoft have dropped a late-breaking but exciting new feature into SQL Server 2005 - "Scalable Shared Databases"!
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 ......

Posted On Tuesday, November 15, 2005 11:54 AM | Comments (0)

Feature Pack for Microsoft SQL Server 2005 - November 2005
Today the goodness just keeps on coming. I just read a post from Dave Wickert on the Olap newsgroup about the newly released feature pack for SQL Server 2005. It contains all the following goodies. Microsoft ADOMD.NET (x86, x64, ia64) Microsoft Core XML Services (MSXML) 6.0 Microsoft OLEDB Provider for DB2 (x86) Microsoft Operations Manager 2005 Management Pack for Microsoft SQL Server 2005 (coming soon) Microsoft SQL Server 2000 PivotTable Services (x86) Microsoft SQL Server 2000 DTS Designer Components ......

Posted On Friday, November 11, 2005 1:06 PM | Comments (0)

Where to get the OLE DB for OLAP v9.0 Provider
[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... ......

Posted On Friday, November 11, 2005 9:18 AM | Comments (0)

Recent SQL 2005 Events in Melbourne
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 ......

Posted On Friday, November 11, 2005 7:07 AM | Comments (1)

CMS SP2 information - More Gems from Stefan
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 ......

Posted On Friday, November 11, 2005 6:18 AM | Comments (3)

Online Training for SQL 2005

Some of us on the SQLDownUnder mailing list are booked in to do some of the Beta certification exams for SQL 2005. There was a post today from one of the guys about some free online training courses at http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx which looks interesting.

Now I just need to find an extra couple of hours in my day :)

Posted On Thursday, November 3, 2005 7:42 AM | Comments (2)