The Multifunctioning DBA

August 25, 2011  12:40 AM

Goodbye Steve

Colin Smith Colin Smith Profile: Colin Smith

Wow Steve Jobs finally steps down.  Check it out here. I must say that I have never been a big Apple fan, not just the computers but any of the products apple puts out. Sure the Ipod and the Iphone are nice and they started revolutions and I am thankful that they did, but still not a big fan.

I must say though, that Apple has been an innovator for many years and they really have done some amazing things. I do not know what goes on behind closed doors at Apple or how involved Steve Jobs really was but I think he has been pretty important in leading Apple down the path that has made them very successful.  So even I, not an Apple Fan Boy, by any means must bow down to Steve Jobs and say thank you for all your contributions to technology and thank you for being such a visionary. I think you will be sorely missed by all.

So a big toast to Steve and I wish him all the best in the future.

August 24, 2011  3:35 PM

HP Touchpad

Colin Smith Colin Smith Profile: Colin Smith

If you are like me you missed out on the crazy sale of the HP touchpads. but I just got on a mailing list to find out when more will be available. Here is a link.

Good luck

August 20, 2011  10:00 AM

SQL Server SP install Fail Issue

Colin Smith Colin Smith Profile: Colin Smith

Last week I came across a SQL Server that was running 2005 SP2 and I thought “hmm I should upgrade this to SP4′” So I got a time to do it and I went along my merry way. Well I started the install and everything installed just fine except the database engine failed. The error in the log file said something about the path for Temp_MS_AgentSigningCertificate_database was not available. I thought this is strange since this is not a database on the server and I do not see it anywhere. I beat my head against the wall for a few minutes and then it came to me. AWW I bet that is something that the SP is putting on the Server for the install process. So I opened up SSMS and looked at my Default database location setting and found that someone had changed them to a disk that does not exist on the server. I changed that to a Valid path and re-ran the SP installer and what do you know… it all worked. So keep an eye out for that and I hope that you find this before you beat your head against a wall.

August 19, 2011  4:53 PM

EVO 3D Bug Fixed

Colin Smith Colin Smith Profile: Colin Smith

Earlier this month I did a post evo3d-bug-that-is-the-most-annoying and I wanted to do a follow up on that and let you know that the BUG has been fixed. Yesterday I got an upgrade to 2.3.4 and now when I reboot my phone all my icons are still available. WOOHOO.

They also fixed another little bug that I had not mentioned and that is that the tempurature could only handle 2 digits on the weather widget and in the weather lock screen. So many times I would look and see that it was 05 Degrees outside. Well I am in AZ and I know that it was really 105 Degrees. But that is now fixed as well. So now I just love the phone.

August 18, 2011  8:47 PM


Colin Smith Colin Smith Profile: Colin Smith

I am way behind on doing this post as well as the series that I would like to do about the IE1 Class that I attended in August. First and foremost I have to say that this is the BEST TRAINING I have ever had. I have been to other training classes for other RDBMS’s but this is BY FAR the BEST I have ever been too.  So that is the Short of it but lets get into some more detail.

Paul Randal (Blog | Twitter) and Kimberly L Tripp (Blog | Twitter) really make it easy to get the most out of the training. The training is in the Hotel so you do not need to worry about getting anywhere, no traffic  worries or having to walk around town to get to class. This really made it nice for me, I was able to sleep in, for me, and still be down in plenty of time for class.

When I arrived down in the conference room for Class breakfast was waiting and or being set up, depending on how early I arrived. This was very nice since I could also eat before the class started so I was not distracted with food during the training. I also had plenty of time to organize my things and get ready for the day of training in plenty of time for class to start. Also during this time Paul and Kimberly are setting up for the day but they are also busy fielding questions and messing around with the class and each other.

Once the time for class to begin it was time and no time was wasted. This was great because I sure did not feel like my money was being wasted with how prompt they were everyday. They provided a Book of all the slides that they covered as well as more slides that they did not go over in class. The amount of information that they provided was just amazing, and none of it is filler…

Another really great thing about the class was the whiteboard. I think this was the first class that had this whiteboard and I was happy that I was in this class. Instead of a traditional whiteboard they used a tablet. This was great because I did not have to try to draw all the diagrams and notes that they were putting on the whiteboard. I was able to just listen, pay attention, and take my own notes as they did the whiteboard. I did not miss out on the instruction because I was copying what they were doing. After the class not only did they send us all the whiteboards that they did but they also went back and put some good notes on the whiteboards for us so that we could make sense of them. this was amazing and I think it adds a lot of Value to the class.

As the class progressed we obviously had a lot of questions and some of them were about the current material and some were off on tangents. This may have been the best part of the class. Not only do they build in time to answer questions, but they do not care what the tangent is. If it is pertinent they will go as far down the “Rabbit Hole” as is needed to answer the question as well as all the other questions that tangent brings up. On a few occasions they did not know the answer, shocking I know, but even then they did not give up on it. They reached out to other resources and found the answer. Just Amazing!!

The only bad thing I can say about my experience is that the chairs get pretty uncomfortable after a few days but really even that is not bad because I was so engrossed by the material that I did not think about it. Paul and Kimberly also do a great job of providing breaks throughout the day. No matter how into this stuff you are it is hard to pay attention for that many hours in a day without a few breaks.

I almost forgot to mention the food. I already mentioned that breakfast was ready when I arrived in the class but I did not talk about how good it was and that Lunch was also very good everyday. Not too mention how convenient it is to have that provided so I do not need to worry about it and be distracted from class or be late after lunch because I went somewhere that took longer then they needed too.

I could go on and on about this week of training and how great it was but that would take forever… Like I said at the beginning this is the BEST TRAINING I have EVER had and I got a lot out of it. I have only been back a few weeks and I am using what I learned already. One big thing that I just setup for one of our developers was table partitioning. They had attempted to get it set up but did things very wrong. Thanks to what I learned at SQLSKILLS I was able to get it set up properly and things are working great.

I really hope to be able to go to week 2 at one of the upcoming events and I would like to thank Paul Randall and Kimberly L Tripp for the amazing week.

August 1, 2011  10:00 AM

EVO3D Bug that is the most annoying

Colin Smith Colin Smith Profile: Colin Smith

I like to move all my apps to the sdcard on my phone and leave as much internal memory free as possible. But the problem with the EVO3D is that it has a bug where when you reboot the phone, all icons associated with apps that are on the SDCard go to the little green and white android icon and lose the real icon. This is a pain, all the apps still work just harder to find them on your home screens. I found a workaround though and I hope that HTC will resolve this issue quickly.

To Resolve the issue go to Settings — Applications — running services — and now look for the HTC Sense service. Click that and then stop it. I know this sounds bad but it is not. The service will restart in a minute and when it does all your icons will be back. I know it is a pain but at least you can get them back. HTC needs to fix this bug though.

Hope that helps

July 29, 2011  3:43 PM

New meeting Place (FREE)

Colin Smith Colin Smith Profile: Colin Smith

I just found out and signed up for a new online meeting place. I have not tried it out but I am anxious to do so but it looks and sounds pretty nice and best of all it is free…

Check it out at

and I will give it a test run when I can and let you know my thoughts.

July 28, 2011  9:00 PM

Auditor Nightmare

Colin Smith Colin Smith Profile: Colin Smith

My company has an audit coming up and I saw this post and thought I should take a look since we are getting ready for our audit. So take a look and let me know what you think about this.

/* Style Definitions */
{mso-style-name:”Table Normal”;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-fareast-font-family:”Times New Roman”;
mso-bidi-font-family:”Times New Roman”;

My thoughts are that one of two things are going on here.

1. The poster just wanted to get a rise out of the community and if that is true he did it!!


2. The person that is the rep is really a hacker that somehow found out all the information about the audit and decided to represent the company and attempt to get some information. So be vigilant and aware and look for the red flags.

July 28, 2011  3:44 PM

Spotify Review

Colin Smith Colin Smith Profile: Colin Smith

not to long ago I did a post about Spotify and gave you a link to go get an invite. well since then I have been playing with the service a bit, just on my PC, as I am not going to pay for the service just yet. My impressions are below.

Pretty good content list – I like more of the current music but I also like to go back and listen to some things that I liked when I was young and Spotify has most of the content that I am looking for. They have  nice search function that helps me find these tracks that I have not heard in so long but the search is not always perfect.

Great Quality – The sound is very good especially for a streaming service. Now I am curious what it would be like on my mobile phone but since I am not a paying premium member I have not been able to try that. But the quality from my PC is great and I do not seem to have much lag at all between tracks or just starting a random track when I push play.

Commercials – I am using the free spotify but I still think that they have a lot of commercials. Not so many that I am going to stop using it but it is annoying. That being said I understand that they have to make money from advertising since I am not a paying customer at this time.

Shared Playlists – I think that it is very cool that I can create and share playlists and listen to others playlists as well. I have found that feature exposes me to music that I may have never found before and this has even lead to me purchasing a track that I heard for the first time on Spotify.

I am sure that I am missing some things but in my mind those are the highlights. Go check it out and follow the above link to get your invite. I checked today and it is still working.


July 27, 2011  3:20 PM

Finally a New Phone

Colin Smith Colin Smith Profile: Colin Smith

I have had the Sprint HTC Hero for just about 2 years now and I loved the phone overall. Like any device it got old and slow and stopped getting updates. Once it got really bad about 6 months ago, I rooted and romed the phone and it came back to life. Sure I had some bugs and things were not perfect but the phone was usable again.

Last night I walked into a Sprint store, not thinking I would buy anything yet, and I found out that I am eligible to be a premiere member and that give me the option of upgrading now and I will also be able to get the 2 year price break on upgrades every year. For me that is nice since I work in IT, like many of you, I need to have a phone that can handle all that I throw at it.

I was torn on what phone to purchase, the Choices were the Nexus S and the Evo 3D. I really like that the Nexus S is the Google Phone and that it is Vanilla Android and I would be getting OS updates very quickly. But this phone had two major downfalls for me.  One is that it does not have a micro SD Card slot, that means I am stuck with only the internal memory and I can not take it out and plug it in to a computer if something should happen to the device. I might lose some important data. Two is that it is a single core proc, now I know that is not really a bad thing right now, but I think that since the multi core devices are hitting the market now that Developers will start to really take advantage of that. Some other minor things are that the screen is a bit smaller and frankly I do not think it looks as nice as the HTC.

The HTC EVO 3D has one MAJOR flaw and this is what I ran into with my Hero. Since it has HTC Sense UI, which I really do like, I will not be getting updates like the Nexus S. Not sure if and or when the EVO3D will get Ice Cream Sandwich and that is a huge flaw for me. But I love that I can put a 32 Gig SD Card in it and it is a dual core proc. Plus the screen is bigger and in my opinion a better looking screen, and the 3D is cool even though that is not a reason to pick one phone over another.

So I chose the EVO3D. I know that I might not get the updates as fast as the Nexus S but I will be shocked if it does not get Ice Cream Sandwich and if I have to I will Root and Rom this one as well. I will be waiting a while on doing that though.

I have only had the phone for about 12 hours and I was sleeping for about 6 of that so I have not really played with it too much yet. So far I really like it but I will post again about the phone and let you know what I really thing soon.

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: