March 12, 2010 11:30 AM
Posted by: Colin Smith
MS SQL,
PASS,
SQL ServerLast 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
Posted by: Colin Smith
Cluster,
MS SQL,
MSSQL Administration,
ReplicationI 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
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...
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...
August 27, 2009 3:30 PM
Posted by: Colin Smith
MS SQL,
MS SQL Server,
SQL Server Administration,
System Database MovesRecently 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
Posted by: Colin Smith
Answers,
MS SQL,
MS SQL Server,
MSSQL Administration,
Powershell,
Powershell Tips,
SQL ServerI 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
Posted by: Colin Smith
Database Administration,
MS SQL,
MS SQL Server,
MSSQLRecently 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
Posted by: Colin Smith
Certifications,
Education,
MS SQL,
SQL,
SQL ServerI 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...
