Wednesday, October 31, 2007

Automatic processing of SSAS cubes

I needed to automate the process of refreshing my Sql Server Analysis Services Cubes. My SQL server is 2000 and Analysis Services is SP4.

The approach I followed today is as follows:

I created a package in DTS of SQL Server 2000

Step 1 Created a SSAS task and pointed the Dimension (Rebuild the dimension) that needs to be updated.

Step 2 Then I created another task to refreshh all cubes.

Step 3 I created a On Success workflow between the above two tasks.

I saved this package and scheduled it to run monthly.

Tuesday, October 30, 2007

Displaying Temporary Internet Files folder in Windows Explorer

I am so used to browse the temporary internet files folder for internet exploer but I was not able to do this since I upgraded my Internet Exploer to 7. I finally found a way to do this. Microsoft has made the temporary internet files folder a 'Protected operating system folder'. That is the reason we cannot view that folder even when we check on the option 'Show hidden files and folders'.

All we have to do is Go to Windows Explorer -- Tools -- Folder options -- View tab
Untick the 'Hide protected system files and folders'

And you can see the Temporary internet files' folder in C:\Documents and Settings\User\Local Settings\ folder.

Saturday, October 27, 2007

Java based math course includes problem-solving lessons and tests

Visual and interactive way to thorough understanding and mastering Trigonometry without getting wearied on the very first chapter! Java- and web-based math course includes theoretical

read more

Friday, October 26, 2007

Concatenate values from two text box and populate the value in another text box

Today I had to create a function to concatenate two values from a text box and populate the output in another text box. This I did to inmprove the usability of the form for inputing the credit card data.

This is what I wrote

function conc()
var mon;
var yy;


Wednesday, October 24, 2007

Web Photo Gallery with Photoshop

Today I was googling for some CSS photo gallery that I want to use for my website. I found quite interesting ones as follows:

Library of CSS Stylesheets
Joshuaink Photo Gallery Template

The one that suited me was described in this chapter on Techrepublic.

As I was about to call off my search, I found this easy way of creating a photogallery using Photoshop CS2 which is really handy if you have to create a photo gallery out of many photos.

Wednesday, October 17, 2007

How to Create an "Invisible" Folder for Your, um, "Private" Files

You ever have a folder on your computer that you really dont want any one to find? You can make this folder hidden but then you have to un-hide all the folders when ever you want to find it. So how can you make a folder truly invisible? Follow these simple steps and your unmentionables will stay that way

read more

Friday, October 12, 2007

My first project in c#

Today for the first time I created a project in All this while I was doing some modifications for SQL code and reports for existing .NET projects. I wanted to recreate the functionality described here

When I did exactly what was said and tried to access the webpage, I got the error "Code not parsed...." When I googled for this error, then only I realised that I did not build the solution. So the error was fixed when I compiled the project.

Monday, October 08, 2007

Problems with connecting to proxy

Wayne, our systems Administrator contributed this:

Having problems with a user who cannot connect to our proxy server because their Internet Explorer keeps using a manually entered username and password, instead of their domain username and password. Even typing in the correct username and password doesn't work. Tried resetting IE settings, changing authentication options, with no success. Finally found instructions on removing the saved passwords, and that fixed the problem.

Windows XP does not offer a very easy way to review or remove the saved passwords though. If you follow the steps below though you can access a graphical interface to add, remove or edit the saved passwords on a given system.

1. Click Start and select Run

2. In the Open field type "rundll32.exe keymgr.dll, KRShowKeyMgr"

3. Once the Stored Usernames and Passwords interface opens you can select any of the entries and select Properties to view the existing information

4. To remove a saved password you can select one of the entries and select Remove. A confirmation screen will appear. Click on OK and the account will be removed

5. You can add additional saved passwords as well by clicking on the Add button and entering the appropriate information

6. Repeat the steps above as needed to add, remove or edit saved passwords

7. When you are done using the interface click the Close button

Thanks Wayne, for your contribution.

Friday, October 05, 2007

12 Ways to Make Better Use of Your Footer

Great list of ways to use an extended footer on a blog, and why you should move stuff down there as opposed to cluttering up your sidebar.

read more

Wednesday, October 03, 2007

Tuesday, October 02, 2007

Use SQL subselects to consolidate queries

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

read more | digg story

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