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. binary or string data would be truncated => error message enhancments

    if you have that error (in production), it's not obvious to see which column or row this error comes from, and how to locate it exactly.
    it's even more complicated if it's coming from a trigger, for example, and not the original insert/update.

    I have seen that oracle meanwhile gives clear information which column the error is raising, which actual data length was passed, and the column's max size.

    1,156 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    100 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

  3. 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 →
  4. 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  ·  6 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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

  11. 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 →
  12. 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 →
  13. 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 →
  14. Option to specify the SSMS 2016 Installation Path

    The Installation of SSMS 2016 makes the Path Environment path very long. To get around it we would like to install it on a shorter path, but it looks like there is no option to specify the Installation Path like there was when SSMS was part of the SQL installation in SQL 2014.

    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 →

    This can be done with SSMS 18.
    Please download the Preview 5 and validate if you are able to do this.
    Also note that the install needs to happen via command line to install SSMS in a [non-C] folder.

    For instance, for culture = en-us, the install would look like:

    SSMS-setup-enu.exe SSMSInstallRoot=“X:/MySSMS”

    thanks,
    Dinakar

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

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

  19. 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 →
  20. 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 →
← Previous 1 3
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base