Well, I feel it is important to put together a toolkit of controls to use when developing for a client.  One of the controls I have created is the Textbox Filter Extender which will allow you to limit a textbox to numeric, alpha, or alphanumeric characters.  I've post the control for anyone to have access to and use.  Free free to check it out over in the development tools section.   If you have any questions, comments, or suggestions for improvements please post them to the proper forum section.

Well I passed the 70-228 exam which means I am one test away from my MCDBA.  The best part of it is that I am done with the SQL tests so now I get to focus on what I prefer more, which is development.  To study I used the Microsoft Press book: MCSA/MCSE/MCDBA Self Paced Training Kit: Microsoft SQL Server 2000 System Administration.  I selected this book simply because it appeared to be the best of the poor quality of books out there.  It was a rather boring read, and the hands on training involved running a bunch of prewritten scripts that were sometimes not explained very well.  I passed though, which is what matters.

   What I have decided though is that instead of providing me with an evaluation copy of SQL Server 2000 (or for that fact the software for what ever test you may be studying for) the publisher should provide the reader with a virtual pc image of what is required for the test.  For example all of the exercises in this book expected SQL Server 2000 running in a domain with a specific domain/computer name.  Also, several exercises required specific domain users be setup.  I would assume that most people do not have a setup like this unless they are studying on company time, and even if I did have a setup like this I wouldn't want to be messing it up adding unneccessary users for use with the exercises.  Now that Virtual PC is free it would be great for this particular test to have been provided with a virtual image of Windows Server 2003 (feel free to have it expire in 6 months like it would if I downloaded the eval copy) along with the install files for SQL Server 2000. (For this particular test installing and setup are part of the test hence not having the software already installed.  For the 70-229 test the server could already be installed as that is out of scope of the test.)  The server could then be preconfigured with the proper naming conventions and users which the setup of is completely out of the scope of the test.  This would allow the user to focus more time on the topics covered in the exam and not on the environment.  I would have to think that something like this would make all of us very happy.  Let me know what you think!

Well I realize that I have fallen extremely far behind and have not finished my tutorial on putting together y DVR setup.  Hopefully I will get to it someday, but now that the steps are no longer fresh in my head it may not happen until I need to build a new box.  If you do have any questions feel free to post a comment and I’ll help you out the best I can.

What I will post about are the steps I need to take to update my box for the new DST settings.  (I hope the energy savings from the change makes up for the pain in that it has been, and the old electronic equipment I have that will now always be off.)

First off check to see what your system is currently set to:

#zdump -v /etc/localtime | grep 2007

Using this command from root will provide you with the dates your system has set for daylight savings time.  If it isn’t set to start in March then continue.

Go to the home directory for root, use ‘cd $HOME’ if you are still logged in as root and download the patch:

#wget http://debian.oregonstate.edu/debian/pool/main/t/tzdata/tzdata_2007b-1_all.deb

Now you just need to install the patch.:

#dpkg --install tzdata_2007b-1_all.deb

Finally, if you run the check again:

#zdump -v /etc/localtime | grep 2007

You should get the following output:

Sun Mar 11 07:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 CST isdst=0 gmtoff=-21600

/etc/localtime  Sun Mar 11 08:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 CDT isdst=1 gmtoff=-18000

/etc/localtime  Sun Nov  4 06:59:59 2007 UTC = Sun Nov  4 01:59:59 2007 CDT isdst=1 gmtoff=-18000

/etc/localtime  Sun Nov  4 07:00:00 2007 UTC = Sun Nov  4 01:00:00 2007 CST isdst=0 gmtoff=-21600

If only it was as easy to do with all my other equipment.  Specially thanks to everyone at the KnoppMyth Forums for posting the information on this.