I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any…
Tag: Certification
SET IDENTITY_INSERT
Let’s say you have the following table on two servers, one in development and one in production. CREATE TABLE person ( personID INT IDENTITY(1,1) , firstName VARCHAR(50) , lastName VARCHAR(50) ) You’re about to implement a new query, but you need to test it out in development before you move it to production. The problem…
70-433:OUTPUT and IDENTITY
Let’s look at a scenario you’ll need to be able to handle if you hope to pass the 70-433. This scenario requires you to understand the IDENTITY property for a column as well as how to return the identities created for rows inserted. Let’s start by creating a table to store widgets. We want an…
70-432: Unique Constraints
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…
70-432: Revoking Permissions
Today we’re going to cover a scenario you might face at work, one that’s also a topic you’d need to know in order to pass the 70-432 Database Administrator’s exam. If you have any questions in your preparation for the 70-432, let me know. I’ll be happy to help in any way! Now for the…
70-432: So…What’s Going to Break When We Upgrade?
So you’re in a shiny new position and you’re building plans for your migration from SQL 2005 to 2008 when the question hits you. What features are we currently using in our code that will break when we move to the new server? Ohh, tough one right? Not really. Hopefully you’ve used the profiler before. …
70-432:Multiple Solutions, Multiple Instances
At work our database server is humming along. It runs a little under 50% on the CPU, the RAM is a bit high, and the IO is very responsive. But, it could be better. About a quarter of the load on that server comes from one application. It’s a reporting solution built to handle end…