Since we work on ALL flavors of MS SQL from 6.5 on up, the question is always out there - "why upgrade to a newer version?"  Note that although we are a Microsoft Partner, we prefer to take a look at their products from an Programming/End-User perspective.  SQL Server Central just popped out an nice simple article on the main reasons to upgrade (http://www.sqlservercentral.com/columnists/sjones/2988.asp) for an existing installation.  Note that there are MANY more improvements that are NOT listed in the article, but these are many of the main reasons for an upgrade (vs. an entirely new DB/front-end that can take advantage of the newer functionality without necessitating a whole re-write).

     No, we're not turning into theoretical or cryptographic mathmaticians, but this is a fascinating theory (if you don't know it, check out WikiPedia: http://en.wikipedia.org/wiki/Diffie-Hellman_key_exchange).  We actually just applied the Diffie-Hellman logarithm to a light-weight security socket channel transmission and it works the dream. 

     I'd hate use an overtired metaphor, but it's elegant in it "simplicity" (if you're a cryptographer).  Today, ComputerWorld published a brief interview with Whitfield Diffie : (http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=299992&intsrc ...

Yes, we're on virtualization constantly (as that is what is currently driving newer/lower costs), and this new idea looks like it has potential:  a silver box with USB and keyboard, video, and mouse (hence KVM for those who haven't heard the term before) and a NIC (network interface card).  Its called a Pano and the thing only draws 5 watts and is SUPPOSED to be every bit a virtual machine.  Pricing is not disclosed (supposed savings of 70% TCO over 3 years for a total savings of $3200 which would work out to a total of $40.00 per month per PC if the math works...), and of course you need a server to host the Pano Server on.  Its in Alpha now and supposed to be available by September... http://www.panologic.com/

Ok, lets face it - most databases in the world are of a size that who cares how they are designed or how a backup strategy is implemented as long as they have ACID, referential integrity, and some basic data-typing for basic validation of entries, and a routine complete backup (yes, I know, lots of other reasons, but stay tuned, because this is not a theoretical disucssion on databases).  With a 2 MB (or even a 20 GB) database, most structure changes can take effect almost immediately and do not tax any harddrive that has been manufatured in the past 4+ years.  But what about the 250 GB database?!?!  Its huge, it fills most disks (though again this is changing), and changes take hours/days to propogate.  Here's some tricks we learned for dealing with the monster DB's (please note that the links may expire, but the practices and "buzzwords" should be around to be googled for a good long time):

& ...

With the trends towards virtual computing and AJAX/fully-interactive sites rapidly accelerating, one company has married the 2: Ghost, Inc.  Located at http://g.ho.st/, the product has an "online OS" that is supposed to leave nothing (aside from the history of their website url) on the local machine.  Pricing is free (to 2 GB we think), and a very quick test-run on the Alpha version showed its potential (as well as quite a few bugs).  Since its still Alpha, NOT the thing you want to depend on, but enticing to watch for the future.

Yes, forgive the month-long delay (our clients' needs come first!), but our website is backonline.  We're in the midst of redesigning the TMCentral website to provide more content and information; one of these major changes is here... right here - a tech blog.  This is where we will update new products we've heard about, looked at, tested, or used.  Every day there are many, many highly intelligent people creating LOADS of products that do a particular function for less money (often free in the case of most open-source) and/or more efficiency than ever.  This blog will update you on what we find that fits!