Write to a text file from MS SQL Server

There are several things you need to know to be able to do this.

  1. How to enable ad hoc queries.
    This guy enable-Ad-Hoc-Distributed-Queries shows you how.
  2. How to format the driver string and specify your directory and filename. Like this:
    OpenRowset(‘MSDASQL’, ‘Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=c:\MyDirectoryName;’,’select * from MyTextFile.txt’)
  3. How to create a text file in the right format. This format works:
    “value11”, “value21”
    “value21”, “value22”

There. That was only slightly unreasonably difficult. Now you can

Select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=c:\MyDirectoryName;','select * from MyTextFile.txt')


Insert into OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=c:\MyDirectoryName;','select * from MyTextFile.txt')
Values ('Col1', 'Col2')

Switching between Visual Studio .Net and Mono with MonoDevelop

For reasons best not examined too closely I switch between between Mac and PC which, since I earn my crust largely with .Net development, means switching between Visual Studio and MS.Net and MonoDevelop with Mono.

Mono is very impressive, it is not at all a half hearted effort, and it does some stuff that MS haven’t done. But when switching environments, there’s always the occasional gotcha. Here are some that have got me, and some solutions.

Gotcha: Linq Expressions don’t work on Mono

Solution: Add a reference to System.Core to your project.

Question: What version of NUnit is built in to mono?

As of Feb 2011, it’s nunit 2.4.8.

Restore files from an Apple Time Machine Backup to Windows

As noted in Reading a Mac OS X disk from Windows if you can plug your Mac OS X drive into your Windows computer then you can use HFS Explorer to read it.

This works fine for Apple Time Machine Backups: look for the directory called /Backups.backupdb/ and within that, the name of your computer. You’ll find dated directories of your backups. If you’re just after the most recent version of your files, then look for a directory called “Latest”.

It’s quite clever — the folder for a given date shows you not just files backed up on that date but everything that was on your original disk at that date. The magic of file system links.