see who (which username) is logged in on a client / server in a network

From windows you can go to Command prompt

query session /server:remote_computer_name_here







How to print protected / secured files in 3 easy steps

How to print protected / secured files in 3 easy steps ...

1. Upload to your Google Docs
2. Double click on it to open & click on Print button on top right corner & save as PDF to your desktop
3. Double click on the saved file and print (check File-Properties-Security and see if printing is Allowed now).

What is Windows LTSB ?

LTSB, stands for "Long-term Servicing Branch". 

MsiExec code 1619: corrupt media

MsiExec code 1619: is probably due to lack of access / corrupt media? check the access list & media itself ...

ERROR_INSTALL_PACKAGE_OPEN_FAILED

1619

This installation package could not be opened. Verify that the package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer package.

strikethrough shortcut in Excel

Fastest way to produce strikethrough in Excel is to select the text (or the cell) you want to strikethrough, and then simply press Control+5. You can also use that shortcut to remove strikethrough. PERFECT. Meaning you dont have to through the hassle of formatting your cell and then press the underline check box in the Font window that pops up.

Missing Remote Desktop Connection under Accessories ?

Missing your remote desktop connection under Accessories in Windows?

1. Go to "C:\Windows\System32" folder and find the "mstsc.exe".
b. Create a shortcut out of it.
c. Move it to "C:\Documents and Settings\All Users\Start
Menu\Programs\Accessories\Communications" folder.
d. The system may ask to make this short cut on the desktop. Click yes, then simply
cut the shortcut from the desktop and paste in the Communications folder.
e. Rename the shortcut "Remote Desktop Connection".

copy a text to clipboard in Java

Easily done via Java Toolkit

StringSelection selection = new StringSelection(theString);
Clipboard clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();
clipboard.setContents(selection, selection);

Shortcut to insert new row in Excel

If you press Alt + I + R, you would simply get a new row inserted right away in your Excel sheet :-)

keeping tasks tab in view in Outlook 2013, HOWTO

Tiered of clicking on Tasks to see remaining tasks and of-course forgetting them becuase they are not right in front of your eyes all the time, well then read this post from Microsoft which helps you to keep the tasks always visible in your Outlook 2013
http://office.microsoft.com/en-001/outlook-help/keep-upcoming-tasks-always-in-view-HA102809465.aspx

Remove Windows Live Messenger !!! HOWTO

If you are as pissed as me about having Live messenger launching everytime you start your windows, then follow the following lines to get rid of it :-P

On the Desktop click the Start button

In the Search field type Programs and Features and hit enter

Locate Windows Live Essentials and double click

Select Uninstall and hit Continue

Place a checkmark by Messenger and click continue

Once it is uninstalled, select close and exit out of Programs and features

Source : http://answers.microsoft.com/en-us/windowslive/forum/messenger-wlsettings/how-to-uninstall-windows-live-messenger/626144e2-fd59-4b98-81ac-1db56f057ef3

Automated Scheduled Backup, MS-SQL Server 2008

MS SQL server 2008 has integrated automatic backup solution (both full and differential). Following links explains quite easy how to setup a scheduled backup and clean up (delete old backup files).

http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx

Uptime on a windows server

To find out the current up-time on a server simply open the windows task manager and read the up-time from Performance tab.

Source : http://www.petri.co.il/check-uptime-in-server-2008.htm

Opening Windows Task Manager, without Ctrl+Alt+Delete

If you do not have the chance to press Ctrl+Alt+Del and you still need to open Windows Task Manager, try right clicking on the task bar and pressing the choice : "Start Task Manager".

Do not try searching for it, because you won't find it. Been there, done that, doesn't work :-P

Mounting ISO files in Windows 8

Simply right click and choose mount :-)

Changing Windows 8 serial key for activation

If you want to change the serial key in Windows 8 and as me you can not find it, then you can simply follow this instruction to force the Windows to do it from command line.

1 - Click on start menu (right bottom corner) and type CMD, when you see th command promt option, right click on it and press "Run As Administrator".

2 - Then in the command prompt terminal type following command: "slmgr.vbs -ipk ". E.g.: 

slmgr.vbs -ipk 00000-00000-00000-00000-00000 

You would then receive a confirmation as a pop up window.

3 - Now you need to activate windows, after changing the key, simply run "slmgr.vbs -ato" and you will again get a confirmation in about 10 seconds.

Sharing your WiFi Internet through the Ethernet port, Windows 7

1- Connect to the Internet (using WiFi)

2- Press Start button, Control Panel, Network and Internet, Network and Sharing Center, Change Adapter Settings from the list on the left side.

3- Right-click your wireless connection and select Properties.

4- On Sharing tab check in the check-box "Allow other network users to connect through this computer's Internet connection."

5- Check "Allow other network users to control or disable the shared Internet connection" check-box as well and press Ok.

6- Plugin the ethernet cable to your computer and the other side to another computer or an ethernet switch / router.

'ipconfig' is not recognized as an internal or external command, Windows 7

Sometimes uninstalling programs (worst case, viruses) could result in PATH in Windows environmental variables to loose track of some of main cores of the Windows system. E.g. if you run ipconfig in the CMD and gets this error: "'ipconfig' is not recognized as an internal or external command,
operable program or batch file.", then you might want to have a look at the PATH variable and see if  
C:\Windows;C:\Windows\system32
are missing ...

• Right click on computer
• Choose Properties
• Choose Advanced Settings from left bar
• Environmental Variables
• PATH

Adding a folder that is not on the frequent list, to pinned list in Windows Explorer

You can open folders from Windows Explorer shortcut on Windows 7. You have 2 lists when you right click on this folder, Frequent and Pinned. The frequent folders are those which you have visited frequently and the pinned ones are those which you have chosen to have it permanently in that list. It'e quite a useful shortcut, believe me.

One way to add folders to the pinned list is simply to choose them from frequent list and press the pin button in front of the folder name. However not all the folders that we would like to add to this list comes up in the frequent list. What to do? The solution is quite simple. You only need to drag that folder on the Windows Explorer shortcut on your taskbar  and release it. The folder would be added automatically to your pinned list.

How to deactivates restrictions about remote desktop without password

Blank password restrictions for remote access on Windows could be deactivated by using a policy. To locate and change this policy:


- Start - Run (Search for programs) - gpedit.msc - Enter to start the Group Policy Editor.
- Computer Configuration\Windows Settings\Security Settings\Local Policies\Security Options\Accounts: Limit local account use of blank passwords to console logon only.
- Double click on Account:Limit local account use of blank passwords to consol logon only
- Choose Disabled, and OK.

NOTE: By default, this policy is on (enabled).


Source : http://support.microsoft.com/default.aspx?scid=303846

Having two Excel 2010 files beside each other in Windows 7

Wanna have two Excel files beside each other and you can't get it done !!! Well remember you are using Microsoft products, so don't be surprised that they don't manage normally to let you have two windows beside each other. Well but there is a hard way to do this : 

1. Open the first workbook any way you want. 
2. Start a second instance of excel. either double click on shortcut to excel.exe on your desktop or through windows start button | run, then type: excel and hit enter. Then file|open the second workbook. 
3. Now files are separated and you can have them beside each other ... Siiiiiigggggghhhhhhh :-S