How to open a Command Prompt from the current folder

When working on batch files, most of the people faced the problem of openning a command prompt and changing to the current directory.

The command prompt can be opened from any folder, and when openning the command prompt displays the current folder. To achieve this follow the following steps

1. Open Windows Explorer
2. Go to Tools -->Folder Options in the menu
3. In the Folder Options dialog go to "File Types" tab
4. Select the "Folder" under FileTypes
5. Click on Advanced button
6. In the "Edit File Type" dialog click on "New" button
7. In the "Action" text box enter " Command Prompt"
8. In the "Application used to perform action" text box enter C:\WINDOWS\system32\cmd.exe
9. Click ok
10. open the Windows folder you want to open the command prompt
11. Right click on that folder, you can see the Command Prompt in the popup menu.
12. Click on "Command Prompt" it will open the command window with the current folder.

Sql Server - Collation

How to know the collation of a database?

Execute the following sql statement by changing the DataBase_Name.


SELECT DATABASEPROPERTYEX( 'DataBase_Name' , 'Collation' ) AS DatabaseCollation

How to know the collation of Sql Server?


SELECT SERVERPROPERTY('Collation') AS ServerCollation


Job Sites and Consultants Information

Job Sites

http://www.dice.com/
http://www.simplyhired.com/
http://www.careerbuilder.com/
http://www.jobdhundo.com/ (Seattle Area Job Site)
http://www.careercup.com/
http://www.monster.com/

Consultant / HR Information

iGate
mrudul.godavarthi@igate.com
Mrudul.godavarthi@mastech.com
Direct: 412-894-8001

ExcellData

Tanuta.Singh@excell.com
Neha.Jha@excell.com
Sangeeta.Halepet@excell.com

Aditi

anuradhab@aditi.com

yashodhrar@aditi.com

SolutionIQ

Alycia

Abeck@solutionsiq.com

Adaequare

Gokul

gksaride@adaequare.com

Daniel M. Lee
IT Recruitment
Rydek Professional Staffing
Tel 310-641-9800 x22
TOLL FREE: (888)222-2934 X 22
Cell: 310-892-2125
FAX: 310-641-9804
DLEE@RYDEK.COM
WWW.RYDEK.COM

Nancy Wojack
Technical Staffing Consultant
VisionIT Inc.
313.664.5661 - Direct
313.664.5650 - Main
313.664.5652 - Fax
Nwojack@visionitinc.com
http://www.visionitinc.com

Prateek Gattani
IDC Technologies Inc.
Campbell, CA
Tel: (408) 891-2184
Fax: (408) 608-6088
Email: pat@idctechnologies.com

Kelli Upton
Bradson Technology Professionals
425-456-8900 office
253-350-5491 cell
kupton@bradsontech.com
www.bradsontech.com

Nina Schindler Work: (408) 739-4900 Ext. 123 Fax: (866) 996-9977
Maxonic 1230 Midas Way Suite 220 Sunnyvale, CA 94085-4068 www.maxonic.com
nina@maxonic.com

sreelu@swinsoft.com

SQL Server -- Shortcuts

SQL Server Management Studio:

• Ctrl + Alt + G -- View Registered Servers
• Ctrl + Alt + T -- View Template Explorer -- This is helpfull when creating objects using sql script.
• Ctrl + R -- Toggle Result Pane (Message Window) -- This will help to display more space while writing Sql script.
• F8 -- To open Object Explorer

SQL SERVER 2005: Partitions

Two Type of Partitions:
1. Horizontal Partition
Saving rows into different tables based on data range.
2. Vertical Partition
Splitting the table into smaller tables (columns). Scattering the columns into multiple tables

Process to implement Horizontal Partition:

• Create partition function
• Create partition scheme
• Create the table/index