“I’ll Wiki you my pretty… and your little script too!!” So I submitted my first Wiki article over at SQLServerPedia: Restoring a User Database to a Different Environment and I have to admit that when I first started thinking about it I was quite concerned about how to do it, whether the script is “wiki [...]
Posts from ‘September, 2009’
BINGO!!!
Let’s talk about Alerting. Alerting is like a nice fun game of BINGO. When a new ball is pulled and the announcer yells out “Under the B… 6″ if everyone stood up at the same time and yelled “NO BINGO” and the one person who needed B6 yells out “BINGO” chances are you’d probably miss [...]
I am not the first DBA to take up this cause… but I am determined to be the last
OK maybe this article is not THAT important LOL but it was a great quote by Obama so I figured I’d work it in LOL Please know what Recovery Mode your databases are in and your recovery requirements and then back them up accordingly. Too often I see databases that are in a Full or [...]
The Yo-Yo Diet For Your Database
Everytime I see a database with both AutoGrow and AutoShrink enabled I cringe. I don’t “snicker” cause I leave any and all snickering to when someone says the words ”Access Database”. See here if you’re confused. OK so why is having both AutoGrow and AutoShrink enabled on your database such a bad thing… I mean Microsoft [...]
When you want the MAX row that’s NOT the MAX row
Yeah me too LOL… let me break it down for you… If the data was in a race and the MAX row is considered the Gold Medal… the user wants the Silver Medalist. So because sysobjects exists for every database my use-case will work with that table cause then I don’t have to worry about [...]
