The Multifunctioning DBA:

January, 2011

January 31, 2011  11:00 PM

Microsoft Support

Colin Smith Colin Smith Profile: Colin Smith

I have been on the phone with MS way more than I would like to be in the past month or so. Three times and two of them were for critical issues. Both times it was not the best experience. They do not like to escalate the case to a senior engineer even when I ask nice. That is very frustrating. I...

January 31, 2011  7:37 PM


Colin Smith Colin Smith Profile: Colin Smith

Wow, who knew how big replication was. So many types, different requirements, I am learning a lot but for the problem I am facing I think I am most interested in peer to peer replication. Here is a good link about it.

January 30, 2011  9:21 PM

Triggers for protection

Colin Smith Colin Smith Profile: Colin Smith

I have recently had to find a way to prevent someone that has elevated privileges from removing logins, databases, as well as keep them from adding new databases to my production systems. I was amazed at how easy this was to do thanks to event level ddl triggers. I created a table in master called...

January 30, 2011  6:45 AM

DBA Hours

Colin Smith Colin Smith Profile: Colin Smith

When I was in school I thought that being a sysadmin would be about the best job in the world. I was close, I did not know how much fun it would be doing the job of a DBA. So after I became a DBA I loved it and really do enjoy my work and the fact that no matter how much I learn about it I still...

January 29, 2011  8:00 AM

Powershell Formatting

Colin Smith Colin Smith Profile: Colin Smith

I did not get to see this during the live presentation but I am looking forward to seeing it especially after hearing some co-workers talk about it. If you have the time check it out. I am sure it is going to be great.

January 28, 2011  9:00 PM

Free SQLSkills Training Results

Colin Smith Colin Smith Profile: Colin Smith

Well I did not win any free training but I would still like to thanks SQLSkills for all that they do and for offering a great contest with a fantastic prize. I hope that they do this again as I think it is a great opportunity for any DBA. I would like to...

January 28, 2011  5:48 PM

Recent SQL Disaster

Colin Smith Colin Smith Profile: Colin Smith

In my last post about the disabled sa account I mentioned that I would have more on why I could not use windows authentication to get to my SQL Server instance. Here is the short of it and I know many of you will be screaming at the screen as you read this. Again this is a server that I have walked...

January 28, 2011  2:11 AM

Disabled SA account

Colin Smith Colin Smith Profile: Colin Smith

I recently had a situation where something happened to my SQL Server and I could no longer log in using windows authentication. I will get more into what happened in another post. Let me just preface all this by saying that I inherited this mess. Anyway, thanks to

January 28, 2011  1:18 AM

SQL Saturday 47 Phoenix

Colin Smith Colin Smith Profile: Colin Smith

The schedule is out and the tracks are set. It really looks like it is going to be a great day of learning and hopefully a good day for presenting. This is my first time presenting so I am pretty nervous but I am very excited about it. I am excited to be a contributing member of the community and I...

January 26, 2011  8:00 AM

What is DR??

Colin Smith Colin Smith Profile: Colin Smith

What is DR? How do you define it? I would really like to know. Please put your thoughts in the comments but a recent event has made me re-think what DR truly is. I have a SQL Server that is very mission critical and if the database is not up and accessible the company is losing money. This is...

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: