Category Archives: Software Development

Rule of 5 : Better machines for Developers

I have just invented the "Rule of 5" when it comes to justifying a computer upgrade for a developer. 5 compiles an hour (when you’re actually developing code (like you love to do) and not in some meeting).Each compile saves … Continue reading

Posted in Software Development | 1 Comment

SVN (Subversion) case sensitivity issue with Linux (RedHat) SVN Server and Windows Client

I had a weird subversion (svn) issue today. Here are some clues (for future googlers). "svn: Can’t open file" ".svn\tmp\text-base" "svn-base" "The system cannot find the file specified".svn: Can’t open file .svn\tmp\text-base svn-base The system cannot find the file specified … Continue reading

Posted in Software Development | Leave a comment

Sql Server Data to a Jet Database

Ok.  This is another "not rocket science" blog.But if/when you need it, it is good to know the syntax. Basically, this will run a tsql query and dump the data into a jet database.  ("access database" is another way to … Continue reading

Posted in Software Development | Leave a comment

BCP Export

I found this one in some old code, and decided to post it. Not rocket science, but very handy sometimes. The below is a "fixed width" export, using bcp. The syntax sugar for "fixed-width" is the cast to a char(SomeNumber) … Continue reading

Posted in Software Development | Leave a comment

CTE Running Total Example

I happened across a CURSOR based “Running Total” example on the web today. Everyone with whom I work knows I detest Cursors in TSQL.  So I coded up (one) alternate solution. Below is (one variation) of a ‘Running Total’ solution … Continue reading

Posted in Software Development | Leave a comment

SQLCMD (Simple Example)

    Download example HERE. (<< Right-click. "Save (Target) As" usually works best). If I haven’t mentioned it before, thank you Microsoft for the sqlcmd.exe utility. If you are new to sqlcmd or new to the concept of repeatability, below … Continue reading

Posted in Software Development | 2 Comments

Update TOP (N) (ORDER BY) Example

  We all know a SELECT TOP(N) (ORDER BY) statement will work.   Use NorthwindGOselect top(10) * from dbo.Orders ORDER BY CustomerID , OrderDateGO However, if you’ve tried to do a:   Update TOP (10) …… ORDER BY X   … Continue reading

Posted in Software Development | Leave a comment