ITIL vs Prince2

What's the difference between Core i3, i5 and i7 processors?

Confused about which Intel processor you need? Click below link to explore the differences between the Core i3, i5 and i7 range !!

Reference Link

Faster Shutdown your PC

The shutdown process in Windows operating system requires three clicks and a menu. Here’s how you can make the shutdown process faster.

All you need to do is right-click on any open space on the desktop, then click New > Shortcut. A Location field will appear on the screen. Paste the following in the location field:

%windir%\System32\shutdown.exe /s /t 0

Then, click on Next and complete the shortcut setup.

 /l         Log off. This cannot be used with /m or /d options.
 /s         Shutdown the computer.
 /r         Shutdown and restart the computer.

 /t xx    Is the timer parameter followed by numeric value as second

For more help you can go to command prompt and type "shutdown /?"

Calculate Experience in Year and Month

Mostly I get question from friends about calculating Date difference for calculating there job experience. So decided to show how you can get it.

Below is the simple example for this:

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.