Tag Archives: mcm

A Full Backup can Impact a Log Backup–MCM Prep

Posted on February 2, 2011 by

In the early days of SQL Server you could not run a log backup while a full backup was running. In fact,you tried to schedule them apart from each other early in my career to prevent collisions. Nothing bad happens, … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

SQL Server Recovery–MCM Prep

Posted on January 31, 2011 by

I always have to think about what happens during the recovery process in SQL Server after a restore. I’ve always known the process as roll forward and roll back, which is how the items are noted in the SQL Serve … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Master Training

Posted on January 27, 2011 by

As a kid, growing up on Bruce Lee, Chuck Norris, and Saturday afternoon Kung Fu Theater, I always wanted to be a martial arts master. A few years later, being a Jedi Master caught my interest despite the fact that … Continue reading →

Posted in Editorial | Tagged , ,

You Need Two SLAs for Disaster Recovery

Posted on January 18, 2011 by

Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once again surprised by something. Typically I have heard all kinds of talk for SLAs, usually in terms of network traffic. … Continue reading →

Posted in Blog | Tagged , , , ,

Isolation Levels–MCM Prep

Posted on January 17, 2011 by

I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew there were four levels, but I hadn’t realized that SQL Server used the default of level 1, out of the … Continue reading →

Posted in Blog | Tagged , ,

Resource Governer–Memory Limits

Posted on January 12, 2011 by

I had looked at the Resource Governor early on when it was being developed and first released on SQL Server 2008, but I hadn’t spent a lot of time on it. It was the first cut at a throttle that … Continue reading →

Posted in Blog | Tagged , ,

T-SQL Tuesday #14–Resolutions

Posted on January 10, 2011 by

It’s T-SQL Tuesday time again, and this month the Midnight DBAs (Jen’s blog | Sean’s blog | @MidnightDBA) are hosting the party. You can read about the whole T-SQL Tuesday blog party idea from Adam Machanic (blog, Twitter) if you … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

MCM Prep – Sliding the test

Posted on January 4, 2011 by

If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night that I was scheduled for this Friday, but I’m nowhere near prepared. Not that I’ll be totally prepared, but I’d … Continue reading →

Posted in Blog | Tagged , | 1 Comment

MCM Prep – Only ONE Transaction Log File

Posted on January 4, 2011 by

Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves performance. The writes are not striped across files. Instead SQL Server will write to one file, then the next, then … Continue reading →

Posted in Blog | Tagged , ,

Quick MCM Prep Help

Posted on December 31, 2010 by

Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4 or 5 before I left, dropping the MP3s on my iPhone, and I listened to a few of them on … Continue reading →

Posted in Blog | Tagged ,