Difference between SQL and NOSQL Databases.

SQL databases are like automatic transmission and NoSQL databases are like manual transmission. Once you switch to NoSQL, you become responsible for a lot of work that the system takes care of automatically in a relational database system. Similar to what happens when you pick manual over automatic transmission. Secondly, NoSQL allows you to eke more performance out of the system by eliminating a lot of integrity checks done by relational databases from the database tier. Again, this is similar to how you can get more performance out of your car by driving a manual transmission versus an automatic transmission vehicle.

However the most notable similarity is that just like most of us can’t really take advantage of the benefits of a manual transmission vehicle because the majority of our driving is sitting in traffic on the way to and from work, there is a similar harsh reality in that most sites aren’t at Google or Facebook’s scale and thus have no need for a Bigtable or Cassandra.

These are some points which gives us some difference between SQL and NOSQL Databases.

• SQL databases are primarily called as Relational Databases (RDBMS); whereas NoSQL database are primarily called as non-relational or distributed database.
• SQL databases have predefined schema whereas NoSQL databases have dynamic schema for unstructured data.
• SQL databases are vertically scalable whereas the NoSQL databases are horizontally scalable. SQL databases are scaled by increasing the horse-power of the hardware.
• In case of scalability: In most typical situations, SQL databases are vertically scalable. You can manage increasing load by increasing the CPU, RAM, SSD, etc, on a single server. On the other hand, NoSQL databases are horizontally scalable. You can just add few more servers easily in your NoSQL database infrastructure to handle the large traffic.
• For complex queries: SQL databases are good fit for the complex query intensive environment whereas NoSQL databases are not good fit for complex queries. On a high-level, NoSQL don’t have standard interfaces to perform complex queries, and the queries themselves in NoSQL are not as powerful as SQL query language.

Reference from : link

Merge all worksheets of active workbook into one worksheet with VBA code

VBA Code to merge excel worksheets:

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

Sub Combine()

Dim J As Integer

On Error Resume Next

Sheets(1).Select

Worksheets.Add

Sheets(1).Name = "Combined"

Sheets(2).Activate

Range("A1").EntireRow.Select

Selection.Copy Destination:=Sheets(1).Range("A1")

For J = 2 To Sheets.Count

Sheets(J).Activate

Range("A1").Select

Selection.CurrentRegion.Select

Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select

Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)

Next

End Sub

Notes:
(1) Your data must start from A1, if not, the code will not take effect.
(2) Your data must have the same structure.
(3) This code only can combine all worksheets of the active workbook, if you want to merge worksheets from multiple workbooks, this code will not work.

Photoshop Keyboard Shortcuts

For Photo Shop beginners

InfoPath - Clear cache form in local system

When loading an InfoPath form from an intranet/Sharepoint etc, the form template is downloaded and cached locally. Sometimes after the template has been upgraded on the server the local client doesn’t always get the upgraded form template but uses the local cached copy instead.

You can rectify this by clearing the local cache by following methods

Method 1

1. Start -> Run;
2. Infopath /cache clearall

Method 2

Dim wshShell

Dim sRun, sParam, sMsg

/* modify the path of Infopath.exe if required*/

sParam = "C:\Program Files (x86)\Microsoft Office\Office15\INFOPATH.EXE /cache clearall"

Set wshShell = Createobject("WScript.Shell")

wshShell.Exec sParam

Set wshShell = Nothing

Verification
C:\Users\[User]\AppData\Local\Microsoft\InfoPath\FormCache

Download copy of your facebook data

Interesting thing found about download FACEBOOK data, as of feature available on FACEBOOK.

You can download your information from your settings. To download your information:

• Click  at the top right of any Facebook page and select Settings
• Click Download a copy of your Facebook data below your General Account Settings
• Click Start My Archive

For further assistance you can visit FACEBOOK help center page (Click to Open)

OCR Tools To Convert Your Files Back Into Editable Documents

Google Docs has integrated OCR support. It uses the same OCR engine that Google uses to scan books and understand text in PDF files.

To get started, open the Google Docs website and start uploading a file. You can’t scan directly from your scanner into Google Docs; you’ll have to scan the document as an image or PDF file first. If you don’t have a scanner, you can try scanning a document with your smartphone’s camera.

Enable the “Convert text from PDF and image files to Google documents” check box when you upload the file.

After you upload the file, it will appear as a new text document in Google Docs.

Google Docs did a pretty good job here. It struggled to understand the web addresses, but all these tools did.

Unlike many free online OCR tools, like Free OCR (which is different from the FreeOCR below), Google Docs doesn’t have any limits on the amount of pages you can upload.

Site Reference: http://www.makeuseof.com/tag/3-free-ocr-tools-convert-files-editable-documents/

Essential keyboard shortcuts for MS-EXCEL

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly.

Control-Down/Up Arrow = Moves to the top or bottom cell of the current column Control-Left/Right Arrow = Moves to the cell furthest left or right in the current row

Control-Shift-Down/Up Arrow = Selects all the cells above or below the current cell

Shift-F11 = Creates a new blank worksheet within your workbook

F2 = opens the cell for editing in the formula bar

Control-Home = Navigates to cell A1

Control-End = Navigates to the last cell that contains data

Alt-= = Autosums the cells above the current cell