Saturday 28 February 2015

Red Gate SQL Prompt - Extend trial period for free

Get to user the full features of SQL Prompt for free?

This is a free little secret to extend the trial period of Red Gate SQL Prompt. Here you are given a new serial key. You will get to use the full features of the tool for another 14 days for free. After the second trial is over you can again attempt to use the technique to extend trial period again.

In SQL Server Management Studio, goto menu SQL Prompt -> Help -> Enter Serial Number. On the "Activate SQL Prompt" window, in the Serial number textbox enter the below text
I need more time
and click Activate button.

Your trial period is now successfully extended.

Tuesday 24 February 2015

Distinguish between USB2.0 and USB3.0

The easiest way to make out if the USB port on your laptop is USB 2.0 or USB 3.0, is to follow conventions. There are universal conventions followed by all hardware manufacturers that help you to tell which ports on your computer is 2.0 and which one is 3.0.

Facts: USB 3.0 is 10 times faster than USB 2.0, because it uses a technology called SuperSpeed.
Because of this USB 2 is called High Speed adn USB 3 is called SuperSpeed. This is also evident in the symbol used for USB 3 which has SS as part of the Symbol.

Below are the symbols for USB 2.0 and USB 3.0. You can check for these symbols near your laptop USB ports. You make out USB 2.0 and USB 3.0 by:
1) USB 2.0 port symbol is different from USB 3.0 symbol.
2) USB 3.0 port might have a blue tab in the ports
Either one of the above conventions would be used on your device.

USB 2.0 Symbol
USB 3.0 Symbol

USB 2.0
USB 2.0

USB 3.0

USB 3.0