Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

Tag: 70432

70-432:Another Backup Scenario

Posted on May 25, 2011September 27, 2011 by slowder

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…

Continue reading

70-432: Execute as Owner

Posted on May 23, 2011September 27, 2011 by slowder

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…

Continue reading

70-432: Permissions and Users and Roles, Oh my!

Posted on May 18, 2011September 27, 2011 by slowder

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…

Continue reading

70-432: Database Options

Posted on May 16, 2011September 27, 2011 by slowder

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,…

Continue reading

70-432: What Kind of Account?

Posted on May 9, 2011September 27, 2011 by slowder

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…

Continue reading

70-432: Recovery Models

Posted on May 4, 2011September 27, 2011 by slowder

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…

Continue reading

70-432:Managing Full Text indexes

Posted on April 20, 2011September 27, 2011 by slowder

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…

Continue reading

70-432:Move Your Data Files

Posted on April 18, 2011September 27, 2011 by slowder

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…

Continue reading

Preparing For The 70-432

Posted on April 13, 2011June 20, 2011 by slowder

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…

Continue reading

70-432: Unique Constraints

Posted on February 20, 2009September 27, 2011 by slowder

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…

Continue reading
  • 1
  • 2
  • Next
  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme