I feel the perl script was kind of a waste. It didn’t take me long to generate, and I would have done it all in SQL if I only knew that you could execute programs inside SQL. I did a little more searching and found that you can do the same thing using the xp_cmdshell [...]

Today I was looking for a way to backup the structure of a SQL server for Disaster Recovery purposes (say the building catches fire and the servers are destroyed). The best thing is to have a solution in place that backs up the data to tape or some other storage solution. Sometimes it’s a good [...]

I scoured the internet for hours trying to find an efficient way to export to excel from a datagrid in VB.NET that will prompt the user BEFORE the extract occurred and would NOT prompt the user after the extract occured. I also wanted all the objects to be disposed of so that the garbage collector [...]

I was having a problem earlier today relating to the way that you query a field in SQL to return fields that didn’t contain any numbers. There are various ways to do this, but they all seemed lengthly and inefficient. I stumbled upon a SQL function called PATINDEX, which allows you to use wildcards to [...]