Adding to SQL Server

  • Comments posted to this topic are about the item Adding to SQL Server

  • A sophisticated full-text search with sophisticated phonetic matching capability would go down a treat.

    Being able to deploy onto Linux would be fantastic.

    A formal metadata and lineage facility that takes into account replication, SSIS/AS/RS, linked servers, cross database dependencies etc.

    I wouldn't worry about SSMS as long as there is Red-Gate;-)

  • My list of desired feature and improvements looks something like this:

    Instance/cluster aware SSIS.

    Scheduled Servicepack release schedule, like once per year (yes, I would consider this a feature!:-))

    Many improvements to Management Studio, including, but not limited to

    - GUI interface to some of the newer engine features, that require T-SQL to interact with.

    - better stability, less freezes when an action in one window takes a long time complete.

    - redesign of many "sub windows", so there is adequate space to the information they hold and they are resizeable.

    Other areas, where improvements are overdue:

    Cleanup in old system SPs and views, correct spelling mistakes.

  • A complete rebuild of SSRS so that central reporting can look better, deliver more value and take less time to develop.

    Central reporting is necessary for day-to-day reports, high performance requirements, and anything that should be kept rigorously audited. By not putting any development into a tool fundamentally geared towards providing this function it increases risk within businesses as users find they can produce reports in Excel that look better and take less time to build. This is great except you start getting rogue departments who make decisions off of incorrect figures or are able to massage their figures and hide issues. I like self-service BI but I think there has to be a core suite of central reporting that covers the majority of the requirements within an organisation otherwise most people will spend their time building and maintaining spreadsheets.

  • More around the automation side of things, to start with: -

    A powershell aware installer.

    A way to determine installed features, other than "Setup.exe /Action=RunDiscovery", a powershell cmdlet that returns a recordset maybe.

    https://connect.microsoft.com/PowerShell/feedback/details/761518/sql-server-features-discovery-cmdlet

    Both of these would help enterprise management.

    Replication

    Allow replication from one distribution database to another and then have multiple subscribes hanging off the second distribution database. Effectively this would mirror the possibilities within Sybase RepServer and their use of RSIs. The major benefit to this comes when replicating to multiple subscribers across a WAN. By sending the data across the wan once to what is effectively a staging DB, there is less traffic on the WAN.

  • Integrated unit testing. I don't know any details. I know there are applications of various techniques out there. I just want something out of the box that is integrated into the tooling as part of the SDLC. Perhaps it could be something where it is architected so alternatives can be swapped in to appease (in a positive sense) the desire for open systems.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • A minor request, but I would very much like to have GREATEST() and LEAST() like MySQL has.

  • nickd-799913 (1/31/2014)


    A minor request, but I would very much like to have GREATEST() and LEAST() like MySQL has.

    Good point - let's get group_concat() 🙂

  • I would like to see a simple, yet robust mechanism to ensure users cannot access an instance directly (i.e. via SSMS or whatever) when using Windows Integration. In other words, I would like to limit them to access through my front-end application only.

    I've researched this before and the only options I could see were to use an application role (which has limitations), certificates (too complex?) or a logon trigger that checks what application the user is coming in using (not a particularly elegant solution in my opinion).

    Surely the great minds at Microsoft could come up with a simple solution for this!

  • I would like to see a TRIM() or ALLTRIM() function build into SQL server in future versions instread of having to use the Ltrim(Rtrim()) combo.

    -Codeman

  • Yes to Alltrim()! I feel dirty, like I'm doing a dirty hack every time I do LTRIM(RTRIM()).

    I'd love a undockable results pane in SSMS. so I can put my results on one monitor and keep working on my script in another.

  • I was about to write the same as cody.leaf, regarding TRIM and I was thinking maybe it was not that important. But I see at least one other person is REALLY ANNOYED by the fact then need to use ltrim(rtrim())

  • cody.leaf (1/31/2014)


    I would like to see a TRIM() or ALLTRIM() function build into SQL server in future versions instread of having to use the Ltrim(Rtrim()) combo.

    -Codeman

    Yes!!! I see I'm not the only one REALLY ANNOYED by this...

  • More love for SSMS: Specifically I'd like it to look just like Visual Studio (themable, good intellisense, more modern look etc), and roll in all the other tools (profiler and performance tuning assistant or whatever it is called). When you execute a query you could get the option of tuning hints right there.

    I find my current workflow becomes cyclical between Visual Studio, breaking down the query into parts and testing them ad hoc in SSMS. Then I commit the code, migrate my database. Run the profiler/performance analysis and find out something wasn't optimal. Would be great if you could get it all in one place. I realize there is a data sku of VS but in my experience at least DB development often gets munged together with the other jobs of the services layer developers and it is the level of functionality that they need for their C# development that determines which VS they get, not the "little scripts they occasionally need to write".

  • CREATE or ALTER

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

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