The Multifunctioning DBA:

July, 2010

July 30, 2010  10:00 PM

SQL Server Test Instances

Colin Smith Colin Smith Profile: Colin Smith

Lately I have had a number of test databases where the log file has just gotten way out of control and I have been close to running out of disk space. This is a problem and it is caused by someone, including me, restoring a database from production to the test instance. If the database in...

July 30, 2010  10:00 AM

Backup and Restore

Colin Smith Colin Smith Profile: Colin Smith

I am fighting a battle right now of whether or not I, the DBA, or the backup team at my company should be in charge of backups and restores of the SQL Server Databases in the company. We use Netbackup with a SQL Agent to back up the databases and I am still not sure that I am a huge fan of that. I...

July 29, 2010  5:00 PM

SQL Query Troubleshooting

Colin Smith Colin Smith Profile: Colin Smith

So I am by no means good at wtiting T-SQL or optimizing the code. But, Yesterday one of our devs called me and said that he had a SSIS job that was running i about 45 minutes start taking 10 hours. Ouch that can not be good I said. I asked him what tables were involved and I opened up my...

July 29, 2010  10:00 AM

SSHD in my laptop

Colin Smith Colin Smith Profile: Colin Smith

About three years ago work got me a new laptop and wanted me to be the first to try out the Solid State Hard Drive. I eagerly agreed and got the laptop. It was fast, I could tell a difference in boot time and some applications. I loved it except that the drive was only 30 Gigs. Not a big deal I...

July 28, 2010  4:00 PM

PCI Compliance

Colin Smith Colin Smith Profile: Colin Smith

Right now we have a big push for PCI Compliance. They require us to encrypt all network traffic that is coming to or from any server with protected information. This is fine and makes sense, I mean we do not want sensative information flowing across the wire in plain text. I have to hand it to the...

July 28, 2010  10:00 AM

SQL Saturday 47 Phoenix

Colin Smith Colin Smith Profile: Colin Smith

SQL Saturday in Phoenix was originally scheduled for July 17th but it was put on hold. I am not sure of a new date at this time but I hear that the organizers are looking at sometime in February. This will be a better time of year for Phoenix to get attendees and speakers to come out. It is just so...

July 27, 2010  8:36 PM

IT Audit

Colin Smith Colin Smith Profile: Colin Smith

Recently my company went through an internal audit of our financial systems. First let me say that I am proud because we did well and do not have many issues to resolve, and no issues on the Database Side. Any way I also want to point out that the auditors are not IT people. They are accountants...

July 27, 2010  4:36 PM

Mental Health

Colin Smith Colin Smith Profile: Colin Smith

As and IT person, sometimes you can get overwhelmed with the things that are going on. You have to be able to get thru it and function. You can not let a mental block stop your progress. I have found that to keep my head on straight, when I come up on a time when I feel frustrated, overwhelmed, or...

July 24, 2010  8:09 PM


Colin Smith Colin Smith Profile: Colin Smith

I would say that a good percentage of IT Professionals have to be on-call every now and then. Where I work it is usually not that bad. I am on a rotation that puts me on call one week every third week. That seems like a lot but we really do not get that many calls or pages. Sometimes though it can...

July 24, 2010  10:00 AM

Funny things you hear in IT

Colin Smith Colin Smith Profile: Colin Smith

Today I was talking to a couple guys that I work with and we started talking about some of the funny things that users say. The one today was pretty good, the help desk ticket came in stating that the users "Internet Controller Interface Card" was not working. The users logic was that they could...

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: