You have an incorrect version of driver “vmci.sys”

When running vm instance with workstation 8.0, we may get the error.  This problem happened to me when using windows 7 64 bit edition with workstation 8.0 “You have an incorrect version of driver vmci.sys” To resolve this 1. Open the vmx file related to the vm image 2.  Change the following line vmci0.present = “false” Bookmark on DeliciousDigg this post Recommend on FacebookShare with St Read More

Tags: ,

Open blocked websites

If the websites are blocked in any country, we can still access the website by following simple steps 1.  Open the network adaptor properties 2. Change the DNS server to 8.8.8.8 and alternate DNS to 8.8.4.4 The above IP’s are of google servers.  Your computer will use the google servers now.  you can turn it back when you dont need them. Make sure that you remember the original settings. Bookmark on Delici Read More

Tags: ,

reinstall windows 8 developer preview

If we need to reinstall windows 8 developer preview, it will ask for the key where as it will not ask for the first time when we are installing the windows 8 developer preview. Use the following key for windows 8 developer preview for resetting or reinstalling 6RH4V-HNTWC-JQKG8-RFR3R-36498 Bookmark on DeliciousDigg this post Recommend on FacebookShare with StumblersTweet about itSubscribe to the comments on this po Read More

Tags: , ,

Deleting large number of records from sql server 2005

WHILE EXISTS ( SELECT * FROM table WHERE <condition to delete>) BEGIN SET ROWCOUNT 1000 DELETE Table WHERE <Condition> SET ROWCOUNT 0 ENd   Bookmark on DeliciousDigg this post Recommend on FacebookShare with StumblersTweet about itSubscribe to the comments on this post Read More

Tags: ,

Cannot create a server using the selected type – Eclipse tomcat

Some times if we delete the servers configuration in the workspace or if we move the workspace adding tomcat as server can become difficult thing.  We will hit with the error Cannot create a server using the selected type. To resolve this error, try one or all of the following: 1.  Go to Window–>Preferences–>Server–>Runtime Environments and fix the broken path/link for the server 2.  R Read More

Tags:

Avoiding Automatic Number formatting – Excel 2003

If you want to type a value such as 10e5, 1 p, or 1-2, and you do not want the value to be converted to a built-in number format, type the number as a text value. To type a number as a text value, use any of the appropriate methods below. Method 1 Place a space at the beginning of the entry. NOTE: This method does not work if the entry resembles a number formatted in scientific notation. For example, typing 1e9 re Read More

Tags:

Sharepoint Technical diagrams – Technet

Design Sample: Corporate Portal with Classic Authentication Design Sample: Corporate Portal with Claims-based Authentication SharePoint 2010 Products Deployment Services in SharePoint 2010 Products Cross-farm Services in SharePoint 2010 Products Topologies for SharePoint Server 2010 Extranet Topologies for SharePoint 2010 Products Hosting Environments in SharePoint 2010 Products Search Technologies for SharePoint Read More

SQL – Handling Null Values

1. A NULL value represents an UNKNOWN value 2. Under ANSI_NULLS ON, two NULL values will never be equal to each other because the two separate values are unknown. With ANSI_NULLS OFF, two separate NULL values will evaluate to equal values. IF OBJECT_ID('SalesHistory')>0 DROP TABLE SalesHistory;GOCREATE TABLE [dbo].[SalesHistory]( [SaleID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY, [Product] [varchar](10) NULL, [S Read More

Tags:

SQL – Execute T-SQL batch multiple times

Executing T-Sql batch multiple times. Description: If we want to execute T-sql command multiple times 2000: CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID unique identifier) CREATE TABLE dbo.TEST2 (ID INT IDENTITY (1,1), ROWID unique identifier) GO DECLARE @counter INT  SET @counter = 0  WHILE @counter < 1000  BEGIN        INSERT INTO dbo.TEST (ROWID) VAL Read More

Tags: ,

SQL – Delete duplicate row without primary key

Deleting a duplicate row without primary key. Scenario: ID FirstName LastName 1 Bob Smith 2 Dave Jones 3 Karen White 1 Bob Smith 1 Bob Smith 2000: ‘filters to no. of rows to process, here it allows to take only I record set ROWCOUNT 2 ‘so here it scans only 2 records from the available 3 records and deletes those 2 records delete from customers2 where Read More

Tags: ,