This is a follow up to my previous post How to Convert Taxware Tax Exempt Certificates to Vertex Tax Exempt Certificates. In that post, I described the four steps I used to get Taxware exempt certificate information into the Vertex system’s database: [Read more…] about How to Parse ADP Taxware Exemption Certificates
I’ve been studying for my MCTS Examp 70-448 the last month and a half and have found my ability to block things out and focus for long stretches of time to be lacking. And I don’t think it is the somewhat dry nature of the material. I’m tackling an engaging book on a different topic in my spare time and find the same thing — my attention seems much less disciplined than it used to be. [Read more…] about Relearning to Concentrate
As part of a project at work last year I had to convert ADP Taxware tax exempt certificates to Vertex tax exempt certificates. I searched the web and didn’t find any information on how to go about doing this. I have to believe that somebody has tackled this situation before and applied a much more elegant solution. But sometimes you just need to get something done regardless of how “pretty” the solution is. [Read more…] about How to Convert Taxware Tax Exempt Certificates to Vertex Tax Exempt Certificates
Make sure when you are doing maintenance work on SQL Server (or any application) that you have the installation files handy. Although you might never need them, you’ll be happy the one time maintenance goes bad and you need to rebuild something.
I have a SQL Server 2000 I need to upgrade to SQL Server 2005. In considering different ways of doing this (side-by-size, overlay, move to a new machine entirely) I set up a SQL 2000 instance on a DEV server and started playing around with the master database. Here are a couple of things I encountered that are worth sharing. [Read more…] about Working With the Master Database