Categories: News, Professional, SSC
Comments: 1 Comment
Published on: June 30, 2011

I have a new tune stuck in my head now.  It got stuck there this afternoon shortly after my computer was forced into a reboot.  I was in the middle of writing a blog post, working on some stored procs and some general queries.  All of the sudden my system is shutting down and I can do nothing to prevent it.

After SSMS closes, my browser closes, the command prompt that is running a chckdsk is forced closed, then the logoff window appears and I see that windows updates are being applied.  SOME OF IT ITCHES!!!!!  Why can’t Microsoft allow us some latitude when running these updates?  I could understand it if the patches were scheduled to be installed and prompted a reboot – I got none of that.  Do I need to have critical updates forcibly applied to my systems so frequently?  And believe me this is occurring much more frequently than the mythological 2nd Tuesday of the month.

In the end I am happy that these updates did not toast my windows install like an update did a few weeks ago.  But I seriously have seen enough of these updates over the past few months and something has got to change.

70-450 Study Guide

Categories: News, Professional, SSC
Comments: No Comments
Published on: June 30, 2011

In my last post concerning my certification journey I said I may post a study guide.  I have thought it over and a sweetened condensed version of some of the topics covered would prove helpful.  Based on the Skills Measured page for the exam, one can determine topics to study and pretty much google for related materials.

So let’s start with the high level of skills measured.

Designing a SQL Server Instance and a Database Solution

Partition Switching

Collecting Data in regards to upgrade prep or installation and base-lining.

Best Practices

Capacity Planning


Designing a Database Server Security Solution


Context Switching

Filestream Storage

SSRS Authentication


Designing a Database Solution for High Availability

Publishing Data

Database Mirroring


Physical Architecture (Replication)

Designing a Backup and Recovery Solution

I won’t cover this topic at all.  This should be a high priority topic for all Database Professionals.  This is one of those areas that is best covered through practice and experience.

Designing a Monitoring Strategy

Correlate Monitoring Data – One should be acquainted with this topic.  I have heard it in interviews.  Furthermore, it really makes you a better DB professional.

Data Collectors


Designing a Strategy to Maintain and Manage Databases


Central Management Server

Resource Governor

Policy Based Management

Designing a Strategy for Data Distribution

SSIS Deployment

Distributed Transactions

SSIS Security

Linking Servers


As I said, this is a condensed version of some of the topics that I studied.  Since these topics map directly back to the measured skills published by Microsoft, they are topics well worth studying.  Whether or not they will be on your exam or not, who knows.  You should also note, that these links pretty much point back to broad-sweeping topics and are not specific in nature.  The one exception being the extra monitoring link I threw in because I feel it is important to know regardless of ability or exam preparation.

page 1 of 1

June 2011
« May   Jul »

Welcome , today is Sunday, November 17, 2019