Certification
70-451: SQL Server Components
Looking through the skills measured by the 70-451, the very first component measured has you "Identify which SQL Server components to use to support business
Certification
Certification
I’ve Passed the 70-433!
I wanted to write up a post about passing my exam, and share everything I learned during this process. I had considered drawing parallels between the
Certification
My First Attempt at the 70-433
A couple weeks back I made my first attempt at the 70-433 SQL 2008 Database Developer exam. I was nervous, it was obvious to me and to those who know me best.
Certification
70-433:Dynamic Management Views
I just laid hands on a great little guide to the Dynamic Management Views in SQL Server 2008. It's a great introduction / quick reference guide sort of book.
microsoft sql
Microsoft Exam 70-433 (part 2)
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
microsoft sql
Microsoft Exam 70-433
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
sql202
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
Certification
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
Certification
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
Certification
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
Certification
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
Certification
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