Home Forums SQL Server 2008 SQL Server 2008 Administration How did you accumulate and where do you keep your administration scripts (or other scripts for that matter) RE: How did you accumulate and where do you keep your administration scripts (or other scripts for that matter)

  • November 30, 2012 at 3:58 pm

    #1564598

    capnhector (11/30/2012)

    I have a question for the more experienced DBA's out there. im starting to develop queries and scripts that make administering the sql server instances i have (not many but its good experience for when i may start to look for my first "real" dba job). the question becomes where do you keep your script files (thumbdrive, drop box, 5.25 floppy?) and how did you accumulate them (writing them your self, other people you work with, or out on the net?).

    Im now getting more into the administration of the servers instead of just fixing the jobs. (now im doing backup and restores helping in disaster planing and more)

    Disclaimer: I do NOT work for Red Gate. But I do use their Scripts Manager tool to store many of my favorite scripts. I've linked it to a local folder that points to my SkyDrive so I have access to the raw files from anywhere.

    http://www.red-gate.com/supportcenter/Product?p=SQL%20Scripts%20Manager

    Most of the scripts I've accumulated over the years have been a combination of things I've written, code from trusted and reliable sources on the internet and from peers and others I've worked with.