Another task you’ll need to be familiar with is moving your databases’ data files and log files. I usually have to do this right after I have a new server built, and the system’s administrator installs SQL for me. They mean well, they really do, but they aren’t expected to know the performance hit you…
Tag: Certification
Preparing For The 70-432
I’ve passed both of the Database Developer exams. Now, I’m going to start on the Administration exams. I’ve already purchased The self-paced guide. I’ve also scanned through the materials. What I want to do is make this guide a bit more conversational. I honestly believe that’s one of the missing bits when it comes to…
I’m a MCITP, now what?
It’s been a few days shy of two months since I got my MCTS: SQL Server 2008, Database Development, I passed the 70-51. As a result, I’m now a MCITP: Database developer. I’ve been pushing pretty hard to get this one out of the way so I can begin my training for the administrator track. …
70-451:Linked Servers
I’m coming to the end of my posts on identifying which SQL Server components to use to support different business requirements. I’ve already covered SQL Server Agent, DB mail, Service Broker and Full-Text Search This time I’m going to go over linked servers. Not exactly the link I was talking about! Linked servers allows your…
70-451: Full-Text Search and Service Broker
Ok, over the past two posts I’ve been discussing some SQL Server Components and what they’re good for. I’ve already spent some time with the SQL Server Agent and others. In this article I want to dig into some scenarios you can solve using Full-Text searches. Let’s dive right in. Scenario 1 You have a…
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 requirements.” To do this you’ll need to be able to recognize the strengths of the different components of SQL Server. In my last 70-451 article I covered SQL Server Agent. …
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 process and the levels Jedi go through on their way to becoming masters. I think I’m going to keep that one in my back pocket for a while…
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. It was the unknown that I was really worried about. I’ve been a database programmer for over a decade. People come to me…
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. With it, as long as you know what information you’re looking for, you can jump right to the view that can help you find the data…
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 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…