What is QR Code?

Do you know what is QR Code?
A QR code (short for Quick Response) is a specific matrix barcode (or two-dimensional code), readable by dedicated QR barcode readers and camera phones. The code consists of black modules arranged in a square pattern on a white background. The information encoded can be text, URL or other data.

Was checking a barcode reader and found that app that i was testing can read QR codes so this was it.
Here is a QR code of my blog .

These are easily readable by most smartphones with camera by installing small app.

To generate QR Code visit - http://goqr.me/

Using of CAB files in Windows (Making & Extracting)

Cabinet files are the Microsoft Windows Archives. These archives can store multiple files/folders into a single file with or without involving data compression. Since every Windows system is natively compatible with cab files, Windows provide enough facilities to create, extract, or rebuild cab files without requiring additional software.By default, there are 3 utility files for dealing with cab files. They are

·         makecab.exe
·         expand.exe
·         extrac32.exe


You can find these in the system32 directory.

Use IEXPRESS.EXE,there is a lot of facilities with this tool. Try playing around a bit and figure them out.

Useful Software Downloads

Shyam's shared4.com 

To List the Schema Name and Table Name in MS SQL

The script which generates all the tables name in database along with its schema name.

SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'AS SchemaTableFROM sys.tables

Excel 2007 Tricks

TIPS & TRICKS

      To find age of a person based on DOB,

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"

Eg: In A1 column enter DOB in this format 31/08/1985 and in another cell enter this formula.

          To remove unnecessary spaces in the cell,

                    =trim (text)

===== SHYAM =====

25 Excel Tips & Tricks

25 Very Useful Keyboard Shortcuts

 1. To format any selected object, press ctrl+1

2. To insert current date, press ctrl+;

3. To insert current time, press ctrl+shift+;

4. To repeat last action, press F4

5. To edit a cell comment, press shift + F2

6. To autosum selected cells, press alt + =

7. To see the suggest drop-down in a cell, press alt + down arrow

8. To enter multiple lines in a cell, press alt+enter

9. To insert a new sheet, press shift + F11

10. To edit active cell, press F2 (places cursor in the end) 

11. To hide current row, press ctrl+9

12. To hide current column, press ctrl+0

13. To unhide rows in selected range, press ctrl+shift+9

14. To unhide columns in selected range, press ctrl+shift+0

15. To recalculate formulas, press F9

16. To select data in current region, press ctrl+shift+8

17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~) 

18. While editing formulas to change the reference type from absolute to relative vice versa, press F4

19. To format a number as currency, press ctrl+shift+4 (ctrl+$) 

20. To apply outline border around selected cells, press ctrl+shift+7

21. To open the macros dialog box, press alt+F8

22. To copy value from above cell, press ctrl+’

23. To format current cell with comma formats, press ctrl+shift+1

24. To go to the next worksheet, press ctrl+shift+page down

25. To go to the previous worksheet, press ctrl+shift+page up

... SHYAM... D Man U Love

Presentation for an HTML5 website..ShYaM..

HTML5

Web Development to the next level 

*Including other next generation technologies of the Web Development stack

  http://slides.html5rocks.com/#slide1

Source : http://slides.html5rocks.com
ShYaM D Man U Love...