Tag: SQL

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…

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…

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

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…

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…

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…

Ok, let’s cover another topic you’ll need to know in order to pass the 70-433.  You’re going to need to be familiar with what triggers can do.  When you get ready for the 70-451, you’ll need to know more about when triggers should be used.  I wanted to use the scene from Raiders of the…

When you’re getting ready for the 70-433, you’re going to want to be familiar with constraints. They’re useful tools for setting up data integrity checks inside the database itself.  Yeah, I’m going to reference The Matrix here, but learning to manipulate Constraints is a little like learning to bend spoons. There Is No Spoon The…