A while back, I spent about a month working through several SQL Server performance issues after upgrading three systems from SQL Server 2000 to SQL Server 2005. During that time I would realize that my knowledge of how SQL actually manages data at a low level was sketchy. In the process of resolving said sketchiness, I came across a few resources that proved helpful. [Read more…] about Resources for Learning More About SQL Server Internals
Technology
Naming Conventions for Servers
This is a quick PSA on naming conventions for servers. I’m going to give you a quick “don’t ever do it like this” example to start. [Read more…] about Naming Conventions for Servers
The Twitter Engineering Blog
If you are technical minded, the The Twitter Engineering Blog is a fascinating read. I love seeing how others have handled tough technical problems. Twitter has had to solve a lot of them and I’m sure there are plenty more on the road that lies ahead, so the blog should be interesting.
Technical Support and Troubleshooting
In 2007 I did a one year stint providing technical support to our clients. During that time I put together a one page guide on support and troubleshooting to help other people. A little later that year, I spent time training in Kepner-Tregoe’s KT Resolve process. KT Resolve was a lot more in depth than what I came up with but similar in a couple of ways. I found KT Resolve to be a thorough process but too formal and heavy for most situations I encountered. [Read more…] about Technical Support and Troubleshooting
How to Parse ADP Taxware Exemption Certificates
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
How to Convert Taxware Tax Exempt Certificates to Vertex Tax Exempt Certificates
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