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 encryption techniques and what all you can accomplish through encryption. Unfortunately, I’ve never had the business excuse to practice with encryption. I am interested in…
Tag: 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 are a great place to dump in raw data, then transform it into another form so you can use it in a different way. …
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 PowerShell session at 9:10AM, I need to use more PowerShell in my daily job. I have a couple of scripts that really work for me now, it’s time…
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…
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…