Should you upgrade to Windows Server 2008?

(May 31, 2008)

There is a lot of hype in the IT industry when it comes to new releases of products. Look at the iPhone, Windows Vista, WiMax, OSX Leopard, etc. Hype is a part of our culture. Being able to sift through the hype and make a logical decision is what separates a sound business decision from [...]

::

Is the database tape backup dead?

(May 31, 2008)

With the ever increasing hard drives, SAN, and NAS devices available, is the tape backup dead for database backups? In my travels, I find more companies are backing up to disk rather than older tape technologies for their database backups.
What are you doing at your company to backup your databases whether they are Oracle, [...]

::

What version of SQL Server are you running?

(May 31, 2008)

I have run into the situation several times where I had to determine which version of SQL Server 2005 is running (including service pack). To accomplish this task, connect to the SQL Server Management Studio and run the following TSQL statement:
SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)

::
Next Page »