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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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

    41 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

  2. SSMS Completion Time

    After installing SSMS 18.2, I have noticed that when I run the command sp_helptext 'stored_procedure_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  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  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. 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.

  9. 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

    21 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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 →
  11. SSMS Intellisense shows useless parameter names for functions like REPLACE, SUBSTRING

    For functions like REPLACE, SUBSTRING, etc., the Intellisence shows the parameters as Expreession1, Expression2, etc. instead of useful parameter names like Expression, Pattern, Replacement. g (max. 5000 Zeichen)

    4 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 →

    Hello

    In both SSMS 17.9.1 as well as SSMS 18 Preview 6, both REPLACE and SUBSTRING functions show meaningful hints.
    For REPLACE we show – expression_to_be_searched , search_expression, replacement_expression .. etc.
    For SUBSTRING, we show expression, starting_positionm length etc.

    If you are using older versions of SSMS, please update to the latest version as we are currently not supporting any versions older than 17.9.1.

    thanks,
    Dinakar

  12. Make Scalar UDF with no data access running parallelly

    There are different scalar-value UDFs:
    - (1) Interpreted T-SQL UDF,
    - (2) Natively Complied T-SQL UDF and
    - (3a) CLR UDF with DataAccessKind.None, which is default option.
    - (3b) CLR UDF with DataAccessKind.Read.

    For CLR UDF, if its USERDATAACCESS = 0, then it�s not a parallel plan blocker.
    For other type of UDF, even we use WITH SCHEMABINDING option, and USERDATAACCESS = 0, it�s still a parallel plan blocker.

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSMS install location

    SSMS should not be "magically apple installed" to wherever it pleases. it should ask me where the #$@% I want it to live. How the hell do you drop such a simple and basic feature? Rationalize all you want about how nobody *needs* it, or it has a small footprint so it's ok, or ... or ... - but it's stupid.

    Simple stuff MS, stop turning into Apple and find your way again... atm you're lost on every simple thing and customers like my enormous company are starting to fall away... (We dropped dozens of sql server installs this year)

    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. Intellisense for REPLACE function is useless

    Please have a more helpful Intellisense description for the REPLACE function...

    You need to come up with something better than REPLACE(expression nvarchar(1), expression nvarchar(1), expression nvarchar(1)) RETURNS nvarchar(1)

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow users to disable phone-home feedback in SQL 2016 Developer, Express, and Evaluation Editions

    By default, SQL Server 2016 phones home with telemetry data as described in https://support.microsoft.com/en-us/kb/3153756. Let users disable that telemetry in Developer, Express, and Evaluation Editions.

    0 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 →

    Upvotes: 325

    <=-=Jun 2 2016 10:19AM=-=>

    From https://www.microsoft.com/EN-US/privacystatement/SQLServer/Default.aspx, “It is possible that personally identifiable information may be captured in memory or in the data collected from open files, but Microsoft does not use it to identify you.”
    My developers must write and use interfaces to bank cores. Because of https://support.microsoft.com/en-us/kb/3153756, my developers will potentially be sending MS the bank accounts, names, addresses, social security numbers, birth dates, and various passwords for millions of US citizens. This is unacceptable.

    <=-=Jun 2 2016 11:26AM=-=>

    I was going to install it on my report server but I can’t if this isn’t fixed because even the potential of leaked data is serious to my clients. In fact, I already keep a SQL express version separate for my internal reporting from my non-express SQL Server engine to minimize exposure. That means I’ll need to stick with 2014 which is too bad as I…

  16. Implement Batch Mode Support for Row Store

    I would love to see the Batch Mode implemented for the Row Store, it would bring a major improvement to the query execution plans performance.
    With current data growth explosion almost no OLTP system is working on couple of hundreds of rows, the real numbers are moving very fast into millions.

    OLTP systems can't be viewed only from the perspective of writing the data, where in fact small amounts of data are processed, but when dealing with a constantly increasing number of rows read - this situation needs to be addressed.

    I constantly see systems where index scan operators are…

    26 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 →
  17. String or binary data would be truncated

    Msg 8152, Level 16, State 13, Line 2
    String or binary data would be truncated.
    The statement has been terminated.

    A lovely error in a 300 lines of SQL update statement in SQL Server 2005, it does not say what field was truncated, what line was truncated.

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

    We’ll send you updates on this idea

    9 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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 →
  19. 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 →
  20. 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.

← Previous 1 3
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base