The Multifunctioning DBA:

October, 2012


October 31, 2012  10:00 PM

Have a happy and safe Halloween



Posted by: Colin Smith
Database

Today is Halloween and I just want to say I hope you have fun and be safe. This is the first Halloween for my kid and I can not wait to see him all dressed up in his Sock Monkey costume. I think that I will just stay at home this year and hand out candy with my wife and my boy. He is only 10 months...

October 31, 2012  8:49 PM

Pay TV



Posted by: Colin Smith
Database

For a few years I went without paying for cable or satellite television. It cost me some money up front, but I was able to save about 2500 dollars after all my expenses based on a 100 dollar per month cable bill and the amount of time that I was not paying. Recently, I have connected again....


October 31, 2012  8:30 PM

Another Delphix Bug



Posted by: Colin Smith
Database

To use Delphix for SQL Server, you must use ISCSI disk. This is not really an issue, but Delphix does not automatically set ISCSI up to automount as I think that it should. So the other day, I had to reboot my PPT server, that is the one with the databases in a recovering state and always applying...


October 29, 2012  5:00 PM

Use Cases for Delphix



Posted by: Colin Smith
Database

The other day I talked about Delphix. I think this is a great product and I have talked about how it can save you, the DBA time and money.  You want to save time...


October 29, 2012  3:37 PM

Flexible Job



Posted by: Colin Smith
Database

Since I am getting old, lat night I was thinking back to my youth and how I thought that working at McDonalds was great. Or any place really. I just thought that having a job to go to every day was great, and do not get me wrong, it is. Any job is a good job and I do not put myself above doign...


October 26, 2012  8:25 PM

What is Delphix for SQL Server?



Posted by: Colin Smith
Database

Delphix, simply put is a database virtualization tool. That is what it does and you may ask why is that meaningful and why would I ever want to use something like this. I have many answers to that question and I am sure that others have many...


October 24, 2012  9:45 PM

Database Virtualization



Posted by: Colin Smith
Database

Now that the vendor of the software that I have been Beta testing has gone public for SQL Server support, I do not feel that I have to hide who they are. Delphix is the vendor of the virtualization platform. Go check them out. They are doing some really cool things...


October 24, 2012  9:36 PM

Haunted House



Posted by: Colin Smith
Database

This year I decided to go to a haunted house. I thought it would be a lot of fun and I was hoping that it would be scary as well.So I went to the 13th Floor here in Phoenix. This is supposed to be one of the better haunted houses in the country. I got some...


October 24, 2012  9:22 PM

PowerShell CName Reporting



Posted by: Colin Smith
Database

Recently my team started using CName records instead of server names for applications to connect to. This makes moving things around on backend much easier. So here is the script that I am using.   Snapin SqlServerCmdletSnapin100 Add-PSSnapin...


October 23, 2012  7:30 PM

Virtualization Issues



Posted by: Colin Smith
Database

We recently had our bits upgraded to the latest and since that we have had some issues with the product. We have run into issues where the SQL Server that has copies of your databases in a restoring state, have stopped grabbing the log backups and applying them. This is an issue as it has made me...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: