SQL Server

Microsoft SQL Server powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.

More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Stack Overflow or MSDN.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. SSMS keep filters when opening or closing

    I would like to remains configuration about filters in SSMS
    filters on database,
    filters on tables,
    filters on views,
    filters on procedures

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Open SQL Agent Job Activity Monitor from Registered Servers

    Many times I connect to a SQL Instance only to get to the SQL Agent Job Activity Monitor. I wish I could open SQL Agent Job Activity Monitor from the context menu for a server in Registered Servers. It would be faster and more convenient for me and a little less traffic on our servers.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Replication Monitor Start Menu Icon

    Please put an icon for Replication Monitor in the Start Menu.
    Having to open SSMS and connect to some random server to right click the Replication node to open Replication Monitor does not make sense when Replication Monitor is not opened in the context of the server that is open in Object Explorer.
    It would also be good to put it in the SSMS Tools menu.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Configure the query store also at the instance level and not just database

    Query Store is a important feature to simplifies performance troubleshooting by helping us quickly find performance differences caused by query plan changes but only at the database level.

    Can you improve in order to enable it at the instance level?
    With this improvement, we could analyze the statistics (top CPU, Logical Reads, Duration ecc..) more precisely.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. script <object> as to new window with current connection

    Don't know why it has changed since previous version of SSMS.

    In SSMS v18.6, when you right click on an object (like table) and select script as create (or another option) and then select "New Query Editor Window", it now opens a new window, but it asks to reconnect (i.e. doesn't use the same connection).

    In the previous version (17), it would reuse the connection when you selected the same option (same as Ctrl + N shortcut), the previous version was much more user friendly and made more sense.
    Can't see an option in settings to change it back to…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Pipeline operator

    Add a pipeline operator |> that would allow passing arguments through multiple functions without nesting. This operator already exists in several functional languages, and is being strongly considered for ECMAScript as well (https://github.com/tc39/proposal-pipeline-operator).

    It is a great fit for T-SQL because in SQL you often cannot write code procedurally and need to instead call nested functions, which can be difficult to both read to write. The pipeline operator |> would make such situations far easier to read.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Specify Analysis Services database from SSMS command line parameters

    We need to be able to connect to an Analysis Services database instead of the Database Engine when starting SSMS from the command line. Power BI has a new "External Tools" capability to allow tools like SSMS to connect to the SSAS instance started by Power BI. It does this by passing the server and database names, which can be done by the SSMS command line, but it fails because there is no way to connect to an SSAS database from the command line. It is disappointing that 3rd party management tools work with this new Power BI feature, but…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. expand all nodes in properties tab

    When viewing nodes in the Properties tab of SSMS, often you wish to see all nodes (especially with recently added nodes like WaitStats, TraceFlags and ThreadStat.

    Giving a context menu to expand all nodes (or better still, registering viewers that can display grid data in a grid format) would make the tool much faster to use.

    A sample grid opportunity would be viewing of OptimizerStatsUsage which in my example has 49 nodes (sorted alphabetically, not numerically - rookie mistake) and 7 elements in each node. This is perfectly suited to viewing in a grid, rather than making us suffer in…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Email notifications on THIS site

    I like giving feedback. But I hate not GETTING feedback about MY feedback. How about you put in something where I get notified via email if and when someone posts a comment on any of my items, either submitted by me, voted on, or commented on?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Powershell cmdlet to pull upgrades for SQL server and SSMS automatically

    It would be great if we could get a powershell cmdlet that could be used to automatically download and/or install SQL and SSMS upgrades automatically.

    And also the possibility to get email notifications whenever a new SQL or SSMS upgrade is released, would be awesome.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. User preferences synced via AD settings

    Can we connect SSMS using active directory id & user can save the preferences? So if user installs the new environment or uses ssms on another machine, all of his/her settings are synced. It includes the connection information and other config settings.
    It will be nice to save the settings on AG groups, so that all developers have same settings.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. bcp switch for BOM

    bcp has no switch to control the byte order mark (BOM) of an unicode file.
    Please add a switch to turn BOM on or off.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. sqlpackage.exe DropObjectsNotInSource overrides options to not drop specific objects

    sqlpackage.exe has the option DropObjectsNotInSource . It's a useful option when that's what we would like.

    However, most times we would like to have some exceptions: avoid dropping some objects. There are many options in sqlpackage.exe to achieve this, the problems is the option DropObjectsNotInSource overrides the options about which objects should be ignored, making this task very difficult.

    I'm able to work around the problem with a custom deployment contributor filter, but just a simple change on how the options are applied would make everything easier.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. ssdt needs a default schema compare options

    This was present in old visual studio versions, but not anymore.

    We can still work-around this by saving one compare and never again using new schema compares, always open the saved one, but it would be interesting to have a better way to start the schema compare using default settings.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. When you release SSMS you should release it with a better name such as "SSMS-Setup-ENU_REL_18.6_Build_15.0.18338.0_22-JLY-2020.exe" .

    When you release SSM USE THE full name not some abbreviated DOS name. Please use "SSMS-Setup-ENUREL18.6Build15.0.18338.0_22-JLY-2020.exe" where you have all the release, build and date information in the name. The use of the name "SSMS-Setup-ENU.exe" is really not desirable.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. I would like to see dynamic column headings for SQL queries

    The ability to have dynamic column headings allows me to generate SQL Result Sets with columns that match my data. This would be especially helpful for cross tab queries or things that summarize for a date range

    In Example:

    Declare @Column1 as varchar(10),

        @Column2 as varchar(10), 
    
    @Column3 as varchar(10),
    @Column4 as varchar(10),
    @Column5 as varchar(10),
    @Column6 as varchar(10),
    @Column7 as varchar(10)

    Set @Column1 = Datename( weekday, dateadd(dd, -6, Getdate()) )
    Set @Column2 = Datename( weekday, dateadd(dd, -5, Getdate()) )
    Set @Column3 = Datename( weekday, dateadd(dd, -4, Getdate()) )
    Set @Column4 = Datename( weekday, dateadd(dd, -3, Getdate()) )
    Set @Column5 =…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Query Store - Force Recompile

    It would be useful to have an option in query store to "Force Recompile" for a plan. This would effectively have the engine add an "Option (Recompile)" to the statement to force recompilation each time it is submitted. Use case is where you have very variable data profiles such that forcing a specific plan isn't useful, and you can't change the code (vendor supplied etc.) to add the hint yourself. In these scenarios the overhead of plan recompilation can be minimal compared to the cost of the query when it uses a suboptimal plan (either optimiser determined or forced).

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. SSRS Web portal, Change default texts

    We have a SSRS Power BI server up and running, branding done to customers satisfaction

    However it is not possible to control the texts used in the below framed sections

    they derive from the language chosen by the user, but even if it is the 'correct' language, we want to change it to something for known to the users

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support for Change Tracking queries in AlwaysOn Secondary replicas

    Change tracking is a great feature for auditing or for capturing the data changes for an ETL process, but there is a limitation that the change tracking queries are not supported in AlwaysOn secondary replicas, If the secondary replicas can support change tracking queries we can leverage the secondary replicas as a data source for the ETL work load.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Distributed database support for SSRS scale-out deployement

    In SSRS scale-out deployment, the SQL Server support shares one common database for the entire RS nodes in the cluster. In a busy reporting environment like ours besides the normal locking and concurrency issues, I have seen bottlenecks in report processing and internal RS cleanup processes (like segment and its child tables cleanups).

    If there is a support for distributed database for the report server database, for example the data and work load is evenly spread across multiple RS databases, there would be a significant improvement in RS performance and would reduce common issues like locking contentions during the Report…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base