sql
70-450: Complete!
After another month of studying, I finally took the 70-450. I'm happy to say I passed! I did learn one thing from the exam: I should spend more time with
sql
sql
SQL 201-Table Variables
It's been a while since I've added to my SQL 201 series, so I thought I'd pick up with table variables. In an earlier post, I covered temp tables. Temp tables
sqlpass
Don’t Miss My Session at SQLSaturday #80
That's right! I'll be speaking at this weekend's SQL Saturday event in Wheeling, WV. I'm the last speaker in track #3. I'm looking forward to Ed Wilson's
sql
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
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
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
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
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