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 the rest of this entry »
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 the rest of this entry »
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 the rest of this entry »
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 the rest of this entry »
The first speech you give when you join Toastmasters is called The Icebreaker. It’s designed to ease you into public speaking. The assignment is to speak for 4 – 6 minutes about yourself.
Creating the speech was more challenging than I thought it would be. But the writing was fun and so was delivering it.
Here is The Icebreaker I gave tonight. Read the rest of this entry »
I’ve been working with PHP and MySQL since the beginning of my career. I’ve hosted numerous customer sites and personal sites with a few different hosting providers over the years, including Pair.com, HostMySite.com and GoDaddy.com. All of those have been decent but seemed to have quirks that left me looking for something else. I’ve been using HostGator for about 5 years now and their Baby Croc service has met my needs in every way. Read the rest of this entry »
When I started this blog, I had two objectives in mind. The first was to have a technology journal to keep track of things I didn’t want to forget. The second was to have my name come up in any Google searches a potential employer, client or partner might make and to provide some information about me and what I do. These were both professional objectives and I’ve long been aware that the site is good mostly for the yawning it inspires. Read the rest of this entry »
One of my hobbies is web development, which was actually my foot into the door of technology as a career. Last night I attended the Manchester/Hartford Area Web Devs/Innovators. Here are some random thoughts and links to follow up on things discussed during the meetup. Read the rest of this entry »
I’m sure there are other ways to do this but this is pretty easy:
DECLARE
@SPID INT,
@Handle binary(20),
@retVal varchar(8000)
SET
@SPID = 148
SELECT
@Handle=sql_handle
FROM
master..sysprocesses
WHERE spid = @SPID
SELECT
SqlCommand=convert(varchar(8000), [text])
FROM
::fn_get_sql(@Handle)