Help me help you. (you’ll have to login to see the clip…it’s consideredmatuuuuure) Help Me Help You Jerry Maguire at MOVIECLIPS.com During my career I’ve had an inconsistent relationship with recruiters. I’ve worked with some really awesome recruiters. They spent the time to get to know me, they learned what I wanted in a job. …
70-433: So, When Do You Want To Use Triggers?
Ok, let’s cover another topic you’ll need to know in order to pass the 70-433. You’re going to need to be familiar with what triggers can do. When you get ready for the 70-451, you’ll need to know more about when triggers should be used. I wanted to use the scene from Raiders of the…
70-432: Know Your Constraints
When you’re getting ready for the 70-433, you’re going to want to be familiar with constraints. They’re useful tools for setting up data integrity checks inside the database itself. Yeah, I’m going to reference The Matrix here, but learning to manipulate Constraints is a little like learning to bend spoons. There Is No Spoon The…
Handling Failure
I know it’s been said, you don’t know how good you are at your job until you handle failure. I’m not going to say I’m perfect at my job, but I did have to handle some pretty bad failure yesterday. It began early in April. We’d been receive some odd error messages with CommVault and…
70-432:Managing Full Text indexes
While preparing for the 70-432 I’m digging in to Full Text indexing a bit more than I have before. Today, I want to cover a fairly simple topic, when do you know you need to update your Full Text index? Let’s cover a couple scenarios I’ve seen in the past that were solved by performing…
70-432:Move Your Data Files
Another task you’ll need to be familiar with is moving your databases’ data files and log files. I usually have to do this right after I have a new server built, and the system’s administrator installs SQL for me. They mean well, they really do, but they aren’t expected to know the performance hit you…
New Blog Entry @ OurBodyTransformations.com
I just wanted to drop a line letting you know my blog entry for today I over at http://ourbodytransformations.com. The inspirational Jen McCown convinced me to join a new weekly blog party #getHawt. Check out her call to action blog post here. And then check out mine here. Maybe this will become your call to…
Scotland 2011-Day Four
Day five in Scotland started very early. It also started with a traditional Scottish breakfast. For those who haven’t experienced this, here’s what was on the menu: haggis, black pudding, baked beans, cooked tomatoes, sautéed mushrooms, cooked bacon (closer to what I know as country ham), eggs, fruit, cheeses, cereal, etc. Yeah, that’s right, haggis…
Preparing For The 70-432
I’ve passed both of the Database Developer exams. Now, I’m going to start on the Administration exams. I’ve already purchased The self-paced guide. I’ve also scanned through the materials. What I want to do is make this guide a bit more conversational. I honestly believe that’s one of the missing bits when it comes to…
I’m a MCITP, now what?
It’s been a few days shy of two months since I got my MCTS: SQL Server 2008, Database Development, I passed the 70-51. As a result, I’m now a MCITP: Database developer. I’ve been pushing pretty hard to get this one out of the way so I can begin my training for the administrator track. …