Rename servername in MS-SQL when computer hostname changes.

When you change computer hostname, MS-SQL servername is not automatically updated. In order to update MS-SQL servername I used following SQL commands

sp_dropserver 'oldHostname'
go

sp_addserver 'newHostname',local
go

Now restart your SQL server instance and when follwing command is executed, you will see newHostname appears.

select @@servername as 'Server Name'

or

select * from sys.servers

Creating symbolic link in Windows

In order to create new symbolic link in Windows, I used the following command from the command prompt.

mklink /D myLink c:\Software\

where myLink is name of the symbolic link and C:\Software\ is the target path.

Stop and Start IIS7 website

In order to stop and start only specific site using IIS7, I used the following command from command prompt.

%systemroot%\system32\inetsrv\appcmd stop apppool /apppool.name:MySite

%systemroot%\system32\inetsrv\appcmd start apppool /apppool.name:MySite

where MySite is the name of the site which you want to stop and start.

Handle JavaScript dialog using WebAii

In order to handle JavaScript dialog using WebAii I used following command

manager.DialogMonitor.AddDialog(new AlertDialog(manager.ActiveBrowser,DialogButton.OK)); // Dialog which clicks on OK button

manager.DialogMonitor.Start();

manager.ActiveBrowser.Actions.Click(Element) // Click on link

Test Fixtures in Visual Studio Unit Testing Framework

Today I learned that,

[ClassInitialize()] fixture in VS Test Framework is [TestFixtureSetUp] in NUnit
and
[ClassCleanup()] fixture in VS Test Framework is [TestFixtureTearDown] in NUnit

Find silverlight element using XamlPath

In order to find Silverlight element using WebAii by XamlPath expression I used following syntax

FrameworkElement myElement = app.Find.ByExpression(new XamlFindExpression("Name=TabsContainer", "XamlTag=grid", "|", "XamlPath=/radtabcontrol[automationid=Tabs]/grid[0]/raddockpanel[0]/layouttransformcontrol[name=HeaderDockedElement]/grid[name=RootVisual]/contentpresenter[name=ContentPresenter]/grid[0]/raddockpanel[0]/scrollviewer[automationid=ScrollViewerElement]/border[0]/grid[0]/scrollcontentpresenter[name=ScrollContentPresenter]/itemspresenter[0]/tabwrappanel[0]/radtabitem[0]"));

Search and Replace multi-line text

In order to refactor code I used Text Crawler tool. Very powerful tool where one can search and replace multi-line text

echo without newline

In order to not output the trailing newline using echo, I used the following command

echo -n "testString"

MMS support in Windows Media player 12

On windows 7, in order to play streams using mmm protocol using windows media player 12, I executed the following command from cmd prompt.

regsvr32 wmnetmgr.dll

Ports assosciated with process

In order to see which ports are associated with which process, I used following Unix command

lsof -i4 -P

Show sound control in windows taskbar

In order to show the sound control in windows taskbar I used following command from windows/i386 installation directory

expand -r sndvol32.ex_ %systemroot%\system32

and later enabled from Control Panel => Sounds and Devices => Show sound control in taskbar

Add shortcut to Send To menu

In order to add shortcut to Send To right click Windows menu I added destination shortcut at %APPDATA%\Microsoft\Windows\SendTo

Disable jQuery Lightbox close when clicked outside popup

To remove the closing functionality of the jQuery Lightbox popup when clicked outside the popup I changed the functions as follows

From

$("#overlay").click(function(){ end(); }).hide();
$("#lightbox").click(function(){ end();}).hide();

To

$("#overlay").click(function(){ });
$("#lightbox").click(function(){ });

Gem installation without documentation

In order to install gem without documentation I used the following command

sudo gem install dm-timestamps -v=0.10.2 --no-rdoc --no-ri

Update installed gem version

In order to update the gem I used following commnad under Ubuntu

sudo gem update --system

Replace string with shell script parameter using sed command

In order to change string inside a file using shell script I used the following command in the shell script, where inside myFile.xml, oldString is the string I want to replace with the string contained in the first parameter passed to the shell script.

sed -i 's/oldString/'"$1"'/g' /home/healthy/myFile.xml

Copy directory in Unix

To copy the whole directory in Unix, I used the following command

cp -R /home/yogesh/sourceDir /home/yogesh/destinationDir

Share directory between Ubuntu guest and Windows host using Virtualbox

In order to mount shared folder for Ubuntu guest with Windows host using VirtualBox I used the following commands

sudo mkdir /mnt/windir
sudo mount.vboxsf shared /mnt/windir

In virtual box seetings, I created shared path as c:\virtual\shared and folder name is shared.

Ubuntu Server proxy settings

Ubuntu Server http proxy seetings I found inside file at

/etc/apt/apt.conf

Using grep command recursively

I used following command on Ubuntu server to find specific string under directories recursively, where /etc/ is root path under which I am interested to search.

grep -r 'myString' /etc/