I passed the 70-432! After two months of preparations I did it! I’d like to let you know a little about my experience with SQL, so you can judge how much of this prep you might need to do. I began in 99 as a web programmer using the LAMP stack. Within a few years…
Tips for SQL N00bs
Everyone in PASS and everyone following the #sqlhelp hashtag on twitter was a SQL n00b at one point. That includes me. So when I started compiling my SQL101 material into a book, it dawned on me. I should include those things I wish I’d known sooner about SQL. So I asked anyone who would…
Another Guest Blog
I’ve got another post up at WMW.com.br! This time I’m taking on CXPACKET waits and parallel queries. I also go into why setting MAXDOP to 1 isn’t the solution. You have to dig deeper and find the root cause of those CXPACKETs. We’ll resume here Friday with another career development piece. Until then, if…
SQL 201-Non-Correlated Sub Queries
It’s been a while since I’ve covered any material for my SQL 201 series, so I thought I’d jump back into it with non-correlated sub queries. It’s a mouthful. But it’s a really simple concept, you can join two queries that have absolutely nothing to do with each other into one statement. I’d like you…
Resume Goodness and Failures
Over the past few weeks I’ve helped out with the hiring process at my current employer. We’ve decided to bring a new person on to help with some programming duties. During this process I’ve gotten to look at more than a few resumes. I’ve seen plenty in the past, and even had the chance to…
70-432: A Closer Look at Agent Jobs
I was taking a practice test for the 70-432 when I got a question that covered a scenario I’d never even thought about before. It had to do with options you have available on Agent Jobs. After digging into the Agent Jobs properties dialog, I realized there were some extra features I’ve never used. While…
Happy Memorial Day
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…
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…