The Multifunctioning DBA:

October, 2012

October 31, 2012  10:00 PM

Have a happy and safe Halloween

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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...

October 29, 2012  3:37 PM

Flexible Job

Colin Smith Colin Smith Profile: Colin Smith

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?

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

October 23, 2012  7:30 PM

Virtualization Issues

Colin Smith Colin Smith Profile: Colin Smith

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: