Tuesday, October 25, 2005 #

Have I mentioned???????

That EMC sucks!!!!  :)  We lost yet another hard drive today on the CX-700.  I would say I'm surprised, but lightning would strike me dead on the spot. 

We are buying EMC Replication Manager, which will allow us to save a LOT of disk space.  We currently have multiple copies of production for QA, UAT, Release, Enhancement Release, Mirror for parallel testing, Development, Backup, and Testing.  That consumes a considerable amount of space.  The SnapView technology from EMC lets you make a copy of production.  You can then have one of the other environments look at a “snap” of that copy.  The snap takes up about 15% of the original copy size, AND you can refresh it in a few seconds to make it look like the copy when you originally refreshed it.  The advantages of this are obvious in a rapid development environment. 

Adding Replication Manager will allow us to mount multiple snaps of the same LUN or copy onto the same host.  This will allow us to save space on consolidated QA, UAT, Mirror, ER, and Test server because instead of each environment having it's own copy of production, we will be able to maintain one or two copies and all the environments snap off those.  The cost in disk space will decrease by thousands of dollars, paying for the product in the first six month.  In addition, the flexibility to add additional testing and training environments will increase as disk space is freed up.

Anyway......just thought the world might want to know.  We have several terabytes of SQL Server disk space.  Anytime, we can find a way to add flexibility to the environment and lower the overall space cost, it's huge. 

posted @ Tuesday, October 25, 2005 9:44 PM | Feedback (1)

SQL Server 2005 September CTP

We are now running full-speed with SQL Server 2005 at work.  I have my team testing the new features and spending part of each week learning the technology.  I've been telling everyone how much there is to learn.  If you are a database manager with SQL Server and do not have your people ramping up, you should be shot (2 cents thrown in there).  They are currently focusing on reporting services, SSIS, and analysis services, as those represent the major push my department will be making over the next 15 months.  It'll be interesting to see how we can effectively leverage the new technology to replace our current reporting systems.  I'm also looking forward to the operational and maintenance improvements that will make it easier to identify performance needs, track deprecated stored procedures, etc.


posted @ Tuesday, October 25, 2005 9:32 PM | Feedback (1)