I'd start here to get a very good "In A Nutshell" overview.

http://www.kimballgroup.com/1997/08/02/a-dimensional-modeling-manifesto/

Sean Lange (4/30/2014)

---

Jeremy Brown (4/30/2014)

---

I find more often than not, people go overboard on naming standards (in my honest and humble opinion).

I know I'm probably going to catch...

Bear in mind, the server you restore to should be exactly the same (version, sp possibly even cu, but I'd not swear to that one) as your old one otherwise...

OCTom (4/25/2014)

---

The very worst naming convention I saw was years ago on an AS400 (1981).

Tables are called files on that machine and reside in a library.

The naming was such:

Library001

...

Oh, and one other thing.

Anything justified purely on the basis of "It Saves Typing" is grounds for the removal of their keyboard, possibly bodyparts depending on how bad...

I don't think I could put it any better than this. So I won't try. http://www.sqlskills.com/blogs/paul/disaster-recovery-101-restore-master-rebuild-master/

Eric M Russell (4/24/2014)

---

If a software application is hard coded to use the "SA" account, you can rename it and then create a new account named "SA" with limited permissions....

"Work in an area of IT so specialised and geeky, even the other geeks have no idea what I do or how I do it"

Steve Jones - SSC Editor (4/23/2014)

---

Yes and no. As a DBA, I've tried to be proactive and look...

dwain.c (4/21/2014)

---

Greg Edwards-268690 (4/21/2014)

---

TomThomson (4/20/2014)

---

Fillet "a fish" is not a good...

jasona.work (4/23/2014)

---

Gary, I think if MS open-sourced the MCM questions and scenarios, you'd fairly quickly find people using them as templates to create new questions and scenarios for newer versions...

I really like the idea, but I suspect the lawyers would stamp on it quite firmly.

In that case I'd run a full update statistics against all your databases if you've not already done...

I'm with all of them, and further than that I'd just install Michelle 'SQLFool' Ufford's maintenance script, configure any elements specific to your environment and largely forget about it. ...

GilaMonster (4/10/2014)

---

Why? Why would you want more than half of the memory on the server...