Jayme Davis' WebLog

Playing games so you don't have too...

Browse by Tags

All Tags » Database (RSS)
Sorry, but there are no more tags available to filter with.
Grant me the serenity.... SQL crosstabs
Ever noticed what a pain building crosstabs in SQL can be?... sure, you can buy 3rd party products to do it for you (even some that are only $39), but what if you want to do it yourself? MS Access has the TRANSFORM function that makes life easy.... why...
ParseNameString
Well, I'm pretty sure someone is going to tell me I didn't have to do this complicated way, but.. too late! :) I looked around the internet for a SQL parsing function that would parse to proper capitilization, but no luck. I'm lazy, so I decided too write...
SQL Compare tools
Dealing with 10+ databases, terabytes of data, and enormous DTS packages on a daily basis, I couldn't live without a SQL database comparison tool. I was reading an article about Red Gate software's SQL tools suite which includes SQL Compare (database...
Teradata
I'm curious if any of the 3 people reading this blog have ever used teradata with .NET... or for that matter, used teradata for warehouse solutions. With Oracle, SQL DCE, Teradata, and the others available today, what *really* performs the best? (stable...
More Posts