programming, sql server

SQL Server (2008) Performance Tuning Resources

Here is a (running) list of some SQL Server Performance Tuning resources that I’ve compiled over the past week or so.  These have been helpful in educating me on the black art of database performance tuning.  I realize the title states SQL Server 2008, but really most of these probably apply for SQL Server 2005 and 2008.  I, particularly am…

Continue Reading

programming, software, sql server

SQL Server 2008 RTM released!

Not that I think I’m breaking any news here, but SQL Server 2008 has been officially RTM (released to manufacturing).  So far I’ve been very pleased working with SQL Server 2008 and am excited to get my RC0 version updated to an official release. One thing I stumbled across was a warning users to wait for Visual Studio.NET 2008 SP1…

Continue Reading

family, mac, programming, software

2008!!

Wow, it’s been quite a while since I’ve posted.  It was just into 2008 back in January.  Wow how time flies! Well, 2008 has brought many new versions of the tools that I use on a daily basis for my job.  Visual Studio has a 2008 version out.  Microsoft SQL Server has their 2008 version out (well, RTM will be…

Continue Reading

programming, software

Testing email when working with no SMTP server

Happy New Year! While this tip isn’t my own, it still seems as though it will be very helpful.  I know that I do a lot of development locally where I don’t have an SMTP server setup.  This tip, courtsey of .NET Tip of the Day, really will eliminate that problem and allow you to work with email without the…

Continue Reading

.net, programming

VB.NET RC4 Encryption for database storage

I recently had to upgrade some Classic ASP code to .NET for some data encryption.  The routines use RC4 encryption and make the result database friendly.  The following class can easily be dropped into your project for use with little effort.  The sample code shows the encryption and decryption methods.  You just provide the message and the key for either…

Continue Reading

CMD Email, programming

CMD Email updated

The email command line utility I wrote (and discussed here), CMD Email, has been updated.  The latest release supports email attachments. You can download the latest runtime or source from the project page on CodePlex.

CMD Email, programming

CMD Email – command line email utility

I’ve completed my first open source project.  I have been wanting to put something out on Codeplex for a while and finally got around to it.  The project I released is a small little command line email utility that uses the .NET 2.0 framework.  I wrote a more simple version of this years ago to email me when Windows scheduled…

Continue Reading