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 18, 2010 6:34 PM
Posted by: Colin Smith
Education,
MS SQL,
MS SQL Admin,
MSSQL Server,
PASS,
PASS SummitI am trying to get my company to pay for me to attend the PASS Summit 2010 in Seattle Washington. I am still pretty new in the world of Databases but I think that attending the Summit would be very good for...
January 6, 2010 10:33 PM
Posted by: Colin Smith
Clean Up,
MS SQL,
MS SQL Admin,
Powershell,
SQL ServerA few months ago I was transferred to my companies parent company. I think that this is good news for me so I am happy about it now. I have been asking, for about a month, to do a network scan in order to identify servers that have SQL installed. Due to the holidays and scheduling I did not get...
October 26, 2009 4:26 PM
Posted by: Colin Smith
MS SQL Admin,
MS SQL Server,
MS SQL Troubleshooting,
MSSQL Administration,
SQL Server 2005Just got a call that three databases on an instance where many reside were not accessible. Users were getting errors about not enough disk, memory, or the files were inaccessible. I logged into the server and found that the databases were not offline but could not be accessed. I looked into the...
September 8, 2009 5:33 PM
Posted by: Colin Smith
Certification,
MS SQL,
MS SQL Admin,
MS SQL ServerI have scheduled my first certification test for late October. I think that by putting the date on the calendar it will push me to finish my study more quickly. I have not been as vigilent as I would have liked to be so I am lighting the fire so to speak. Also with my new position I think that I...
