Virtualization and SQL Developer

  • Greetings, I should be getting SQL server developer delivered today in the mail, curious as to what the group thinks are the best practices with it as I am just learning SQL.

    Also, I've setup a virtual environment through virtual box (host and guest both windows 7 64bit)… are there any benefits in setting up a server in the virtual environment as opposed to my machine?

    Any advice would be appreciated!

  • If you are doing it strictly for development purposes, then there shouldn't be any problem with just running a local instance of sql server.

    Personally, I run everything inside virtual machines so that I can get a little more structure and test how machines will interact with each other. I've gone as far as to configure a virtual domain, in order to test AD security etc. I also like the ability to snapshot machines, and revert to them when testing out methods that could end up making a mess. In my own department I have been advocating the use of virtual machines for sql development.

    Why is it that people who can't take advice always insist on giving it? - James Bond, Casino Royale

  • sql4gnt (1/29/2014)


    If you are doing it strictly for development purposes, then there shouldn't be any problem with just running a local instance of sql server.

    Personally, I run everything inside virtual machines so that I can get a little more structure and test how machines will interact with each other. I've gone as far as to configure a virtual domain, in order to test AD security etc. I also like the ability to snapshot machines, and revert to them when testing out methods that could end up making a mess. In my own department I have been advocating the use of virtual machines for sql development.

    The more experience and exposure the better, thanks for the advice!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply