The Multifunctioning DBA:

November, 2010

November 29, 2010  10:00 AM

SQL Saturday Presentation and PASS

Posted by: Colin Smith
SQL Saturday

When I first heard about the SQL Saturday event in Phoenix being postponed I was really bummed out and thought that I might just skip it and not do a presentation. Then I went to the Summit and I was inspired again. But another thing that I got out of it was some great help on what to expect as a...

November 28, 2010  10:00 AM

How PASS inspires me

Posted by: Colin Smith
Education, PASS

I was very lucky and my company was nice enough to send me to the PASS Summit and I can not thank them enough for that. When I was getting ready to go to the Summit I was like a kid on Christmas Eve. The anticipation was killing me and I could just not wait to get to the event and have fun and...

November 27, 2010  4:00 PM

Getting My Slides and Demos Ready

Posted by: Colin Smith

Working on setting up for my first Presentation and man, at first I thought that an hour was too long a time to stand up and talk about powershell in front of a large group. But now that I am getting into it again I do not know that an hour is enough time. It is so hard because I do not know how in...

November 27, 2010  10:00 AM

SQL Saturday Phoenix Sessions

Posted by: Colin Smith
Education, Free Training, SQL Saturday, SQL Saturday #47

I just checked out the SQL Saturday Phoenix Homepage and I was very impressed by the number of submitted sessions that are on the board and we have a couple of sessions that have been suggested as well. If you head over to the

November 26, 2010  8:00 PM

SQL Saturday 47 Phoenix

Posted by: Colin Smith
Education, PASS, SQL Saturday, SQL Saturday #47

So, I hope that you have all heard that SQL Saturday Phoenix is back on!! The event was postponed originally because the weather here in Phoenix is so HOT in July. So the Event is now set for Saturday February 19th at

November 26, 2010  2:50 PM

Day After Thanksgiving

Posted by: Colin Smith
Good Will, Holiday, Woriking

I hope that you all had a great holiday and that you did not do any work. Any way, by the time this post is published I will be sitting at my desk working on Black Friday. My wife hates that I work on the days after holidays most the time and I agree that it is not always the most fun to get up in...

November 25, 2010  10:00 AM

Happy Turkey Day

Posted by: Colin Smith

Just wanted to say Happy Thanksgiving to all and I hope that you are all safe and have a great holiday. Hopefully you are not working on DBA issues today. :)

November 24, 2010  6:52 PM

Find Database Files with Powershell

Posted by: Colin Smith
Add new tag, DBA, Powershell, Scripting

I recently had a request to go out and find the logical name and the physical name of mdf and ldf files in sql server. I thought this might be a good place to use powershell and the invoke-sqlcmd cmd-let that is with sqlserver2008 snapin. Here is an example of what I did to find the files for...

November 23, 2010  7:05 PM

Powershell Find Files modified after a date

Posted by: Colin Smith
Filesystem, Managment, Powershell, Scripting

I recently needed to find all files in a specific directory that had been written to after a specific date. I also wanted to include all subfolders in the search. I decided to use Powershell to do this and man was it simple. First you have to define the date that you are looking for and you have to...

November 22, 2010  3:13 PM

People at PASS

Posted by: Colin Smith
Education, Networking, PASS, PASS Summit

I thought I would focus this post on the People that were at the PASS Summit. Really not much to say except the people are a huge part about why my PASS Summit experience was so great. I mean you obviously have access to many smart people like MS employees and some great MVP's. That alone is great...

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: