sql
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
Latest
career development
Working With Recruiters Effectively
I've had discussions with many people who are looking for work. Quite a few of them have expressed some concerns on working with recruiters. A lot of those
sql
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
sql
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.
career
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
microsoft sql
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
personal
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
career development
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
sql
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
sql
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
career development
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
sql
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