Home Forums SQL Server 2008 SQL Server Newbies advice for questions to ask regarding new database for 3rd party application RE: advice for questions to ask regarding new database for 3rd party application

  • Wow, I don't even go near that until I have some conceptual concepts of the model.

    IE: Archiving usually only happens on a few tables. Security may or may not be deeply discussed depending on how the application intends to get involved. And other things.

    I usually start with "Can I see the thing?" and go from there. Are you in a medical repository and do you need to obey HIPAA, and do the lawyers care about this database? Sure, point in time recovery versus overnight backups and things are definately things to discuss, but that's never where I'd start. You need to know what you're protecting and administrating before you can start to ask intelligent questions and offer solutions for the expectations.

    Well, I do, anyway. Don't know about you guys.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA