***The INSTALL.SQL script in the ZIP download has been updated with this fix.***

Hi Ben,

You're right, there is a typo in the decryption routines.  This doesn't cause an issue for a...

SOME EXAMPLES

Just for giggles, let's look at some situations and see what solutions you propose:

CONDITIONS

1.  You have SQL Server 2000 on...

INTRODUCTION

Thanks for your feedback.  Your quote is appreciated, and now I provide you with one of my personal favorites:  "Those who can, do.  Those who...

I'm posting this in response to an email request for some sample ASP code to encrypt/decrypt using the DBA Toolkit.  Unfortunately it's been quite a while since I used good...

LOL.  I didn't even realize there were still places where you could be one or the other and not at least a little bit of both...

That's probably in the TOP 20 (no pun intended) of the all-time most requested T-SQL improvements, and someone at Microsoft agrees with you...  SQL 2005 includes a new SELECT TOP (@var) syntax without...

Thank you   The next one should be out in the next couple of days.

Very nice article!  Any chance of a follow-up demo of some sort?  (I'm a really visual person   )

Thanks

You'll want to definitely look into hot-swappable RAID and a fail-over cluster solution with your second server.  Properly configured, this will make a failed server as transparent to your users as possible.

Also,...

Does the Database Mirroring work now?  Last I heard Database Mirroring was turned off in retail versions, and MS would only allow you to turn it on (supported that is)...

The high-performance model looks adequate.  The bare bones minimum model does not.  Make sure you get hardware RAID and enough physical/logical storage capacity.  There are always better models for almost...

Hi mwcarey, the new version is up at http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart1.asp.

Thanks,

Michael Coles

No problem and thanks for the feedback.  There are about 3 dozen XP's and UDF's in the Toolkit that I'll be covering in upcoming articles.  They are all discussed in the...

Don't forget storage.  You didn't completely answer the question about historical data storage requirements.  Based on saving 28,000 transaction records per day, you need to multiply that by n days...

Tried it once myself, it's a serious hassle.  Ended up just rebuilding the thing.