Increase Photoshop History States (Step Backward)

How many times did the “Step Backward” in Photoshop fails you? You wish you could increase its size so you can go back in time. Well i have some good news for ya;
Photoshop does allow you to increase the history states & cache Size and here are the steps:

Go to Edit -> Preference -> General

Then Click on Performance

then Adjust your History States

And Voila

You can’t specify target table ‘XXX’ for update in FROM clause – MySQL

If you try to run this query below in MySQL

UPDATE XXX
SET count = count + 5000 
WHERE id IN ( SELECT id FROM XXX WHERE id > 2 )  ;

You will get this error message:
“You can’t specify target table ‘XXX’ for update in FROM clause – MySQL …”

MySQL does have an unorthodox way to handle this type of request:

UPDATE XXX
SET count = count +  5000
WHERE id  IN 
(
	SELECT id FROM 
	(
	SELECT id FROM XXX ORDER BY id DESC LIMIT 20 
	) 
	AS Temp_Tbl
)

Failed to open disk scsi0:0: Unsupported and/or invalid disk type 7

If you get this error

Failed to open disk scsi0:0: Unsupported and/or invalid disk type 7.
Did you forget to import the disk first?
Unable to create virtual SCSI device for scsi0:0

chances are that your VM was created with an ealier version of vmware and it is not quite compatible with the version 7. When that happens just download the vmware converter and convert your vm to the new version.

 

SQL Server Setup failed to modify security permissions on registry key

“SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user XXXX. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key  exists on the destination drive.”

Add the following to the group in "administrative tools"

For some reason the software did not create the  necessary group. Make sure you replace YOURSERVERNAME with your server name.