Sep 7, 2009

Lots Of Windows Xp Tips - Part 1

01. Lock XP Workstation 


You can lock your XP workstation with two clicks of the mouse. Create a new shortcut on your desktop using a right mouse click, and enter 'rundll32.exe user32.dll, LockWorkStation' in the location field. Give the shortcut a name you like. That's it -- just double click on it and your computer will be locked. And if that's not easy enough, Windows key + L will do the same.

02. Remove Windows XP system software 


XP hides some system software you might want to remove, such as Windows Messenger, but you can tickle it and make it disgorge everything. Using Notepad or Edit, edit the text file /windows/inf/sysoc.inf, search for the word 'hide' and remove it. You can then go to the Add or Remove Programs in the Control Panel, select Add/Remove Windows Components and there will be your prey, exposed and vulnerable.

03. New commands


For those skilled in the art of DOS batch files, XP has a number of interesting new commands. These include 'eventcreate' and 'eventtriggers' for creating and watching system events, 'typeperf' for monitoring performance of various subsystems, and 'schtasks' for handling scheduled tasks. As usual, typing the command name followed by /? will give a list of options -- they're all far too baroque to go into here.

Aug 5, 2009

Fix “Task Manager has been Disabled by Your Administrator”

when you try to run Task Manager, Windows shows following error message:


Task Manager has been disabled by your administrator.


There are 2 possible reasons behind this problem:
  • Your system administrator applied the restriction using Registry Editor or Group Policy Editor.
  • Your system has been infected with Virus and it has disabled the Task Manager.


The 10 most useful Word shortcuts


Keystroke
Function
Notes
Shift + F3
Toggles through capitalization options.
This one isn’t perfect — for instance, it insists on capitalizing articles and prepositions in Title Case mode — but it’s still a big timesaver.
Ctrl + Shift + N
Applies the Normal style.
If you work with documents that are riddled with obscure and specialized styles (typically other people’s), it’s handy to turn them into Normal paragraphs on the fly.
Ctrl + Shift + C
Copies the formatting of selected text.
Once you’ve copied the format, you can press Ctrl + Shift + V to paste the formatting onto a new selection. Yeah, I know — Format Painter does this, too. But Format Painter forgets the formatting as soon as you’re finished with it. This shortcut remembers what you copied until you close out of Word.
Alt + F9
Toggles the display of field codes on and off.
Unless you work with field shading turned on — and I don’t know many users who do — you can’t necessarily tell what’s literal text and what’s being generated by an underlying field code. A quick peek using this shortcut can prevent the headache of inexplicable changes and unwanted editing consequences.
F4
Repeats your most recent action.
This might be the all-time best shortcut (except for Undo, which I’m not including in this list because for me, at least, it’s like breathing and requires no conscious thought). The F4 shortcut will repeat nearly all the actions you take on document text: typing: formatting, deleting.It will also let you repeat the action of adding or removing table rows, but it isn’t well implemented with tables overall. For instance, changing table properties is not replicable via this shortcut.
Ctrl + H
Opens the Find And Replace dialog box with the Replace tab selected.
Replace functionality is my constant companion, so this one is essential for me. Ctrl + F opens to the Find tab if you just want to locate something in a document (or make sure something isn’t in there).
Ctrl + drag text or an object
Creates a copy of the text or object.
Apologies to the keyboard purists, but this useful trick does require mouse action. It’s handy when you need to copy an object and control where that copy ends up. For example, a picture or other object that has certain positioning attributes may land in some unpredictable location if you use the standard copy and paste functions. This shortcut lets you drag it exactly where you want it.Just make sure you drop the text or object before you release the Ctrl key or Word will move the original instead of copying it.
BONUS: If you hold down Shift along with Ctrl as you drag, Word will keep the copy aligned with the original.
Ctrl + Q
Removes paragraph formatting that isn’t part of the style assigned to a selected paragraph.
When you want to strip out manually applied formats and return to only those characteristics defined by a paragraph style, this is the quickest way to get there. Ctrl + Spacebar works the same way for character formatting.
Ctrl + 0 (zero)
Applies or removes 12 points of space above the current paragraph.
This sounds a little lame, but you can improve readability of selected text in about two seconds using this trick. For instance, table text is often jammed up against top borders. Select the table and hit Ctrl + 0 and you’ll get an instant improvement.
Alt + drag the mouse vertically
Make a vertical text selection.
Another keyboard/mouse hybrid, this one is obscure but useful. Some users have trouble making it work, but the problem is usually sequence. Just make sure you press Alt before you press the mouse button and drag. Then, release Alt before you release the mouse button.

Jul 14, 2009

Schedule a Database Backup in SQL 2005


To schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005, follow these steps:
  1. Start SQL Server Management Studio.
  2. In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list.
  3. Click Connect.
  4. In Object Explorer, expand Databases.
  5. Right-click the database that you want to back up, click Tasks, and then click Back Up.
  6. In the Back Up Database - DatabaseName dialog box, type the name of the backup set in the Name box, and then click Add under Destination.
  7. In the Select Backup Destination dialog box, type a path and a file name in the Destinations on disk box, and then click OK.
  8. In the Script list, click Script Action to Job.
  9. In the New Job dialog box, click Steps under Select a page, and then click Edit if you want to change the job parameters.

    Note In the Job Step Properties - 1 dialog box, you can see the backup command.
  10. Under Select a page, click Schedules, and then click New.
  11. In the New Job Schedule dialog box, type the job name in the Name box, specify the job schedule, and then click OK.

    Note If you want to configure alerts or notifications, you can click Alerts or Notifications under Select a page.
  12. Click OK two times.
     
You receive the following message: 

The backup of database 'DatabaseName' completed successfully.

Note To verify the backup job, expand SQL Server Agent, and then expand Jobs. When you do this, the SQL Server Agent service must be running.




Ethernet Cable - Color Coding Diagram

The information listed here is to assist Network Administrators in the color coding of Ethernet cables. Please be aware that modifying Ethernet cables improperly may cause loss of network connectivity. Use this information at your own risk, and insure all connectors and cables are modified in accordance with standards.
T-568A Straight-Through Ethernet Cable
 
The TIA/EIA 568-A standard which was ratified in 1995, was replaced by the TIA/EIA 568-B standard in 2002 and has been updated since. Both standards define the T-568A and T-568B pin-outs for using Unshielded Twisted Pair cable and RJ-45 connectors for Ethernet connectivity. The standards and pin-out specification appear to be related and interchangeable, but are not the same and should not be used interchangeably.


T-568B Straight-Through Ethernet Cable   
Both the T-568A and the T-568B standard Straight-Through cables are used most often as patch cords for your Ethernet connections. If you require a cable to connect two Ethernet devices directly together without a hub or when you connect two hubs together, you will need to use a Crossover cable instead. 



RJ-45 Crossover Ethernet Cable 
 
A good way of remembering how to wire a Crossover Ethernet cable is to wire one end using the T-568A standard and the other end using the T-568B standard. Another way of remembering the color coding is to simply switch the Green set of wires in place with the Orange set of wires. Specifically, switch the solid Green (G) with the solid Orange, and switch the green/white with the orange/white. 

Ethernet Cable Instructions:
  1. Pull the cable off the reel to the desired length and cut. If you are pulling cables through holes, its easier to attach the RJ-45 plugs after the cable is pulled. The total length of wire segments between a PC and a hub or between two PC's cannot exceed 100 Meters (328 feet) for 100BASE-TX and 300 Meters for 10BASE-T.
  2. Start on one end and strip the cable jacket off (about 1") using a stripper or a knife. Be extra careful not to nick the wires, otherwise you will need to start over.
  3. Spread, untwist the pairs, and arrange the wires in the order of the desired cable end. Flatten the end between your thumb and forefinger. Trim the ends of the wires so they are even with one another, leaving only 1/2" in wire length. If it is longer than 1/2" it will be out-of-spec and susceptible to crosstalk. Flatten and insure there are no spaces between wires.
  4. Hold the RJ-45 plug with the clip facing down or away from you. Push the wires firmly into the plug. Inspect each wire is flat even at the front of the plug. Check the order of the wires. Double check again. Check that the jacket is fitted right against the stop of the plug. Carefully hold the wire and firmly crimp the RJ-45 with the crimper.
  5. Check the color orientation, check that the crimped connection is not about to come apart, and check to see if the wires are flat against the front of the plug. If even one of these are incorrect, you will have to start over. Test the Ethernet cable.
 
Ethernet Cable Tips:
  • A straight-thru cable has identical ends.
  • A crossover cable has different ends.
  • A straight-thru is used as a patch cord in Ethernet connections.
  • A crossover is used to connect two Ethernet devices without a hub or for connecting two hubs.
  • A crossover has one end with the Orange set of wires switched with the Green set.
  • Odd numbered pins are always striped, even numbered pins are always solid colored.
  • Looking at the RJ-45 with the clip facing away from you, Brown is always on the right, and pin 1 is on the left.
  • No more than 1/2" of the Ethernet cable should be untwisted otherwise it will be susceptible to crosstalk.
  • Do not deform, do not bend, do not stretch, do not staple, do not run parallel with power cables, and do not run Ethernet cables near noise inducing components.