The Multifunctioning DBA:

October, 2011

October 30, 2011  10:00 AM

PowerShell SQL Server Health Check Script – Revisited

Posted by: Colin Smith
Powershell, SQL Server

In the past couple months I have received a few comments and questions about my SQL Server Health Check Script. So I thought it might be a good time to revisit the script and clear some things up...

October 27, 2011  1:18 PM

SQL Monitoring with Ignite

Posted by: Colin Smith
Montoring, Tools

Over the past few weeks, we have been using the Ignite Monitoring Tool to monitor some of our SQL Server instances and we have been pleased with our findings. This tool...

October 19, 2011  1:16 PM

Powershell Disable db File Autogrow

Posted by: Colin Smith
autogrow, file managemnt, Powershell, SMO, SQL Server

In order to Disable autogrow on your database files it is a bit tricky. One would think that in SMO you would have an autogrow flag that could be turned on and off like there is in the GUI. Well this is not the case. So if you take my script fromĀ 

October 18, 2011  1:33 PM


Posted by: Colin Smith
Project tracking, time tracking

Do you need to do time tracking? I do, my new job requires that I track how many hours I am spending on project work by project vs break fix issues. This is all new to me and I have been struggling to find a way to do this that is not too much overhead. So I started looking around...

October 14, 2011  8:25 AM

Powershell Script to change data and log files that are growing by percent

Posted by: Colin Smith
Powershell, SMO, SQL Server

This is the next step after finding all the files that are growing by percent and not by a fixed value. Below is the modified script to make the changes that I needed.
#### Check Log and Data Growth for all User Databases. If they are not set up correctly then change...

October 13, 2011  2:24 AM

Denali Gets a Name

Posted by: Colin Smith
Denali, PASS, SQL Server

During the Keynote at the Pass Session today. Ted Kummert of MS made the announcement that SQL Server Codename Delai is actually going to be called SQL Server 2012. Not very exciting but he went on to say that we would have a full RTM release in the first half of the ...

October 12, 2011  2:34 PM

Happy Anniversary

Posted by: Colin Smith
Anniversary, Wife

Today is my 14th wedding anniversary. I thought I would throw up a little note to my wife and say, I Love you very much and I would not trade the last 14 years for anything in the world. And now that we have a baby coming to us I am very excited to start this next chapter in our lives together....

October 12, 2011  1:56 PM

Powershell Script to check if data and log files are growing by percent

Posted by: Colin Smith
Data Files, Growth, Log Files, Powershell

In my new shop we try to grow our data and log files by a specific amount and not by a percentage. Our team lead ran into a database that had not been set up properly and wanted someone to check all our databases to verify that they have been set up correctly. Since I am the new guy and...

October 10, 2011  5:35 AM

PASS 2011

Posted by: Colin Smith
PASS, PASS Summit, Summit

Tomorrow is the beginning of PASS. I wish I was able to attend this year again but I think that my time and money was better spent at the SQL Skills immersion event that I attended. I know that I will be missing out on some great content, networking, and parties. As much as I would like to be at...

October 6, 2011  1:10 PM

The Passing of Steve Jobs

Posted by: Colin Smith
Steve Jobs

Yesterday Steve Jobs left this world at only 56. It is a sad time in the tech community, and the world at large.. I was never a big Apple fan, the only Apple device in my house is an Ipod Touch and that is only because my wife wanted it. Even not being a fan of Apple I recognize all that Steve Jobs...

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: