Tag Archives: mcm

A Full Backup can Impact a Log Backup–MCM Prep

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

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

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

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

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

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

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

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

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

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 ,