The Multifunctioning DBA:

December, 2010

December 31, 2010  12:00 PM

Happy New Year

Posted by: Colin Smith

I hope that you are all out having fun and not reading my blog today.  I also hope that you all have a great time and have a great new year and most importantly be safe and do not drive drunk

December 30, 2010  10:00 PM

New PS Project

Posted by: Colin Smith
Add new tag, Exchange, Powershell

I have just been informed that I have to come up with a way to create a Dynamic Distribution Group in exchange. I have the criteria but I have no clue what a Dynamic Distribution group in and how it is different then a Distribution Group. So off to the learning I go but I think this will be fun and...

December 30, 2010  4:50 PM

PASS Summit DVD’s already helping me out

Posted by: Colin Smith
DVD's, PASS, Sessions

So I just got my DVD's on Tuesday after getting back to the office after vacation. I have watched a few and all that I have seen are very good. But I must point out the session called "Transactional Replication: Beyond the Basics" by Kendal Van Dyke (

Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 30, 2010  8:35 AM

DB Corruption found by DBCC

Posted by: Colin Smith

The other day I got a call saying that a users database was corrupt and I needed to look at it. They said that DBCC CheckDB was failing. So of course I made sure we had backups and then logged in to take a look. Below is the error that was found.

December 29, 2010  10:00 PM

SSRS Data Source issue

Posted by: Colin Smith
Question, SSRS

Today I ran into an issue with DataSources in SSRS in SQL Server 2008 R2. This system was upgraded from SQL Server 2000 and we had some minor hicups getting it all upgraded and running but we were able to do it without too many issues. We handed the server over to the dev team and they started...

December 29, 2010  8:27 PM

Thanks to ITKE

Posted by: Colin Smith
SQL Saturday, Swag, Thanks

I wanted to take some time to say thank you to ITKnowledgeExchange for sending me some swag to hand out during my SQL Saturday# 47 session on Powershell for the DBA. I am really looking forward to the session...

December 29, 2010  10:00 AM

DB Mirror Alerts

Posted by: Colin Smith

While I was back east at the home office I was asked to look into a way to monitor DB Mirroring. I had a couple thoughts on this as I know that I can look at the status of the mirror via SMO using Powershell and then alert if the status is not Synched. But I was in a time crunch so I did some quick...

December 28, 2010  9:00 PM

Another Cool Free App

Posted by: Colin Smith
Apps, Cloud, Notes

While I was traveling for work I was told about another great app for note taking. This came in very handy since I was working with Microsoft on a database issue that we were having. I was able to take notes on my laptop as we worked the issue and found things and then I put the app on my phone as...

December 28, 2010  7:00 PM

Cool Andriod Travel App

Posted by: Colin Smith
APP, Travel

Two weeks ago I was traveling for work and I ran into some delays due to weather in Atlanta and that was not all that much fun. But I did find a great travel app that helps keep me up to date on what is happening with all of my travel plans. It is called

Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 28, 2010  3:00 PM

PASS Summit DVD’s are here!!!

Posted by: Colin Smith
DVD's, PASS, Seesions, Summit, Training

Today I came back into my office after being out for a couple of weeks. One week I was traveling for work and then I was on Vacation for a week and that was nice. Well when I got back to my desk I had a package sitting on my desk and I thought "hmmm what could that be?" I opened it up and it was my...

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: