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. Please bring back the Databases Filter option in SSMS 18

    The ability to right-click on the Databases folder in the tree and pick "Filter" was in SSMS 17 but is no longer available in SSMS 18.4 (as of this post). Why was that feature removed? Can you please bring it back?

    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 →

    To be fair, I have no recollection of removing it from SSMS 18… and I just tried with SSMS 18.5.1 and I can filter databases and tables just fine.

    Is the menu item missing for you? Or the functionality missing/broken? It is not immediately clear what the attached pictures refer to.

    Please, enter another UV item if you have more details.

    Thanks,
    -Matteo

  2. SSMS: Freeze Column Headers When Scrolling

    It would be nice if we could "freeze" column headers in SSMS like in Excel, so it's a little easier to remember where we are in larger result sets, and get helpful screenshots of data.

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

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSMS Completion Time

    After installing SSMS 18.2, I have noticed that when I run the command sphelptext 'storedprocedure_name' with the configuration "Results to Text' set, it always add the Completion Time text at the end.

    I would like to suggest printing out this as a comment, so when I copy and paste the query into a new query, I don't need to delete or comment it out all the time.

    For instance:
    -- Completion time: 2019-09-16T17:23:48.4080495+10:00

    Thanks.

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

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Select All option for File Import Wizard

    The Flat File Import Wizard should have a Select/Unselect All option on Allow NULLs

    3 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 →
  5. Good afternoon, please add the database diagrams, there are databases in which one works and they have diagrams, help to solve that, thank y

    Good afternoon, please add the database diagrams, there are databases in which one works and they have diagrams, help to solve that, thank you

    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. Don't deprecate database diagrams.

    I design large scale databases visually with the diagram feature of SQL server. I cannot comprehend how a db designer would tackle a large scale ER model. What is the reason for the deprecation and what is the planned alternative?

    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 →
  7. SSMS 508 compliance

    Trying to determine 508 compliance for SSMS; any guidance available?

    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 →

    Our 508 Conformance documentation can be found the the following link
    https://celaaatprod.blob.core.windows.net/public/1e153b8b-985d-4b0e-9ef9-5fd4170e0c84/52e451a1-b639-4fbe-94ae-55de5d66e06c/SQL%20Server%20Management%20Studio%2018.Windows.RevisedSection508.docx

    This document along with those for other accessibility standards can also be reached by https://cloudblogs.microsoft.com/industry-blog/government/2018/09/11/accessibility-conformance-reports/ and searching for “SQL Server Management Studio”

    Thank you for reaching out,
    Erica

  8. 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 →
  9. Reimplement ERD Diagrams in (SSMS18)

    ERD Diagrams are basically needed to check the structure (visual) of a database. it was a key component of SSMS. Why would you even remove it and force us to install another 3rd party app, while SSMS is already a bloatware on itself...

    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 →
  10. SSMS - Delete the saved user when logging in

    I wish to be able to delete only some saved users from the login screen.
    I know there is a file that I can delete and clear this record, except I did not want to delete all and only those that I no longer use.
    If possible the connections of the instances too.

    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 →

    If you are referring to the “Connect to Server” dialog, then one thing you can do is something like this:

    - Click on the “Server name” combobox (the down-arrow icon)
    - Select the server you want to remove
    - Hit the “DEL” key

    You should be able to do the same thing when you select “SQL Server Authentication” and you work in the “Login” combobox.

    You need SSMS 18.x for that to work on Logins.

  11. Database Diagrams

    Please add Database Diagrams back in SQL SERVER Management Studio

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

    We’ll send you updates on this idea

    44 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    This was completed in SSMS 18.1.

    Caveat: there is still a known issue where diagrams created from SSMS on machine A opened with SSMS running on machine B would cause SSMS to crash.

    This has been reported already and it is being investigated (it is just not as simple as I would like to be).

    Thanks,
    -Matteo

  12. Could you also unlock TDE for the Standard Edition? Due to new legal regulations in DE/EU (General Data Protection Ordinance), many databas

    Could you also unlock TDE for the Standard Edition?

    Due to the new legal regulations in the DE/EU (General Data Protection Ordinance), many databases should be encrypted.

    For many small/medium sized companies it is impossible to switch to Enterprise.

    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. Restore CTRL-D shortcut for ResultsToGrid in SSMS

    In SSMS 18 Preview 4, the default binding have changed to Edit.Duplicate lines, quoting https://feedback.azure.com/forums/908035-sql-server/suggestions/32896594 as a the motivation.

    CTRL-D has been bound to ResultsToGrid, for almost 20 twenty years (that is since Query Analzyer came out in SQL 7.) That is engraved in many people's minds.

    Yes, I can change the key binding, but so can people who prefer to use it to duplicate lines.

    Please restore the original default. It does not serve the community to change existing bindings.

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

    We’ll send you updates on this idea

    completed  ·  4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add Default Backup Checksum Option to SSMS GUI

    SSMS should have a checkbox under Server Properties, on the Database Settings page, labeled something like "Use Backup Checksums" that would toggle the sp_configure setting for "backup checksum default". This would make it easier for people to enable backup checksum default, which is a good "best practice" that the tooling should encourage.

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Identify Slow Queries in Stored Procedures

    Slow queries in stored procedures are difficult to find. After much searching on Google and some enhancing, I use the query below to find slow queries. The 3 ORDER BY clauses find the slowest query per execution, the query with the highest total time, and the query that executes the most. It is very helpful to know which query in which stored procedure is slow. I suggest adding this or something similar to the "Reports->Standard Reports" area of SSMS.

    SELECT qs.totalelapsedtime,

             qs.last_execution_time, qs.execution_count, qs.total_worker_time,
    
    so.name,
    SUBSTRING(st.text,qs.statement_start_offset/2+1,
    ((CASE WHEN qs.statement_end_offset = -1 THEN DATALENGTH(st.text)
    ELSE qs.statement_end_offset END) - qs.statement_start_offset)/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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Why must one perform a full backup to add to an AG, when the wizard does a full backup?

    When adding a database to an availability group, one must perform a full backup, before meeting the prerequisites.
    However, once you do this, the wizard just performs another full backup anyway.
    This seems redundant.
    Why not just let the wizard do this, and not make it a requirement, as it's going to happen anyway?

    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 →
  17. 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 →

    We take a number of inputs into consideration when triaging issues. Business impact (severity of the issue) as well as Votes (or likelihood of a customer being impacted) are just two of the factors we consider when triaging.

    We do not simply use votes alone.

  18. Azure AD authentication in Import Export wizard in SSMS

    Ssms 2017 doesn't have the capability to use Azure AD authentication in Import/Export wizard.
    We have stopped providing Sql authenticated users to support people, we are using AD authentication which works seamlessly. However there is one more place in SSMS which requires the functionality.

    When users try to use import export wizard they dont have possibility to use Azure AD authentication instead they need to use a SQL authentication which completely ruins our security setup and going back to the old way of accessing Azure Sql db.

    Can the SSMS team add this little functionality so that it does in…

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

    We’ll send you updates on this idea

    completed  ·  7 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Give us option to not have square brackets when drag&drop in SSMS

    When we drag something from OE into a query window, then the identifier will always be enclosed in square brackets. Many of us do our due diligence and take care to use identifiers that do not require separators. These separators makes SQL code (a lot) harder to read, and we feel that we are punished with these square brackets. We don't want to do a search and replace all over and over again, when there could just be a setting in SSMS to not generate these.

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

    We’ll send you updates on this idea

    25 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. SQL Object Scripting "Check for object existance" doesn't work as desired in SSMS

    Ever since SSMS 2012, using this option has produced undesirable code. It worked fine in SSMS 2008 and 2008R2 and I would like some way to restore that functionality.

    When scripting out a view, I want the script to be:

    IF (view exists) DROP VIEW;

    CREATE VIEW blah blah blah;

    I want two steps: Drop and Create. And I want the generated script to run correctly whether or not the view is already there. (this applies similarly to triggers, stored procedures, functions, indexes, etc... anywhere you can script for 'drop and create').

    I loathe the current behavior of using either…

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

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base