January 31, 2011 7:37 PM
Posted by: Colin Smith
Replication,
SQL ServerWow, 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
Posted by: Colin Smith
Audit,
DBA,
MS SQL AdminI 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
Posted by: Colin Smith
DBA,
HoursWhen 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
Posted by: Colin Smith
Formatting,
Powershell,
Scripting,
Training,
WebcastI 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
Posted by: Colin Smith
Contest,
SQLSkills,
TrainingWell 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
Posted by: Colin Smith
Database Administration,
DBA,
MSSQL ServerIn 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
Posted by: Colin Smith
DBA,
DR,
enable sa,
sqlhelpI 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
Posted by: Colin Smith
sql saturday 47The 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
Posted by: Colin Smith
DR,
Planning,
RecoveryWhat 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...
