See, that's why you're not a real MCM yet. An MCM turns on auto-shrink to make sure...

Here's everything you need to know to pass the MCM lab:

Drop all the primary keys.

Then just close the...

Ha! Thanks, sir.

I can't see myself doing the MCA anytime soon. I'm not sure if I could pass it, but I'm quite sure I don't deserve to pass it....

James Stover (2/12/2012)

---

When I got my MCM (makes it sound like I'm so old,...

Stephanie Giovannini (1/13/2012)

---

I'd quit my job and wouldn't work for an employer ever again. No commute, no parking garage, no ID badge, no "desk" (two-sided "cubicle" in a hallway, banquet...

Erika and I talk about this pretty regularly. I really believe that the only purpose of working is to get enough money so that you don't have to work...

IceDread (8/28/2011)

---

You were not listening. You can not go into a store and purchase a harddrive and install it yourself soon because of apples firmware, you must purchase it from...

Kind of ironic that you'd say this in a Microsoft SQL Server forum, eh?

If you're really serious about openness,...

Steve - welcome to the club!

JLangdon - I totally understand where you're coming from. From the outside, it would seem like using Apple gear would make your life tougher,...

I want less knobs in the GUI, and more knobs that are enabled via T-SQL.

When I got started, I'd check all kinds of boxes in the GUI trying to make...

Jonas Bergström (6/8/2011)

---

Thank you Brent. I actually read your blog post about rockstars yesterday and feel a bit like, I don't now, not really a rock star, but at least...

You might want to refine your question to include whether you're referring to SQL Server's native compression, third party backup compression, or both. The answer changes if you're talking...

Glad I could help - and again, great series! The community really needed this step-by-step level of training, and I love seeing 'em go live.

Ha! Had to reply since my name got thrown in here, heh.

I'm usually all for including the CUs with one exception - I try to keep the production, QA,...

Nice article! Just one tweak:

"If one page in an extent is owned by TableA or IndexB, all eight pages will be owned by that same object. An exception...