SSMS Maturity

  • Comments posted to this topic are about the item SSMS Maturity

  • There is hope. It is paramount to bring the server engine along but SSMS is what the users see and has helped differentiate the platform from other good platforms.

    I am mostly fine with SSMS but I am curious to see where the new team takes it.

    This is the kind of annoying stuff that drags the product's reputation down that will hopefully be cleaned up right away, with the innovative features and improvements to follow:

    Object Explorer bug open for years

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • And here I thought that the SSDT Add-In to Visual Studio was going to be the new path MS was going.

    Dan Beggs

  • Ah the visual studio shell.

    When we finally migrated to SQL Server 2012, Microsoft told us that the eliminated the MDI interface forcing me to use a tabbed interface for the first time in a decade. It was a change ill suited for how I work.

    412-977-3526 call/text

  • Hopefully MS will give some love to SSMS and make it a better, more useful product.

    I spend most of my day in SSMS and while it does the job, there are so many improvements that it needs.

    If all they do is make IntelliSense finally work I would be a happy person.

  • I downloaded SQL 2016 - SSMS the other day. I really like. Intellisense seems to be more "feature-rich". Yet to try out live query stats.

  • Maybe BI developers who use SSIS and SSRS daily have a different perspective, but as someone in Dev/Ops who spends most of my time coding T-SQL in tandem with DBA stuff, I like using SSMS more than (BIDS / SSDT / Visual Studio / aka "Data Dude"). For me, SSMS looks less cluttered and feels less kludgy.

    I will say that the SSMS diagramming tool could use an upgrade. Third party ERD tools are expensive, but I occasionally need to throw together a basic diagram for my own usage or for pasting into a design document.

    I'm not sure if this already exists, but Microsoft should have a dedicated blog spot on MSDN maintained by the SSMS team that includes sample C# project template along with official documentation on how to create SSMS AddIns.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Eric M Russell (7/2/2015)


    Maybe BI developers who use SSIS and SSRS daily have a different perspective, but as someone in Dev/Ops who spends most of my time coding T-SQL in tandem with DBA stuff, I like using SSMS more than (BIDS / SSDT / Visual Studio / aka "Data Dude"). For me, SSMS looks less cluttered and feels less kludgy.

    I agree with you.

    I spend some of my day in SSIS/SSDT I find these tools to be clunky, non-intuitive and awkward to use. 2012 SSDT seems to have regressed in user friendliness and ease of use from 2008 SSIS.

    If I was allowed, I would write all of my ETL processes in SSMS/PowerShell.

    SSRS, well, there is a special place in hell for this program. Spent 3 years working with SSRS and not a day went by without a few WTF's being thrown around.

  • As long as I can continue to work with my 2008 R2 I'll be fine.

  • Eric M Russell (7/2/2015)


    I'm not sure if this already exists, but Microsoft should have a dedicated blog spot on MSDN maintained by the SSMS team that includes sample C# project template along with official documentation on how to create SSMS AddIns.

    There's never been any official support or allowance for add-ins. Redgate reverse engineered and used Reflector to find a way. We released the framework for others to use: http://documentation.red-gate.com/display/MA/SSMS+ecosystem+project

    Disclosure: I work for Redgate.

  • Steve Jones - SSC Editor (7/2/2015)


    Eric M Russell (7/2/2015)


    I'm not sure if this already exists, but Microsoft should have a dedicated blog spot on MSDN maintained by the SSMS team that includes sample C# project template along with official documentation on how to create SSMS AddIns.

    There's never been any official support or allowance for add-ins. Redgate reverse engineered and used Reflector to find a way. We released the framework for others to use: http://documentation.red-gate.com/display/MA/SSMS+ecosystem+project

    Disclosure: I work for Redgate.

    SSMS might not have a future without AddIns for stuff like object searching and T-SQL formatting. Every release of SSMS should come bundled with a starter project, code samples, and documentation for AddIns.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • dbeggs57 (7/2/2015)


    And here I thought that the SSDT Add-In to Visual Studio was going to be the new path MS was going.

    Meaning? Everything in SSDT? Or SSMS as an add-in?

  • BL0B_EATER (7/2/2015)


    I downloaded SQL 2016 - SSMS the other day. I really like. Intellisense seems to be more "feature-rich". Yet to try out live query stats.

    What's "more feature rich"? The new features added to intellisense? Or it works better.

  • Try Aquafold Data Studio. Well worth the money in my opinion.

    It's a database IDE for !multiple dB platforms plus erd capabilities plus SSH shell plus snippets plus NoSQL support plus source control integration plus....you get the drift

  • Eric M Russell (7/2/2015)


    SSMS might not have a future without AddIns for stuff like object searching and T-SQL formatting. Every release of SSMS should come bundled with a starter project, code samples, and documentation for AddIns.

    Addins are not really the thing to push for... it would be a massive boost if they made it support extensions (VSPackage/MEF) properly.

    Right now it does work with MEF extensions, but without the VSPackage support you don't get the full benefit.

    Especially important if they do move to VS2015, with no official support for Addins

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

Viewing 15 posts - 1 through 15 (of 24 total)

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