The Multifunctioning DBA:

MS SQL Admin

1

August 16, 2012  3:45 PM

Database Virtulization



Posted by: Colin Smith
Database Administration, Database Virtualization, MS SQL, MS SQL Admin, MS SQL Server

Some of you may see the name of this post and think that I am going to talk about running SQL Server on VMWare or HyperV. Well that is sort of correct but not really. I am involved in the very early beta testing of a new product that will let you provision VDB's. I am not going to mention names...

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 18, 2010  6:34 PM

PASS Summit



Posted by: Colin Smith
Education, MS SQL, MS SQL Admin, MSSQL Server, PASS, PASS Summit

I 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

Lots of Work to be done



Posted by: Colin Smith
Clean Up, MS SQL, MS SQL Admin, Powershell, SQL Server

A 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

Databases not accessible



Posted by: Colin Smith
MS SQL Admin, MS SQL Server, MS SQL Troubleshooting, MSSQL Administration, SQL Server 2005

Just 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

MS Certification Test



Posted by: Colin Smith
Certification, MS SQL, MS SQL Admin, MS SQL Server

I 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...


1

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: