The Multifunctioning DBA:

October, 2010


October 31, 2010  12:00 PM

Happy Holloween

Colin Smith Colin Smith Profile: Colin Smith

Here is where I hope to be. Have Fun Be Safe and eat a ton of Candy. http://www.frightened.com/

October 30, 2010  12:00 PM

Delete in Batch

Colin Smith Colin Smith Profile: Colin Smith

Today I needed to delete 28 Million Rows from a table and I did not want to do it as one large statement because that would kill my log. Here is what I did. --Set your rows to deal with DECLARE @intloop int Select @intloop = count(*) from Table where Column < Something While @intloop...


October 29, 2010  12:00 PM

PASS Streaming Key Notes

Colin Smith Colin Smith Profile: Colin Smith

If you can not get to the SUMMIT this year you may want to watch the streaming keynotes. PASS is awesome to do this and if I was not going to be there in person I would be watching. So here is a link to register to watch.


October 29, 2010  8:00 AM

Fun with SSIS

Colin Smith Colin Smith Profile: Colin Smith

So I am working on a project and in this project I am getting more and more exposure to SSIS. This is fun but can be frustrating. I am working on setting up configuration files for connection strings for all the packages. This is pretty simple in BIDS to set up but when I want to move the files to...


October 28, 2010  11:00 PM

SQL Server Monitoring

Colin Smith Colin Smith Profile: Colin Smith

I am getting back into writing my monitoring application in powershell and I have made some progress over the last few days. I have figured out my issue with getting the backup dates and times inserted into my monitoring database and also not entering the information multiple times if I already...


October 28, 2010  9:58 PM

Powershell change color of text

Colin Smith Colin Smith Profile: Colin Smith

I am working on a script that accepts some user inputs and then echos that back to the user for validation. For this I wanted to make the text that the user submitted be in RED so that it would stand out and make it more readable. I was looking for a way to use this doing echo and echo is an...


October 22, 2010  10:00 AM

Create Random Password and update AD account

Colin Smith Colin Smith Profile: Colin Smith

Not to long ago I was asked to write a script that would create a random password and change an AD account to use that new password. The requirements were that the password be 3 uppercase letters 2 numbers and 3 lowercase letters. Here is what I did.


October 21, 2010  4:30 PM

PASS Summit 2010

Colin Smith Colin Smith Profile: Colin Smith

Now with just about 2 weeks left before the big summit I am getting very excited. I have received my hotel confirmation and I also booked my flights last week so I should be ready to go. Also, I have been looking at all the sessions and all I can say is that I need more of me so I can be in...


October 21, 2010  10:00 AM

Last Month

Colin Smith Colin Smith Profile: Colin Smith

I must apologize for my lack of blogging last month. I was busy moving and the house that I purchased has required a large amount of TLC. I think that my wife and I have it livable now. We had  to redo some of the flooring, we went with stained concrete and love it so far, and we have had to do a...


October 20, 2010  7:30 PM

Fantasy Teams

Colin Smith Colin Smith Profile: Colin Smith

A while ago I mentioned that I was doing a fantasy football league for the first time. It has been fun but I have found that I am not good at it at all. I am in 11th place in the league right now and that...


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: