Today's post is in no way related to BI. But I guess it is important for everyone to know where the power switch for a blade server is in case they are required to power them. We had a power outage for about 6 hrs at our office and the UPS would last only for 1 hr. We decided to do a managed shutdown of the servers and then power them back up the next day when the power came back up. I was responsible for coming early in the morning and switching on all the servers. As mentioned in an earlier po...
Read More
Yesterday I was working with my colleague and she was surprised with the number of shortcuts I use with Windows Key . So I thought I could list all the shortcuts for the benefit of her and others To open the Start Menu -- just click Windows Key To open the windows exlpoer -- click Windows Key + E To open the seach/find window -- click Windows Key + F To display the desktop by minimising all the open windows -- Click Windows Key + D (I have found this really helpful) To lock your computer -- clic...
I stumbled across Channel 9 yesterday while researching. Channel9 is a Microsoft maintained site which is full of videos, blogs, shows, series etc. There is too much information on this site for one to absorb and learn. Here is the link to the site. I hope you will enjoy this learning.
Here is another Free Expo Event from SSWUG that covers Data Mining and Analysis. The event is scheduled for March 18th 2011 from 9 am to 12 pm PST. Sessions will cover the following topics: Using Data Mining Plugins with Excel Developing SQL Server Data Mining Models Understanding Data Mining APIs Finding Patterns and Relationships in Server Data You can register now if you would like to learn from three skilled data mining experts which includes Brian Knight of Pragmatic Works as well.
Today I had a requirement to colour code in Excel based on a few conditions. At first I thouhgt I could use thre to four rules in the conditional formatting to achieve this result but when I did that the results that I was getting was not very satisfactory. So I thought I would try the And function of excel in conjunction with the conditional formatting and it worked wonders. I wanted the entire row to be highlighted in a certain colour based on three conditions. Here are the steps I followed to...
Thanks to one of my colleaguee, yesterday I learnt about the Snipping Tool which is avaibale in Windows 7. To activate the tool -- Click on Start -- All Programs -- Accessories -- Snipping Tool. A screenshot of the tool is shown below. Snipping tool enables you to select an area on your desktop or the entire desktop using your mouse and save this as an image for future use. Until now I used to use the key board shortcuts PRintscn for capturing a screenshot of the entire desktop or Ctrl + Alt + P...
I thought today I will cover the steps that can be followed to process a Sql Server Analysis Services Cube from Sql Server Management STudio. The assumption is that you already have a cube that is built in SSAS and you would like to process this cube from sql server management studio Step 1 Connect to the sql server analysis services instance from the sql server management studio as shown below. Step 2 From the left hande side menu click on the plus beside Databases. Step 3 Right click on the cu...