What are the advantages of SQL Server 12, 14 and with TOOLS & ADVANCED SERVICES 2015-06-24T04:31:30+00:00

Home Forums General discussion What are the advantages of SQL Server 12, 14 and with TOOLS & ADVANCED SERVICES

  • Author
    Posts
  • Greg
    Member
    Post count: 2

    What are the advantages, disadvantages, issues and best Tabble practices with using any of the following for SQL SERVER 2012, or 2014, Express or 2016 when Express for it arrives?

    I would presume to use 64 bit on my 64 Win 7 systems, but want to clarify and ask about tools and services.

    SQL Server 20XX LocalDB Express 32bit
    SQL Server 20XX LocalDB Express 64 Bit
    SQL Server 20XX Express 32 Bit
    SQL Server 20XX Express 64 Bit
    SQL Server 20XX Express with Tools 32 Bit
    SQL Server 20XX Express with Tools 64 Bit
    SQL Server 20XX Management Studio Express 32 Bit
    SQL Server 20XX Management Studio Express 64 Bit
    SQL Server 20XX Express with Advanced Services 32 Bit
    SQL Server 20XX Express with Advanced Services 64 Bit

    Thanks,
    Greg

  • Greg
    Member
    Post count: 2

    Meaning in part… which of these versions is the best for use with Tabbles, and why.

  • xkat
    Member
    Post count: 39

    I’ve used SQL Server since version 7, but, still, please regard this ‘answer’ as slightly-educated guess (;

    all should work OK (v.2008 is fine) – assuming the bugs are worked out (don’t install on the first day it comes out) I usually use the most recent version.
    Management Studio gives you a UI to investigate/export/backup the database (I also use MS Access)
    My logic: SQL server is used in many high-end implementations world-wide – the incremental upgrades are often useful, particularly from the Management Studio standpoint, and more and more bugs are killed (unfortunately some get added, too)
    I use, presently, 64bit 2014 Express with Management Studio – what MS Downloads calls
    ( ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe )

    I make sure to use all 64bit MS products on this machine, because there are incompatibilities with mixing Office versions, in some cases, and I value having MS Access on this machine, which allows me to manipulate SQL Server databases in a familiar Office UI type environment.

    Irregular updates to SQL Server are sent out on Windows Update. It is likely that sometime after SQLSvr 2016 comes out, 2014 will get some updates rolled out.
    Personally, I will stick with 2014 in this TABBLES environment for another year, probably.

    hope that helps

  • xkat
    Member
    Post count: 39

    i tried to answer this question, but TABBLES forum timed out, and then gives an error – ‘you already posted this answer’. or some such ?!?!? when it obviously is NOT POSTED.
    i’ll try again later

  • xkat
    Member
    Post count: 39

    OK – maybe it works now?

    I’ve used SQL Server since version 7, but, still, please regard this ‘answer’ as slightly-educated guess (;

    all should work OK (v.2008 is fine) – assuming the bugs are worked out (don’t install on the first day it comes out) I usually use the most recent version.
    Management Studio gives you a UI to investigate/export/backup the database (I also use MS Access)
    My logic: SQL server is used in many high-end implementations world-wide – the incremental upgrades are often useful, particularly from the Management Studio standpoint, and more and more bugs are killed (unfortunately some get added, too)
    I use, presently, 64bit 2014 Express with Management Studio – what MS Downloads calls
    ( ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe )

    I make sure to use all 64bit MS products on this machine, because there are incompatibilities with mixing Office versions, in some cases, and I value having MS Access on this machine, which allows me to manipulate SQL Server databases in a familiar Office UI type environment.

    Irregular updates to SQL Server are sent out on Windows Update. It is likely that sometime after SQLSvr 2016 comes out, 2014 will get some updates rolled out.
    Personally, I will stick with 2014 in this TABBLES environment for another year, probably.

    hope that helps

You must be logged in to reply to this topic.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close