Technology Insights

PostgreSQL: PSQL Select Distinct Output * To Generate New Table

Earlier this evening I ran into a unique issue where a PostgreSQL table had been created with no primary key this allowing duplicate rows to exist in the database table. You are unable to delete such rows in a SQL table because there is no primary key. After not being able to delete the rows via the PSQL CLI I opened pgAdmin III to see if I could delete the rows using the GUI interface provided by pgAdmin III however the delete was grey in the menu as shown in the below image.

Details
Technology Insights

Windows Anytime Upgrade: Upgrade Windows 7 Home Premium To Professional

A client of mine purchased a new computer that had Windows 7 Home Premium on it however they needed some of the features available with Windows 7 Professional. By purchasing a Windows 7 Professional key you can upgrade Windows 7 Home Premium to Windows 7 Professional in a very short amount of time. At first I thought it would require the disk to upgrade however you can follow the simple instructions below to upgrade Windows 7 using Windows Anytime Upgrade.

Details
Technology Insights

Windows 7 Ultimate 64-Bit: C: Drive Shows Dirty, Windows 7 CHKDSK Every Boot

I have been really satisfied with the Dell Studio XPS 13 running Windows 7 Ultimate 64-Bit that I purchased at the beginning of the year however recently the C: drive displays dirty on boot thus triggering a chkdsk. The problem is that sometimes the boot screen would simply hang at 1 second left before the chkdsk would run. This would happen regardless of if I hit a key to skip the chkdsk or if I let the chkdsk run. Below I describe some of the things I have done to get around this problem.

Details