SQL Server BCP and Phantom CRLFs

Microsoft SQL Server comes with bcp.exe, a command-line tool that uses the Bulk Copy Program API. It allows to export data from tables and queries, import data from files into tables and it generates format files. Bcp comes with a lot of command line parameters. Find them all here. The tool is very convenient if you want a […]

Read More SQL Server BCP and Phantom CRLFs

3 OS X Tips for Windows Users

If you’re rather new to OS X, coming from or still living in a world dominated by Windows just like mine, you’ve probably run into the following trivial questions: How to cut and paste (move) files in Finder? How to lock the screen? How to restore windows using Command+Tab? Here are the short answers. Cut […]

Read More 3 OS X Tips for Windows Users

SQL Server 2008 R2 – The performance counter registry hive is corrupted.

Sequel number four (yes, 4!) of the SQL Server 2008 R2 installation woes saga. Previous posts include: Version string portion was too short or too long Error code: 1605 Version’s parameters must be greater than or equal to zero This post discusses the following error which appears in Summary_%computername%_%date%_%time%.txt, located in C:\Program Files\Microsoft SQL Server\100\Setup […]

Read More SQL Server 2008 R2 – The performance counter registry hive is corrupted.

SQL Server 2008 R2 – Version’s parameters must be greater than or equal to zero

A third (!) and hopefully final blog post on SQL Server 2008 R2 deployment woes. Previous posts include SQL Server 2008 R2 – Version string portion was too short or too long and SQL Server 2008 R2 – Error code: 1605. This time the installation problem comes with the following beauty: Exception type: System.ArgumentOutOfRangeException Message: Version’s parameters must be greater […]

Read More SQL Server 2008 R2 – Version’s parameters must be greater than or equal to zero

SQL Server 2008 R2 – Error code: 1605

Yet another post on SQL Server 2008 R2 deployment woes. An unattended installation of SQL Server 2008 R2 – developer/management tools on Windows XP SP3 clients in this particular case – might fail with the following error: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{0A869A65-8C94-4F7C-A5C7-972D3C8CED9E}’. Error code: 1605. The error appears in […]

Read More SQL Server 2008 R2 – Error code: 1605

No Compatible Drives in CDBurnerXP

I’ve been using CDBurnerXP since day one. It’s a no-nonsense CD/DVD/ISO burning tool for Windows and it’s freeware. It supports Blu-Ray and HD-DVDs. On my HP 620 laptop with Windows 7 Professional 64-bit, version 4.3.8.2568 of CDBurnerXP doesn’t recognize the internal burner, an HP DVDRAM GT30L according to devmgmt.msc, although it is listed as compatible here. […]

Read More No Compatible Drives in CDBurnerXP

Command Line Goodies – Part II

As a sequel to Command Line Goodies – Part I, here’s another trio of helpful tools I quite often use. Nslookup Use Nslookup to query DNS servers. The following example will retrieve all DNS records from the primary DNS server as configured in TCP/IP settings (or obtained by the DHCP lease): nslookup -“set q=any” google.com […]

Read More Command Line Goodies – Part II