Are All Test Environments Created Equal?

I don’t know about your environment, but at mine we have two classes of systems: Prod and Test.  So as you can guess, anything that is not Prod is Test.  That’s a pretty simple definition.  Further defined anything that has a DR priority of 6 or less is PROD and anything 7 or greater (or [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments
AD

Home PC Backups

I have been noticing a scary trend over the last few years.  Home computers have gone from a techno-toy (like a DVD player) to an important part of everyone’s life.  I have also noticed that computers are becoming 5 year assets.  People are replacing them every 5 years.  Today they are inexpensive enough to do [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Renaming a SQL server

Here’s a little simple one that I’ll probably need again, so I thought I’d just blog it:
How to rename a SQL server used mostly when the windows server it resides on changes names:
To change the name of a default instance of SQL, run the following procedures:
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
To change the name of a named [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Cleaning up the disk

When I became our companies MSSQL DBA I inherited an smooth running machine.  My predecessors were extremely talented and their scripts did everything we needed done.  But I can’t just live off their hard work, I need to leave my mark on the environment.  So I am tweaking some of their scripts to get rid [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Blog Direction

I was looking over my blog and I noticed that it was heading in a direction I didn’t like.  I had stared down the path of a whiney, ranting, complaining, negative blog that way too many blogs have gone.  So I am stopping it now.  I need to get more SQL and positive posts to [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments