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 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, ......
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 ......
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 ......
[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 ......

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 :)

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP


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.

Subscribe in Bloglines Subscribe in NewsGator Online

Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: