Find Missing Identity Numbers in MS SQL Server

While I was doing some support cases, I realized that there might be some rows missing from the database for a particular day. So, I took some time off to confirm that indeed there was missing rows from database before I submit a request to DBA to restore the database.

Example: I will try to retrieve missing rows for the date 2013-03-19.

I did the following query to confirm if there was indeed missing rows:

Read more

Creating Virtual Machine in Hyper-V

Today I would like to share with you on how to create a Virtual Machine from Hyper-V. If you have yet to have Hyper-V installed, check out my previous blog posts on how to check if your processor is SLAT capable and how to install Hyper-V on your Windows 8 machine.

Once you have installed Hyper-V and configured virtual switches, you may proceed to create a new virtual machine.

Creating a New Virtual Machine

  1. Start Hyper-V Manager. Click Action –> New –> Virtual Machine.

    Action --> New --> Virtual Machine
    Action –> New –> Virtual Machine
  2. Click Next button. Then give your Virtual Machine a meaningful name. (Eg. Windows 8 Test)
    Give it a meaningful name
    Give it a meaningful name

    Read more