70-432
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
sql
sql
Recursive Common Table Expressions
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
sql
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
sql
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
sql
70-433: So, When Do You Want To Use Triggers?
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
sql
70-432: Know Your Constraints
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
training
Missed Deadlines
Looks like I missed my personal deadline to take my 70-433 last month. I let myself get wrapped up in the final phases of development on a conversion I've
sql
Developing and Deploying with SQL Azure White Paper
Over at Microsoft they have a white paper that mostly summarizes the articles I've been posting on how to develop in SQL Azure. But in a few places they add
azure
The Import and Export Data Wizard and SQL Azure
In my previous post I walked through migrating a database from SQL 2008 to SQL Azure. I briefly walked you setting up your account with SQL Azure, creating a
microsoft sql
SQLCMD and SQL Azure
I've seen several questions on forums over whether or not you can use SQLCMD with your SQL Azure instance. Well, I'm here to say yes you can! You can even
microsoft sql
Microsoft TechEd 2010 SQL Azure updates!
Microsoft TechEd is your chance to learn about cutting-edge insights and gain expertise that will make life easier for you and everyone you work with. You
career development
Introduction to Master Data Services
You find yourself sitting in front of your machine late one evening. Everyone has gone home for the night except for you. You've left a scan running to