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 sure the rest of your team will be ok while your out. You have to make sure you’ve taken care of any…
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 have a good handle on granting permissions using both users and groups. While you need to know how to grant those permissions using the…
70-432: Database Options
Have you ever cracked open the properties for a database, and looked at all the options available on that page? If you’re preparing for the 70-432, you might want to spend an hour looking over the options, and what they mean to how the database will run. This is a quick overview of those options,…
Career Maintenance
I’m not a gear head by any means. Though I do know more about diesels now that I did two years ago. I love my Jetta TDI! The one thing I’ve always know about cars is you have to maintain them to keep them running well. Or in some cases, running at all. The one…
10 Ways to Use Twitter to Get Recruiters’ Attention
I’m very excited that I can finally share with you all the fact that I’ve begun writing for Salary.com! The plan is to move much of my career development posts over to their site. In the mean time, I’ll continue posting topics here as well as at Salary. If you can check my posts there…
Recursive Common Table Expressions
In case you haven’t had a chance to play with them Common Table Expressions (CTEs) are pretty cool. Basically you can define a temp table and do operations against that table all on one statement. One of the things I’ve found most awesome about CTEs is using them for recursive logic! Here’s a contrived example…
70-432: What Kind of Account?
When you start preparing for the 70-432, one of the first topics you’ll have to get used to is choosing the appropriate type of account you need to use for different types of access to your SQL server. You’ll need to be able to recognize the differences in access you get when you choose a…
SQL Jobs Outlook–Awesome!
I know they’ve just released the Job numbers for April. And yes, it’s a mixed bag of news. While we added a lot of new jobs this month, we’re still showing a high unemployment rate. While I’m not going to debate any of these numbers, I would like you to turn to your personal job…
70-432: Recovery Models
I’m back to studying for the 70-432. That means it’s time to cover another topic you’ll need to be familiar with in order to pass this exam. Today’s topic is Recovery Models. There are three recovery modelsavailable to you in SQL 2008. Simple Full Bulk Logged To pass the 70-432, you’re going to need to…
Meme Monday: 99 Problems
SQLRockstar (Thomas LaRock) has another interesting suggestion to blog about for today’s meme monday. He suggested we share some the things that go wrong with our database servers that aren’t related to the disk. Memory Settings Up until Sunday morning, our servers were running with 8gb of RAM, and had “max server memory” set to…