My latest article has been published over at Salary.com! Check it out. Going Paperless: Is it time to buy a tablet? Think about how much paper you use at your job on a daily basis. You print out emails and spreadsheets, take notes during meetings and fill out forms which are then shipped across the…
Month: June 2011
70-432: Post-op
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…