Creating Maintenance Plans in SQL Server 2008 R2

One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2.

View Command History and Repeat the commands quickly

Most of us know about MS-DOS Command Prompt and various commands in DOS. We can quickly repeat the commands and view the history of commands very quickly. This is done by Arrow keys. When we use large commands repeatedly there is a chance of mistyping/typing errors in command. This error can be avoid by repeat the commands by arrow keys. For Previously used command to be repeated in the next line just press up arrow key. Continuing pressing the up arrow key will scroll through the command s that are typed previously.

For example we previously used ping command (ping 192.168.1.1) in command prompt and we can just press up arrow key to repeat the command . If the command is mistyped then use up arrow key and then using left arrow key to correct the command

How Employers Disable USB Ports & How Employees Enable them again

Desktop computer equipped with a CD writer or a DVD burner is a rare sight is most companies. But a much larger security threat is posed by the open USB ports where mischievous office workers can just plugin the Flash Pen Drive, External Hard Disk or their iPod music player and transfer corporate data or even copy licensed software to their memory sticks in seconds.

How to disable USB sticks and limit access to USB storage devices on Windows systems

USB storage - a possible security risk?

Decent IT administrators secure their networks behind firewalls. They install mail filters on their SMTP servers and deploy anti-virus software on all client workstations. But securing the network is not sufficient -- what happens if the users bring their own USB memory sticks and connect them to the computers at their office? A 1 Gb USB stick can sometimes hold an entire company's vital data. Within minutes or even seconds an employee has all the files they need in order to start up their own business and take all the customers with them. Alternatively, what happens if a careless user accidentally compromises the network with an infected USB stick?

How to Delete/Avoid New Folder.exe Virus

To day I came across a problem with a virus named. NEW FOLDER.exe, When i opened any folder i see a folder named new folder.exe and this is full in my desktop.This happened because one of my colleges insert a virus affected pendrive to the desktop. I searched over net to avoid new folder.exe error. Then i came to know about a manual method of deleting new folder. exe. This is as follows

General 6 Useful Tips for Mozilla Firefox Browsers

Making browser window Full Screen- You can view full screen in Mozilla Firefox browser without all the toolbar is just press F11 key to restore to previous just press F11 key again

Top Ten Keyboard Short cuts

By using Keyboard short cuts we can save great amount of time while using computer. Keyboard shortcuts can greatly increase your productivity, reduce repetitive strain, and help keep you focused. Key board shortcuts are very fast while comparing that action done with Mouse. If you are an expert in keyboard these tips may save a lot of time when you use computer for hours.

Ctrl +S

These tips will work in most of the programs. While working in any programs and documents pressing Ctrl+s will save the document/program

Ctrl + P

you can print any web page or microsoft document by pressing Ctrl + P

Ctrl + X

Ctrl + X will cut the selected /highlighted item

Ctrl + C or Ctrl+ Insert

You can copy the selected item/highlighted item by pressing the above combinations

Ctrl+ V

You can paste the item/object by using Ctrl + V

Ctrl+ Z and Ctrl + Y

You can undo any changes by just pressing Ctrl Z. For example if you cut a selected item Ctrl + Z will undo the same. Ctrl + Y would re do the undo

Ctrl + F

You can open Find by just pressing Ctrl + F. This program works also in internet browser page.

Alt + Tab

By pressing the above combinations you can swith between the open programs

Ctrl + Home/ End

By using this keys you can move the cursur to begin/end of the document in most of the programs inculding internet explorer

Page Up and Page Down

By using the Page up/page down keys you can move the page in the selected direction

Source:SAPARAVUR