The Multifunctioning DBA:

MS SQL


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

March 12, 2010  11:30 AM

First SQL Servers User Group Meeting



Posted by: Colin Smith
MS SQL, PASS, SQL Server

Last night I attended my first SQL Servers Users Group here in Phoenix. I a so happy that we have one. It was a good meeting, I arrived and apperantly the speaker that was supposed to present was sick and could not make it. Luckily for us, the meetings are help at the MS offices here, and a MS...


January 21, 2010  10:00 AM

More fun with MS SQL Server



Posted by: Colin Smith
Cluster, MS SQL, MSSQL Administration, Replication

I have a customer who would like to have a couple things. They would like to have, above all, HA. Secondly they would like to be able to configure the application to write to one database and read from another. They want to do this to boost performance as they feel that IO may be an issue. I...


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


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


August 27, 2009  3:30 PM

Moving System Databases in MSSQL2005



Posted by: Colin Smith
MS SQL, MS SQL Server, SQL Server Administration, System Database Moves

Recently I had to move all system databases for one server to another physical drive. This is pretty simple for all but the Master and SystemRecource databases. For all others you can just do the following and then copy the mdf and ldf files to the new location.


August 27, 2009  3:13 PM

Questions about health check script



Posted by: Colin Smith
Answers, MS SQL, MS SQL Server, MSSQL Administration, Powershell, Powershell Tips, SQL Server

I recieved a comment that contained a question about my previous post about writing a script to output a health check of SQL Server. http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/ The following is the question: should we make anychanges for this do...


July 13, 2009  5:31 PM

MSSQL Server Renaming Physical Host



Posted by: Colin Smith
Database Administration, MS SQL, MS SQL Server, MSSQL

Recently I had a server that hosts a MSSQL 2005 SQL Server named instance and the Windows group decided that the name of the server had to be changed. I thought that this may cuase an issue since the MSSQL Server name is 'hostname\instancename'. I did a bit of research and found that a solution is...


May 29, 2009  2:36 PM

SQL Server Certs



Posted by: Colin Smith
Certifications, Education, MS SQL, SQL, SQL Server

I have been talking about what I would like to do to further my education and my carreer as a DBA. I started reading the books in order to study for my MCITP DBA certification and the other members of my team decided that they would like to do the same. They both ordered the books as well and now...


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: