Sparks from the Anvil - All Comments

re: MDX + T-SQL: Combining relational and multi-dimensional data into one query result set

gireeshda — Tue, 02 Jun 2009 08:19:54 GMT

This is exactly the stuff which I have been looking for.

Thanks

Gireesh

SSAS 2008 Deployment: The connection either timed out or was lost

Rob Kerr's BI Blog — Thu, 16 Apr 2009 06:41:49 GMT

SSAS 2008 Deployment: The connection either timed out or was lost

re: Goodbye Vista: Installing Windows Server 2008 on a Dell XPS laptop

DrJohn — Thu, 09 Apr 2009 09:05:56 GMT

When I originally did the upgrade to Windows Server 2008, only 32-bit driver were available from Dell. Recently I noticed that they had released 64-bit drivers, so I did the upgrade to 64-bit. I would have added more memory at the time, but at £550 for two 4GB chips, it was a step too far!!

I have not installed Hyper-V as all my projects are using SQL 2008 / VS2008. I probably will as soon as I have a requirement for a alternative virtual machine.

I found many apps are now available in 64-bit (e.g. iTunes) or the 32-bit version works fine. This is not the case for any security software though. The 32-bit version of a VPN package just fell over in a heap on the 64-bit machine. So I will have to wait until they supply a 64-bit version.

The only downside (or bonus, depending upon your age) of moving to 64-bit is that there is no MSN Messenger for 64-bit. From my point of view, this is great as my laptop does not get pinched any more by my teenage daughter!

re: SSAS: Kerberos kills ‘large’ MDX queries on Windows Server 2008

Reeves — Wed, 08 Apr 2009 15:44:37 GMT

Great post, thanks for the info.

Thanks,

Reeves

Denver, CO

re: Goodbye Vista: Installing Windows Server 2008 on a Dell XPS laptop

Reeves — Wed, 08 Apr 2009 15:40:14 GMT

Great post as I am just about to do the same thing on my XPS M12010 and was wondering about drivers. So did you install the 32 bit or 64 bit version of Windows Server 2008 and are you using Hyper-V?

Thanks,

Reeves

Denver, CO

‘help getting mobile internet for dell xps m1530′ | Digg hot tags

‘help getting mobile internet for dell xps m1530′ | Digg hot tags — Fri, 19 Dec 2008 02:20:21 GMT

Pingback from ‘help getting mobile internet for dell xps m1530′ | Digg hot tags

re: MDX + T-SQL: Combining relational and multi-dimensional data into one query result set

cavo789 — Mon, 17 Nov 2008 15:58:46 GMT

Exactly what I was searching for. Thank you so much for your sharing.

re: Goodbye Vista: Installing Windows Server 2008 on a Dell XPS laptop

ZenTrickz — Fri, 03 Oct 2008 08:33:52 GMT

I actually just joined this community now to leave you a message on this blog.

I'm a newly graduated computer scientist that just wanted to thank you for such an informative blog. I've just started to really dig my heals into my first monolithic software engineering project using Microsoft’s newest line of technologies. Your little pet project has indirectly answered a slew of application compatibility questions that I have had grave concerns with Windows Server 2008. Thanks.

Salutations from Canada,

Peter

re: SSAS: Working with date and time measures to calculate average elapse time

N.Assendelft — Mon, 16 Jun 2008 13:05:41 GMT

I'm searching for the code to display hours, minutes and seconds. Just 'hh:mm:ss' doesn't work, because if the duration (for example) is 45 hours, then 21:00:00 is shown. That's because the first 24 hours aren't displayed.

So do you perhaps have the code to display for example 45 hours as 45:00:00?

re: The FACT is that it is not so DIM after all

DrJohn — Fri, 02 May 2008 10:20:45 GMT

Thanks Piotr, I am a great fan of prefixes and acurate naming. Using a seperate schema for the cube is a great idea and exactly what I initially proposed. However, the dev team are using CodeSmith to generate their code and they tell me the tool only supports the dbo schema. Clearly my views should affect thier work, but they insisted on a single schema. Shame.

re: The FACT is that it is not so DIM after all

Piotr Rodak — Tue, 22 Apr 2008 10:09:42 GMT

So, you discovered 'hungarian' notation for databases? ;)

This is what many people flame about, and I still find it easier to organize objects if they have meaningful prefixes. Oldskul you may call it.:)

I think that using separate schema for the interface might be also a good idea.

Regards

Piotr

re: Getting a list of files from a MOSS document library using a SharePoint web service

reskatze — Mon, 07 Apr 2008 17:39:03 GMT

Thanks for this blog.

One question:

How do I get the names of the (recursive) folders?

SSIS: Calling SharePoint web services from the data flow

Sparks from the Anvil — Sun, 09 Dec 2007 17:45:19 GMT

In my previous post , I outlined how to call a SharePoint web service to obtain a list of all Excel files

SSIS: Calling SharePoint web services from the data flow

Sparks from the Anvil — Sun, 09 Dec 2007 17:45:17 GMT

In my previous post , I outlined how to call a SharePoint web service to obtain a list of all Excel files

re: SSAS: Working with date and time measures to calculate average elapse time

anandbisht — Thu, 06 Dec 2007 11:44:34 GMT

It's really hard to find tricky information when needed most and it's great to see some one is helping and sharing such useful information. Thanks to Dr. John.

I tried your solution and its works great, your earlier BI implementation been inspired to implement BI for SSC. Also the excel package example was great I have re-created package to suit with multiple template and style based on user input.

rgd/-