Black screen after latest win 8.1 updates

1) sfc /scannow
and
2) dism.exe /online /cleanup-image /scanhealth

to see if there is any corruption.

If none, then try updating after disabling all non-windows services and all startup programs listed by Task Manager (reboot after disabling and then update).

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/