SQL Server

Microsoft SQL Server 2017 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 2017 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.

Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Color for defined variables

    Currently defined variables "@Example" fall under the 'Identifer' category as far as custom colors in the text editor is concerned and I would like for them to be able to be distinguished. I am asking for them to be broken out as a different category so they can be customized (I basically want them to stand out so I can more easily see where they go without having to do a search for "@" etc.)

    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. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. CREATE OR ALTER is not fully supported in Transactional Replication DDL commands

    We've been having trouble with some objects not replicating correctly after a DDL change.

    When a published function or proc is altered, the following appears to happen:
    A database trigger is called: tr_MStran_alterschemaonly
    Which calls a proc called: sys.sp_MStran_ddlrepl - This proc will output debug IF MSrepl_debug_DDL exists (create anything called this!)
    which calls a function: master.sys.fn_replgetparsedddlcmd, which is designed to return the ddl after the object's name, to be used for generating the command to be applied 
    at the subscribers.

    SQL Server BOL states that ALTER is supported (https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/replicate-schema-changes?view=sql-server-2016)

    However, this doesn't appear to be the case:

    (13.0.4451.0):…

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. SQL Server Management Studio 2018: bad icon

    The icon for SQL Server Management Studio 2018 blends in with the default windows 10 start menu tile background. This does not look very good.
    The SSMS 2017 icon had a white outline around the little crossed tools, so that you could still see things regardless of the colour of the tile background

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. SQL Import and Export Wizard

    I have been using SQL Server since it was born and the Import Wizard has consistently had issues with registrations of file types and transformations. In this day and age of AI, ML and exotic claims of smart technology I find it difficult to believe that this import "Wizard" still requires me to go through hoops to determine registration requirements and combinations and permutations of possible formatting issues. This has got to be one of the dumbest "Wizards" out there and maybe can get some loving and caring in the next release. Cheers Peter Molloy

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

    We’ll send you updates on this idea

    unplanned  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Dark theme leaves blank spots in query editor on resize

    I have the dark theme enabled in SSMS 18, and when I resize the application window, or resize the results panel, huge chunks of my query editor get blacked-out. The text is still there, and the glitch goes away when I scroll around, but it's a pain, and it looks bad when I'm presenting my work.

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Make SSDT Available for Linux as well

    As of now, if we need to build the SQL Server project, we need the SSDT toolkit on a Windows machine to build the project. Is it possible to make it available for Linux as well so that we can build the SQL server project not only on Windows but on Linux as well?

    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. Change the title of a report to be different from .rdl file name

    If my RDL file is named Reportforseeingthings.rdl

    Displayed the web portal report title as "Report for seeing things"

    This would allow users to adhere to URL design best practices and give designers the ability to accomodate their clients naming pattern requests.

    2 votes
    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 →
  9. Dark Theme in DevOps ignores color in textboxes

    The Dark Theme for DevOps works nicely in general, but text in textboxes does not show font color/background color.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add backup configuration to the setup process for SQL Server.

    What I’m asking for (besides you to upvote that User Voice item) is for Microsoft, as part of SQL Server setup, to add two new screens. The first would be called “Backup”—it would offer a dire warning to the effect of:

    In order to protect the data in your databases, Microsoft strongly encourages you to take backups of your data. In the event of hardware failure, data corruption, or malicious software, Microsoft support will be unable to help you recovery your data, and you will incur data loss. This box is checked by defaults to enable automatic daily backups of…

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

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  11. Adding Multi-column IN clause support by SQL Server

    Currrently, SQL Server does not support multi-column IN clause. For example, the following query :
    Select * from tableA where (columnA, columnB) in select (columnX,columnY) from tableB
    will not run, failing by displaying the error :
    non-boolean type specified in a context where a condition is expected”

    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 →
  12. The Context Menu in the object explorer is incorrect.

    When using a dark color theme, the context menu can not be read.
    Background and foreground colors are black.

    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. SQL Server Data Import and Export Wizard: When "Delete rows in destination table" is chosen, don't attempt to Truncate the table

    When this option is chosen, the Import/Export Wizard actually does a Truncate on the selected table. This will fail when there are any foreign key constraints on the table, with the following error message.

    Executing the query "TRUNCATE TABLE {table_name}
    " failed with the following error: "Cannot truncate table '{table_name}' because it is being referenced by a FOREIGN KEY constraint.".

    There's a disconnect between what the UI says it will do (DELETE) vs. what actually happens (TRUNCATE).

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

    We’ll send you updates on this idea

    unplanned  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQL Server Data Import and Export Wizard: Order of Tables

    When using the Import/Export wizard to copy multiple tables from one DB to another, it would be great if SQL Server could intelligently determine the order to process the tables based on foreign key constraints.

    With the current behavior I will often get foreign key constraint failures because data is loaded into a child table before the data is loaded into the parent table.

    It should be possible to determine an optimal load order by using the foreign key constraints defined on the tables. If not, then it would be nice to be able to manually set the order.

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

    We’ll send you updates on this idea

    unplanned  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. "Add Azure Replica" button missing in SSMS 17.9. Present in SSMS 2016

    In the New Availability Group Wizard, the "Add Azure Replica" button is missing in SSMS 17.9 but is present in SSMS 2016 (130.0.16106.4). Is this a bug?

    I saw this related item: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7512f490-5b30-49f0-b617-3eabce321015/add-azure-replica-button-missingnot-present?forum=sqldisasterrecovery

    Thank you!
    Mike Petrak

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Mike,
    This is not really a bug.

    The button was removed from SSMS intentionally because SSMS only supported the “classic” resource provider, which was deprecated. As such, the functionality was not there anymore and there was no point in confusing the users by exposing something that was indeed broken.

    We encourage people to upvote this feedback item: this way we’ll be able to prioritize the request accordingly.

  16. New security role for SQL Agent - SQLAgentAdminRole

    I feel the SQL Agent roles are too limiting. If you want to allow freedom in a development, or assign management of SQL Agent jobs to a person; even SQLAgentOperatorRole doesn't do much. This means SysAdmins are still required to assist others in altering/removing jobs.

    I propose a new role that allows the member to do anything with SQL Agent, like a member of SysAdmin, but without the access to all other parts of SQL Server that SysAdmin provides.

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

    We’ll send you updates on this idea

    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Dark Theme in SSMS 2017

    I am new here. Using SQL server for maybe 1 year and I am really sad because you don't have the dark theme... I hope you will be available it soon, thanks :)

    i can do something like this: https://www.sqlshack.com/setting-up-the-dark-theme-in-sql-server-management-studio/, but it not as good as original :/

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

    We’ll send you updates on this idea

    4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Dark Theme

    Dark theme for SQL Server 2017 SSMS is missing.

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

    We’ll send you updates on this idea

    12 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. Ability to upgrade SQL Server Management Studio directly from About menu

    I think it will be really cool to update the management studio directly from the about menu when it is open and also it for checking for new versions and notify us.

    Thanks in advance

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

    We’ll send you updates on this idea

    4 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

    We have a “Check for updates link” in the Tools menu today, and SSMS prompts you to upgrade when it detects a new version unless you have turned off auto-check for updates. We have no plans to further automate these updates. We are pushing more updates through WSUS for enterprise installations.

  20. SSMS Standard Reports -- Include as .rdl files

    Include the standard reports as .rdl files so that they can be modified and saved back into the "Custom Reports" folder.

    10 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 →
← Previous 1 3 4 5 168 169
  • Don't see your idea?

SQL Server

Feedback and Knowledge Base