The Multifunctioning DBA:

January, 2010

January 28, 2010  10:30 AM


Posted by: Colin Smith

It has been confirmed. I will be at the upcoming PASS SUMMIT in November. I am very excited to get there and learn some new things and meet some new people. I also have my first SQL Server Users group coming up early next month. All very exciting to me. Now I really need to get moving on my...

January 27, 2010  5:46 PM

DBA Roles

Posted by: Colin Smith
Developer DBA, MSSQL, Roles, Seperation of Roles, Systems DBA

I have a scenario that I would like to talk to you all about and get your take on what should be done. I am a Systems DBA. I am not a Developer. Lets say that in the not so distant past my team of System DBA's got a phone call from a developer in a panic. They needed a restore and needed it now....

January 22, 2010  7:08 PM

Android Dev…. Why Not?

Posted by: Colin Smith
Android, Books, Education

I know that I have so much to learn about Databases and SQL Server, but man I get tired of focusing so much on one thing. I have many things in my life that I enjoy. First is by far hanging out with my wife. But I love technology and I love my Android phone. Since I enjoy my phone so much I thought...

January 22, 2010  1:12 PM

Health Check into SQL Server

Posted by: Colin Smith
Audit, Baselining, MSSQL, MSSQL Administration, Trending

I have recently posted about my new job and how I am walking into the unknown. Like I have said in the past, I did get a list of Host Names that are running SQL Server. I have written a script to go out and look at each of those hosts and get me all instances. I have put together a list of about...

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 20, 2010  5:00 PM


Posted by: Colin Smith
Disk Performance, IO, SAN, SQL Server

Just the other day I was asked to prove to a user that our SAN disk would be faster than the servers Local Internal Disk. Now I am no SAN Admin but I know that in most cases the Fiber attached SAN is going to be faster than the internal local 10,000 RPM drives in my servers. Well thanks to

January 19, 2010  8:00 AM


Posted by: Colin Smith

So, my company has asked all employees to take a week off. Sounds awsome but they do not want to pay us for that week. Ok so they did not ask, they told us to take a week off. Anyway, I thought what better to do then go to the happiest place on earth to forget about the unpaid week off I had. My...

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 8, 2010  7:19 PM

Find SQL Server Instances using Powershell

Posted by: Colin Smith
MS SQL Server, MSSQL Administration, MSSQL Instance, Powershell, Scripting

As I had mentioned before, I recieved a network scan that lists the host names of servers that have some sort of SQL Server running on them. Now I need to get a list of all instances that are on those servers. I thought I could do it in Powershell and I was correct. I know that all instnances of...

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

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: