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…
Tag: 70432
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 too much access. Today, I want to cover how you can use the EXECUTE AS OWNER to grant access to a table without granting direct access to…
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,…
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…
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…
70-432:Managing Full Text indexes
While preparing for the 70-432 I’m digging in to Full Text indexing a bit more than I have before. Today, I want to cover a fairly simple topic, when do you know you need to update your Full Text index? Let’s cover a couple scenarios I’ve seen in the past that were solved by performing…
70-432:Move Your Data Files
Another task you’ll need to be familiar with is moving your databases’ data files and log files. I usually have to do this right after I have a new server built, and the system’s administrator installs SQL for me. They mean well, they really do, but they aren’t expected to know the performance hit you…
Preparing For The 70-432
I’ve passed both of the Database Developer exams. Now, I’m going to start on the Administration exams. I’ve already purchased The self-paced guide. I’ve also scanned through the materials. What I want to do is make this guide a bit more conversational. I honestly believe that’s one of the missing bits when it comes to…
70-432: Unique Constraints
Let’s cover another scenario that uses knowledge you’ll need in order to pass the 70-432. This time we’re going to work with constraints. We all know that you can declare a unique constraint on a column you where you want to be sure you won’t get any duplicates. But do you know how to deal…