The Multifunctioning DBA:

January, 2012

January 30, 2012  7:13 PM

24 HOP sesssion

Colin Smith Colin Smith Profile: Colin Smith

I have submitted my session for the 24 Hours of Pass. I hope to get selected for this as I was denied for the PASS Summit based on a lack of speaking experience. I am hoping to get some more speaking experience so if I decide to submit again for the Summit that the lack of experience will not be my...

January 27, 2012  4:49 PM

24 Hours of Pass Call for Speakers

Colin Smith Colin Smith Profile: Colin Smith

Only a few days left so go do it. What are you waiting for? Are you looking to share your knowledge, have fun, and probably make some new friends in the SQL Server community? Then do what I am about to do and go sign up to present at the 24 hours of pass. Click the link to go submit your abstract...

January 24, 2012  5:10 PM

Cool Way to Pay

Colin Smith Colin Smith Profile: Colin Smith

I found this service that some of you may or may not know about so I thought I would share it with you. I will not lie, this is a bit selfish as well. The service is called Serve and is at This service allows you to pay for things and or pay friends...

January 20, 2012  9:05 PM

Hard Drive Crash

Colin Smith Colin Smith Profile: Colin Smith

A few years ago I decided to purchase a WHS for my home. I had been looking for a storage device like a NAS that would provide redundancy for my critical data but I also did not want to break the bank and I wanted something easy to use. So I looked and looked and I finally decided on a WHS. I chose...

January 15, 2012  8:00 AM

Connect-sql Function

Colin Smith Colin Smith Profile: Colin Smith

This is a function that I keep in my profile so I can call it in any of my scripts that will run from my profile. It makes it easier for me so it might for you. function connect-sql ($arg) { if($arg -eq $null) { $server = Read-Host "enter instance name to connect to" } else { $server =...

January 14, 2012  8:00 AM

PS script to check SQL Server Groups

Colin Smith Colin Smith Profile: Colin Smith

This is the script that I threw together to check and see if a user is in multiple AD Groups that are logins to the SQL Server instance. This helped me resolve an issue and it may help you look for things like explicit deny or some other reason why a user does not have the access they need or...

January 13, 2012  5:35 PM

Strange Issue with MSSQL error 18456

Colin Smith Colin Smith Profile: Colin Smith

I know that this is everyone's favorite error message that SQL Server spits out. I love it because it has so many states that can give you an idea about what the root cause of the issue is. The downside is that some of the states really do not give you any good information and are just generic. So...

January 13, 2012  8:00 AM

SQL Server on VM Training

Colin Smith Colin Smith Profile: Colin Smith

Not too long ago I was lucky enough to get my work to pay for a training session about SQL Server running on VM. The reason I was able to get this is that my shop was having some latency issues in our SQL Server VM's.  It took us a long time but we finally tracked down the issue right before the...

January 12, 2012  2:28 PM

CES Story I heard

Colin Smith Colin Smith Profile: Colin Smith

Today as I was driving to work I was listening to Tech News Today and they were talking about Motorola saying that the carriers do not want them to deliver phones with stock Android. They want to be able to differentiate the phone based on the software and that is...

January 10, 2012  8:00 AM

DBA is a full time job

Colin Smith Colin Smith Profile: Colin Smith

Today I received a call from a co-worker at my previous job. It was great to hear from him and catch up, but the main purpose of his call was not just to see how I was doing with the new kid. Of course not right, why would I even think that. Now do not get me wrong, I do not mind getting calls from...

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: