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,…Read More 70-432: Database 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…Read More Recursive Common Table Expressions
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…Read More 70-432: What Kind of Account?