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

Recent Posts

  • Docker-based Spark
  • Network Infrastructure Updates
  • Docker and Watchtower
  • Delta Sharing – Data Providers
  • SQL Server to Databricks Profiler

Recent Comments

  1. slowder on Data Engineering for Databricks
  2. Alex Ott on Data Engineering for Databricks

Archives

  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • October 2018
  • August 2018
  • May 2018
  • February 2018
  • January 2018
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • June 2017
  • March 2017
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • August 2013
  • July 2013
  • June 2013
  • February 2013
  • January 2013
  • August 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • May 2007
  • April 2007
  • March 2007
  • February 2007
  • January 2007
  • December 2006
  • November 2006
  • October 2006
  • September 2006
  • August 2006
  • July 2006
  • June 2006
  • May 2006
  • April 2006
  • March 2006
  • February 2006
  • January 2006
  • December 2005
  • November 2005
  • October 2005
  • September 2005
  • August 2005
  • July 2005
  • June 2005
  • May 2005
  • April 2005
  • March 2005
  • February 2005
  • January 2005
  • November 2004
  • September 2004
  • August 2004
  • July 2004
  • April 2004
  • March 2004
  • June 2002

Categories

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