After doing quite a bit of research and testing, these are the steps I used to move my VMs from an ESX 3.5 box to an ESXi 4.1 box. Read the rest of this entry »
Archive for 2010
Moving my VMs from ESX 3.5 to ESXi 4.1
Posted by jpluimers on 2010/09/23
Posted in Endian, ESXi4, Power User, Veeam | Leave a Comment »
Talking SOAP to your ESXi box: VMware vSphere Web Services SDK
Posted by jpluimers on 2010/09/22
Note that what you can do through the SDK (and vMA and its’ virtual appliance or that matter) is limited by what your ESX / ESXi license allows.
The VMware KB has more information on this: you will need at least a vSphere Essentials license for your ESXi box to use it..
If you have a free ESXi license, you will often get messages like these:
SOAP Fault:
Fault string: fault.RestrictedVersion.summary
Fault detail: RestrictedVersionFault
Share this:
Posted in Development, ESXi4, Power User, SOAP/WebServices, VMware | Leave a Comment »
SQL Server 2008: restoring backup of previous SQL Server version
Posted by jpluimers on 2010/09/21
When restoring a backup made in SQL Server 2005 to a SQL Server 2008 environment, you don’t see the underlying upgrade of the on-disk physical version in the UI (you only see the percentage completion moving from 0% to 100%).
When performing the same on the command-line you can actually follow the physical version gets updated:
C:\SCRIPT>"%sqlcmd%" -S . -E -Q "RESTORE DATABASE [MyDBA] FROM DISK = N'C:\BACKUP\MyDB.bak' WITH REPLACE, STATS = 10, MOVE N'MyDB' to N'C:\DATA\MyDB.mdf', MOVE N'MyDB_log' to N'C:\DATA\MyDB_log.ldf' ;" 19 percent processed. 29 percent processed. 39 percent processed. 49 percent processed. 59 percent processed. 69 percent processed. 78 percent processed. 88 percent processed. 98 percent processed. 100 percent processed. Processed 1296 pages for database 'MyDBA', file 'MyDB' on file 1. Processed 2 pages for database 'MyDBA', file 'MyDB_log' on file 1. Converting database 'MyDBA' from version 611 to the current version 655. Database 'MyDBA' running the upgrade step from version 611 to version 621. Database 'MyDBA' running the upgrade step from version 621 to version 622. Database 'MyDBA' running the upgrade step from version 622 to version 625. Database 'MyDBA' running the upgrade step from version 625 to version 626. Database 'MyDBA' running the upgrade step from version 626 to version 627. Database 'MyDBA' running the upgrade step from version 627 to version 628. Database 'MyDBA' running the upgrade step from version 628 to version 629. Database 'MyDBA' running the upgrade step from version 629 to version 630. Database 'MyDBA' running the upgrade step from version 630 to version 631. Database 'MyDBA' running the upgrade step from version 631 to version 632. Database 'MyDBA' running the upgrade step from version 632 to version 633. Database 'MyDBA' running the upgrade step from version 633 to version 634. Database 'MyDBA' running the upgrade step from version 634 to version 635. Database 'MyDBA' running the upgrade step from version 635 to version 636. Database 'MyDBA' running the upgrade step from version 636 to version 637. Database 'MyDBA' running the upgrade step from version 637 to version 638. Database 'MyDBA' running the upgrade step from version 638 to version 639. Database 'MyDBA' running the upgrade step from version 639 to version 640. Database 'MyDBA' running the upgrade step from version 640 to version 641. Database 'MyDBA' running the upgrade step from version 641 to version 642. Database 'MyDBA' running the upgrade step from version 642 to version 643. Database 'MyDBA' running the upgrade step from version 643 to version 644. Database 'MyDBA' running the upgrade step from version 644 to version 645. Database 'MyDBA' running the upgrade step from version 645 to version 646. Database 'MyDBA' running the upgrade step from version 646 to version 647. Database 'MyDBA' running the upgrade step from version 647 to version 648. Database 'MyDBA' running the upgrade step from version 648 to version 649. Database 'MyDBA' running the upgrade step from version 649 to version 650. Database 'MyDBA' running the upgrade step from version 650 to version 651. Database 'MyDBA' running the upgrade step from version 651 to version 652. Database 'MyDBA' running the upgrade step from version 652 to version 653. Database 'MyDBA' running the upgrade step from version 653 to version 654. Database 'MyDBA' running the upgrade step from version 654 to version 655. RESTORE DATABASE successfully processed 1298 pages in 0.738 seconds (13.736 MB/sec).
Ain’t command-lines cool :-)
A few notes on version numbers:
655 – 2008
661 – 2008 R2
http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-13-Difference-between-database-version-and-database-compatibility-level.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx
http://serverfault.com/questions/58039/sql-server-2008-2008r2-backup-compatibility
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/f8f8db38-3c20-45e4-ae8b-4cc097eb7f0d
–jeroen
Share this:
Posted in CommandLine, Database Development, Development, Software Development, SQL Server | Leave a Comment »
the weight of a sheet of A4 paper…
Posted by jpluimers on 2010/09/20
Recently I needed to know the weight of A4 paper sheets.
So I entered “A4 paper size weight“, and found a wealth of information about paper, sizes weight and history.
Enough for a few hours of happy internet browsing. Read the rest of this entry »
Share this:
Posted in Reference | Leave a Comment »
Humans are the weakest link: HDCP Master Key Confirmed; Blu-Ray Was Cracked, but now you can remove rights management for HDCP sources
Posted by jpluimers on 2010/09/18
The human factor is always the weakest link in any rights management: HDCP Master Key Confirmed; Blu-Ray Has Been Cracked.
–jeroen
Via: HDCP Master Key Confirmed; Blu-Ray Has Been Cracked | News & Opinion | PCMag.com.
Share this:
Posted in Opinions | 2 Comments »
PDF printer drivers
Posted by jpluimers on 2010/09/17
Below is a list of PDF printer drivers, some of which I still need to check out.
Anyone having additions to the list or comments, please be welcome. Read the rest of this entry »
Share this:
Posted in Power User | 2 Comments »
Dropbox – Why cant I establish a secure connection? –
Posted by jpluimers on 2010/09/16
Dropbox can show you this message when it can’t update (and the icon in the system tray gets a red cross 
):
can’t establish a secure connection
In my case, it was because I was using the Fiddler2 tool to debug some web-traphic.
Fiddler intercepts the WinInet API layer by putting itself as a proxy in it.
The great thing is that Fiddler2 can hook HTTPS traffic.
The not so cool thing is that I forgot that DropBox routes its’ HTTPS traphic through the WinInet API too :-)
Disabling Fiddler2 enabled DropBox to start connecting 
again and finally making a good connection 
.
As soon as DropBox has a good connection, you can restart Fiddler2 again to debug your internet traffic.
–jeroen
via: Dropbox – Why cant I establish a secure connection? –.
Share this:
Posted in Development, Fiddler, Power User, Software Development, Web Development | Leave a Comment »
SQL Server: alternative to “ALTER TABLE TableName ALTER COLUMN ColumnName DROP DEFAULT”
Posted by jpluimers on 2010/09/15
SQL Server used to support the “ALTER TABLE TableName ALTER COLUMN ColumnName DROP DEFAULT”:
- SQL Server Compact 3.5 Service Pack 1 Books Online
- SQL Server CE Books Online
- SQL Server 2005 Row Versioning-Based Transaction Isolation
In the current Books Online version for the SQL Server 2005 version of ALTER TABLE documentation, the “DROP DEFAULT” has been disappeared.
In the SQL Server 2005 documentation, Microsoft already indicated that the “DROP DEFALT” would be removed in a future version.
I was surprised it already had disappeared in SQL Server 2005 Service Pack 3, especially since it is documented to be removed after SQL Server 2008 R2.
By removing this feature, SQL Server is moving further away from the SQL-92 standard.
Anyway: When you try to perform a ALTER TABLE TableName ALTER COLUMN ColumnName DROP DEFAULT, now you get this error message:
Incorrect syntax near the keyword ‘DEFAULT’.
Below is how I approached towards a solution. Read the rest of this entry »
Share this:
Posted in Database Development, Development, SQL Server | Leave a Comment »
Batch file trickery: finding the first file from a list in a certain directory
Posted by jpluimers on 2010/09/14
Using the Windows command shell, I recently needed a batch file that operated on the first occurrence of a file in a certain directory, where the filename was dynamically obtained from a list.
Wait: that sounds too complex; lets make this clear with an example. Read the rest of this entry »
Share this:
Posted in CommandLine, Development, Power User, Software Development | Leave a Comment »
Windows filename search replacement: Everything
Posted by jpluimers on 2010/09/13
When searching for files, I almost exclusively search for filenames.
This becomes easier when naming files carefully (like “20100525 – PSO – KONING en HARTMAN – Windows Embedded Standard 7 Seminar – WES7.pdf”, “The Delphi Developers Guide to C#.zip”, “20090226-Jeroen-Pluimers-BASTA-Shoot-M-Up” or “bo.Windows.Forms.SendPololuCommands.csproj”).
I know those filenames are long, and sometimes you bump into tools that suffer from MAX_PATH pathname length issues, but most built-in Windows functionality is OK with this, and the quality tools are too.
Finding files that I know is crucial for me, regardless of the file attributes (hidden, system, et cetera) or filename extension. Read the rest of this entry »
Share this:
Posted in Everything by VoidTools, Power User, Windows | 3 Comments »
The Wiert Corner - irregular stream of stuff 