SQL Server Database concepts

How to change collation of database/Server:
http://www.db-staff.com/index.php/microsoft-sql-server/69-change-collation

How to download youtube videos by using script added to your browser

Script Summary:
Adds an option to download YouTube videos as MP4 and FLV files. Unlike many other scripts, this script downloads the videos directly from YouTube and doesn't connect to any other site.
Go to the following site and install the script on your browser and then when you view youtube video you get one more option download as mentioned in following website
http://userscripts.org/scripts/show/25105


More tips on google usage can be found in google official blog:
http://googlesystem.blogspot.com/

Linux commands

To display all permissions..of all files on current directory.
>ls -al


clear screen:
>clear

To traverse root to root directory
>cd ../../


to delete the folder recursively.
>rm -R pictures


to delete focibly a filename
>rm -f abc.txt


to copy a file to local current directory
>cp /home/abc/*.* .


to set an environment variable like TOP to ~/BA/SOL/test
>setenv TOP ~/BA/SOL/test


To set an environment variable in bash like TOP to ~/BA/SOL/top
>export TOP=~/BA/SOL/top


To check the value of environment variable like TOP
>echo $TOP


to flush DNS cache on Linux:
- To restart the nscd daemon, type 
/etc/rc.d/init.d/nscd restart 
in your terminal
- Once you run the command your linux DNS cache will flush.

to rename a file

>mv abc.c abc

>find /opt/CA -name "m_replace" -print

similar to explorer . in windows we can use "nautilus ." without double quotes.

to share files we can go to /mnt/httpd and open it

command to know suse verion on suse linux:

cat /etc/SuSE-release

How to check physical memory in solaris:

/usr/sbin/prtconf -v |grep Memory

Command to Know processid:
pidof processname
example:>pidof abserver
>23434


command to kill a process:
you can try:
>kill processID
>pkill processname
Forcible kill after trying kill with -1 and -2 is
>kill -9 processID
killing multiple instances of same process
>killall processName
>killall -9 processName


To list all processes running along with mem and cpu usage:
>ps aux
example:
>ps aux | grep uniserver
reference link: http://www.linfo.org/ps.html

How to create core file in Linux:
>ulimit -c unlimited
now core file will be generated like core.12345 where 12345 is pid of process. created in the location where process binary exist.
(or )
>gcore process-ID

How to get callstack of running process:
pstack processId
example:
>pstack 21345
This will give same output as gcore command coredump, analyzing it via gdb command
using gdb to get callstack:
>gdb programname core-file
> where //to get call stack
>bt    //to get callstack
>quit   //to come out of gdb

Windows keyboards shortcut keys

Office Communicator keyboard shortcuts


Key                        Action
Windows + Q     = Open Communicator
Alt + F4              = Close Communicator
Enter                   = Open Conversation window for selected contact
Alt + Up arrow    = move group up
Alt + down arrow= move group down
Shift + Enter        = Add a line break in Type a note area
Alt + I                 = Invite someone to join the conversation
Ctrl + F               = Send a File
Ctrl + S               = Save contents of instant messaging
Ctrl + B               = Bold selected text
Ctrl + U               = Underline selected text
Ctrl + I                = Italicize selected text
Ctrl + T               = Strikethrough selected text

Reference doc download link:

http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=2ae1f18b-d20a-4419-abd9-140586db9a8f&displayLang=en

Mstsc command

Usage

“mstsc /v tuuma01-xp2” to get session

“mstsc /console tuuma01-xp2” to get access to console

“mstsc /v tuuma01-xp2 /w:800 /h:600” will open remote session with specified width and height.

“mstsc /v tuuma01-xp2 /f” will open client session with client’s local resolution (full screen mode).

“mstsc /?” gives the help on mstsc commands.

 

shutdown command

Usage

“shutdown /s” run this on command prompt will shutdown system.

“shutdown /r” this will restart the system

“shutdown /s /f” this command will shut down forcibly.

 

setting regional settings of English win 2k3 to Japanese properly

 

      In advanced tab of Regional and Language Options à Default user account settings

Check the “Apply all settings to the current user account and to the default user profile” and it will ask for a restart do reboot which will effect the settings properly. This is final step after all other settings.

   

Reference Links:

http://forums.animesuki.com/showthread.php?t=60120&page=2

http://www.microsoft.com/globaldev/handson/user/xpintlsupp.mspx#E4

 

 

Flush dns 

to get a new name resolution. Also flush dns cache when you can’t access a newly registered domain name. You can simply flush your dns cache anytime to get new entry. So, Flush your dns cache now.

To flush DNS cache in Microsoft Windows (Win XP, Win ME, Win 2000):-

-          Start -> Run -> type cmd

- in command prompt, type ipconfig /flushdns

- Done! You Window DNS cache has just been flush.

-Reference: http://www.techiecorner.com/35/how-to-flush-dns-cache-in-linux-windows-mac/

 

Compmgmt command

Run “compmgmt.msc” command to display all options. Related to security, devices, memory mgmt.

How to share/access external / local box drives within a vmware.

 

Step 1: On the vmware menubar open ‘VM’ à ‘settings’  now open ‘Options’ tab and select “Shared Folders” and add a local system drive or external share and give a name.

Step 2: Now Start the vmware and open ‘My Computer’ click on ‘Folders’ button

On right hand side explorer click on ‘My network Places’ click on ‘Entire Network’ now select ‘vmware share location’ and copy the filees.

 

run eventvwr in command prompt to get event viewer logs.

Command line command to start communicator is “communicator”

 

How to check environment variable in windows.

echo %var_name%

(or)

Type “set” in command prompt to display all variables and its values.

How to know system up time in windows xp since last restart

Run systeminfo in cmd prompt this will give System Up Time

How to Open specific sequence of port numbers when firewall is on

By default the Windows Firewall seems to block all ports.  In order to open ports 2400-2600 you can run the following command from a Command Prompt:

FOR /L %I IN (2400,1,2600) DO netsh firewall add portopening TCP %I "Port"%I

This command will basically add each port, starting with port 2400, in increments of 1, up to port 2600 to the Exceptions list.

To remove these ports from the Exceptions list, you can run the following port from a Command Prompt:

FOR /L %I IN (2400,1,2600) DO netsh firewall delete portopening TCP %I

How to enable remote desktop when firewall is on:From Windows Firewall in Control Panel select the Advanced tab and then click on the Settings button next to the “Local Area Connection” and check the box next to “Remote Desktop”.

References:
link1
link2