Post reply

Allow developers to install sql express on desktops?

  • August 14, 2013 at 8:48 am

    #277029

    Hi! i'd like to know your thoughts about this:

    is it ok to allow developers to install sql express on their work pcs?

    is there any security issue or danger because of having sql instances all over the network that are not administered by the dba team?

    thanks!

  • August 14, 2013 at 9:36 am

    #1641466

    Hi,

    That depends entirely on what they're doing with them. In my shop all developers have a local copy of SQL Server dev edition installed and there's also a dev edition installed on the central development server where our continuous integration software runs.

    Allowing the devs to develop on their local machines means that the central dev server breaks less.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • August 14, 2013 at 11:16 am

    #1641503

    s_osborne2 (8/14/2013)

    Hi,

    That depends entirely on what they're doing with them. In my shop all developers have a local copy of SQL Server dev edition installed and there's also a dev edition installed on the central development server where our continuous integration software runs.

    Allowing the devs to develop on their local machines means that the central dev server breaks less.

    Thanks,

    Simon

    I second this. Developers should have developer edition with real sized data on database.

    Dev editions are so cheap that this should not be an issue.

  • August 14, 2013 at 2:47 pm

    #1641571

    First, I second both responses to your question. I actually have a couple versions of SQL server installed on my machine: 2008R2 Developer Edition & SQL Server 2012 Express. Developer Edition was installed for me when I got my PC, I installed 2012 Express because I really prefer SSMS 2012 over SSMS 2008.

    On a performance note: I recommend disabling the SQL Agent and setting the SQL Server Service to manual instead of Automatic. Start it when you need it, stop it when you are done.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • August 14, 2013 at 3:44 pm

    #1641596

    Depending on the size of the company you could always have a list of standards for them to use when they install (hopefully developer edition unless they need the other like Alan stated). That way you could help address any security/performance concerns. For example, I had uploaded something like that to a sharepoint site for developers to view. All the companies I have worked for let the developers do the install.

  • August 14, 2013 at 4:14 pm

    #1641612

    thanks,

    we decided to have just developer servers instead of having one sql instance on every developer PC.

Viewing 6 posts - 1 through 5 (of 5 total)

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