The Multifunctioning DBA:

January, 2011

January 31, 2011  11:00 PM

Microsoft Support

Posted by: Colin Smith
Consulting, Support

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


Posted by: Colin Smith
Replication, SQL Server

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

Posted by: Colin Smith
Audit, DBA, MS SQL Admin

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

Posted by: Colin Smith
DBA, Hours

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

Posted by: Colin Smith
Formatting, Powershell, Scripting, Training, Webcast

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

Posted by: Colin Smith
Contest, SQLSkills, Training

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

Posted by: Colin Smith
Database Administration, DBA, MSSQL Server

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

Posted by: Colin Smith
DBA, DR, enable sa, sqlhelp

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

Posted by: Colin Smith
sql saturday 47

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??

Posted by: Colin Smith
DR, Planning, Recovery

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: