Three day weekends are great, aren’t they? Extra time away from the office to unwind and spend with your friends and family grilling up a storm. I know I’m ready to get the charcoal going and grill up something awesome! During this long weekend, take a moment to remember the actual reason we are all…
Month: May 2011
On Confidence
You’ve really got to open this and savor it. That’s seriously an application that was sent in to a colleague this week. After working with most people in IT, It more common to help them build up their confidence. Most of us in IT work quietly in the back rooms of the office. We aren’t…
70-432:Another Backup Scenario
I’ve covered the differences in the recovery options before. So you should be mostly prepared for the following scenario. It requires you being familiar with the three recovery options, and knowing a bit more about the simple mode. Scenario 1 You’ve got a database that’s used during business hours (0800 to 2000). It’s currently…
70-432: Execute as Owner
Another topic you’ll need to understand in order to pass the 70-432 is how you can grant permissions to a user to accomplish a certain goal, without granting too much access. Today, I want to cover how you can use the EXECUTE AS OWNER to grant access to a table without granting direct access to…
Work–Life Balance
This week has been a busy one! I’m working up to a vacation this weekend, so there’s always a lot of little things to tie up to get ready. You’ve got to make sure the rest of your team will be ok while your out. You have to make sure you’ve taken care of any…
70-432: Permissions and Users and Roles, Oh my!
Yeah…I referenced the Wizard of Oz. If I Only Had a Brain The Wizard of Oz — MOVIECLIPS.com But that doesn’t take away from the fact you’re going to need to have a good handle on granting permissions using both users and groups. While you need to know how to grant those permissions using the…
70-432: Database Options
Have you ever cracked open the properties for a database, and looked at all the options available on that page? If you’re preparing for the 70-432, you might want to spend an hour looking over the options, and what they mean to how the database will run. This is a quick overview of those options,…
Career Maintenance
I’m not a gear head by any means. Though I do know more about diesels now that I did two years ago. I love my Jetta TDI! The one thing I’ve always know about cars is you have to maintain them to keep them running well. Or in some cases, running at all. The one…
10 Ways to Use Twitter to Get Recruiters’ Attention
I’m very excited that I can finally share with you all the fact that I’ve begun writing for Salary.com! The plan is to move much of my career development posts over to their site. In the mean time, I’ll continue posting topics here as well as at Salary. If you can check my posts there…
Recursive Common Table Expressions
In case you haven’t had a chance to play with them Common Table Expressions (CTEs) are pretty cool. Basically you can define a temp table and do operations against that table all on one statement. One of the things I’ve found most awesome about CTEs is using them for recursive logic! Here’s a contrived example…