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…
Month: May 2011
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…