Tuesday, October 28, 2008

Problems connecting to SSAS 2005 from Excel 2003

Today I was trying to connect to SSAS 2005 cube from Excel 2003 and I was not able to do so using the exisitng OLAP 8.0.

I had to download the folowing to resolve the problem.

1. Microsoft Core XML Services (MSXML) 6.0 SP1
2. Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

I have followed the article on Microsoft downloads http://support.microsoft.com/kb/940167

and that solved my problem !

Friday, August 29, 2008

Internal Domain Redirects with ASP.net and C# (C-sharp)

An extremely useful article explaining how to issue internal domain redirects in ASP.net, through modifying global.asax.

read more |

Sunday, August 24, 2008

Terminate User processes in SQL Server

This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.

read more |

Monday, August 18, 2008

Custom Error Handling in ASP.net C# (C-Sharp)

An article offering a nice solution on how to properly set up custom error handling in ASP.net.

read more |

Thursday, August 14, 2008

CopyFileEx With Progress Callback in 20C

This article will show you how to call unmanaged DLL functions from C#. It will specifically walk through how to call CopyFileEx with a callback to report progress.

read more |

Monday, August 04, 2008

Flash vs Silverlight: Laser Orbit

A stunning effect with a laser orbiting around the mouse! In this example, it demonstrated the difference in dispatching Event between AS3 and C#.It included both Flash and Silverlight versions with complete source codes.

read more |

Wednesday, July 16, 2008

Creating 3D and 2D Interactive Web Content

Learn and read more about this 3D platform, that is web-based (supports most common browsers)!

read more |

Sunday, July 06, 2008

Collections of Internet Resources for Software Developers

As a software developer, you need to constantly update your knowledge on new software technologies and new career opportunities for your own career development. This requires you spending time on search and find information on software technologies and career opportunities. This collection of Internet resources will help your to locate the informat

read more |

Monday, June 30, 2008

How To Watch YouTube Videos In High Quality

The technique to view youtube videos in higher quality is extremley simple and can be applied to any youtube video, it will however only work directly on the youtube website and only for some videos reportedly all after 2006.

read more |

Friday, May 30, 2008

Flash Quiz - Create your own free quiz

Want to create a quiz for your website but don't have the skills? This free software lets you quickly create and customise your very own multiple choice quiz. Just download the software and use the step-by-step wizard.

read more |

Friday, May 23, 2008

Grade your website

Website Grader is a free tool that measures the marketing effectiveness of a web site. The tool provides a score that incorporates elements such as web site traffic, SEO, social popularity, and other technical factors. This is a great tool when it comes to gaining an idea about what's working well and what could be improved on your site.

Wednesday, May 21, 2008

Scheduling a SSAS backup on SQL Server 2005

Today I had a requirement to schedule a backup on SQL Server Analysis Services. Here is the link that I found very useful for me. SSIS package to backup SSAS databases

Tuesday, May 20, 2008

Copying records from database into another -- SQL

I had this requirement today where I had to copy from a table in one database into a similar table in another database.

the code I have used in

[code]
insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx
[/code]

where xxxx is the criteria that you need to add.

Precautions you have to tak before you do this.

Backup the database into which you are copying the record so that you can restore if something goes wrong.
Copy contents when there are no other transactions being entered into the database1

Sunday, May 11, 2008

Amazing Free Website Template, Table less Website

Free table less or div template of Website Brewers... Cool website layouts with psd files, ie6 and firefox compatible. Ready to used to CMS template such as Wordpress or Joomla. Other templates includes Flash Slideshow and FLA File. You can also used on static pages... CSS Style Sheet have description and comments. The images are optimize by 80%.

read more |

Saturday, May 03, 2008

20+ Ways to Make Money Creating Online Cartoons

Various methods of using animation to make money, a few I am sure you expect and perhaps a couple you haven’t yet considered.

read more |

Thursday, April 24, 2008

Mastering Visual C# .NET

Mastering Visual C# .NET is the best resource for getting everything you can out of the new C# language and the .NET Framework. You'll master C# language essentials, quickly taking advantage of the many improvements it offers over C++ and see tons of examples that show you all the ways that .NET can make your programming more efficient !I have already downloaded it.

read more |

Wednesday, April 23, 2008

XML in 10 points

If you are new to XML, it may be hard to know where to begin. This summary in 10 points attempts to capture enough of the basic concepts to enable a beginner to see the forest through the trees.

read more |

Monday, April 14, 2008

Open Book Tutorial

In ten simple steps, this tutorial teaches you how to design a simple but an effect open book design that can be used either for your flash autobiography or as a splash page for your website. This tutorial can even be accomplished by beginners so go ahead and give it a try!

read more |

Sunday, March 23, 2008

Tuesday, March 18, 2008

7 Incredibly Useful Tools for Evaluating a Web Design

If you are interested in analyzing and optimizing your page layout - here are some extremely useful tools that you can use to help.

read more |

Monday, February 04, 2008

Tutorial Photoshop: Reflection

A new Photoshop tutorial explaining you how to create this reflection effect on a text.

read more

Thursday, January 31, 2008

List of SQL Server database users and permissions

Today I was doing some research as to how to list the database users and the permissions they have and came across this article which is very useful.

http://www.mssqltips.com/tip.asp?tip=1071

Wednesday, January 30, 2008

Test you site in different browsers...

If you are interested to test your website in different browsers then Browsershots is very helpful for you. Browsershots shows how your website looks in different browsers. It is very easy to use. Just go to Browsershots site and then submit

read more | digg story

Monday, January 21, 2008

Introduction to C++ Programming and Graphics: Download ebook

Introduction to C++ Programming and Graphics offers a venue for rapidly learning the language by concisely revealing its grammar, syntax and main features, and by explaining the key ideas behind object oriented programming (OOP), with emphasis on scientific computing. The book reviews elemental concepts of computers and computing..

read more

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...