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. Allow upload .bak for a managed sql server database to selected server without the need for uploading the .bak to a blob storage first

    Upload .bak for a managed sql server database to selected server without the need for uploading the .bak to a blob storage first

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    triaged  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSIS 2016 XML Source task cannot load data from a URI (issue was resolved in 2012/2014)

    Having the same issues in SSIS 2016 that have previously been resolved in SSIS 2012 CU2 and 2014 CU4. refer https://support.microsoft.com/en-au/help/2991526/fix-ssis-2012-or-ssis-2014-xml-source-task-cannot-load-data-from-a-uri

    XML sources fetching data from a URI fail with:

    - The file "http://abc/xyz.xml" was not found. Please verify the file path and try again.
    - The XML Source was unable to read the XML data.
    - XML Source failed the prepare phase and returned error code 0xC02090D0.

    Still having issues in latest 2016 SP2 CU6 release

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. Error when dropping CLUSTER_TYPE NONE availability groups

    When you drop an availability group that is using CLUSTER_TYPE NONE you get the following error:

    Msg 41080, Level 16, State 0, Line 1
    Failed to delete SQL Server instance name to Windows Server Failover Clustering node name map entry for the local availability replica of availability group 'myAG'. The operation encountered SQL Server error 35222 and has been terminated. Refer to the SQL Server error log for details about this SQL Server error and corrective actions.

    Given that CLUSTER_TYPE NONE means the availability group is not using WSFC for cluster coordination dropping the availability group should not even try…

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Automatically generate sql agent job

    For long running processes, where we use SSMS on our clients (as opposed to an RDP session), it would be awesome to have an option to construct and launch a SQL Agent job to execute the query, instead of having it run in the query window. That way the query execution would no longer be dependent upon connectivity of the client, allowing long running jobs to finish when I go home for the evening.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add "Create or Alter" to scripting options in SSMS

    As of SSMS 17.9.1, the script context menu for stored procedures and other objects only contains options to "Create To," "Alter To," "Drop To," and "Drop and Create To." There should also be a "Create Or Alter To," and based on priority, it should probably be the first item in the list since it covers the next two items. This would also be a useful option in the "Generate Scripts" context item for databases, since "Create or Alter" is the most convenient action for version-controlled object scripts.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. SUSE 12 SP2 is no longer supported.

    MS SQL on Linux needs to be updated to run on current version of SUSE linux. 12SP4 or 15

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  7. SSMS 17.x for SQL Server 2019 Diagrams & Debugging

    Many SQL Server customers are dismayed that Database Diagrams and SQL Debugging have been removed from SSMS 18 (wait until all the users that didn't preview SSMS 18/SQL 2019 find out the hard way).

    I would be very helpful if Microsoft were to create an SSMS 17.x release that supports Database Diagrams and SQL Debugging for SQL Server 2019. I would not ask that it support all the new SQL Server 2019 features. Of course, though, SSMS 17.x and SSMS 18.x would need to be able to coexist on a computer.

    This would give the SQL Server user base a…

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SSMS 2018 Database Diagrams - Display Only

    I, among many others, was dismayed to find that Database Diagrams were discontinued in SSMS 18.

    My organization's documentation processes are based on SSMS diagrams, which we have counted on since SQL Server 2000.

    We do not use the diagrams for database design. We use them to support our team of developers by giving them a visual representation of what is in our databases. (I do database design brainstorming in an old copy of Visio 2010 installed on a VM. I can type column names in a DDL script as fast as I can type them into a GUI designer.)

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. SSMS 2018 Temporal Table Icon

    In SSMS 18.0 RC1, in Object Explorer tree, the icon for temporal tables is still a colorful, old-style icon instead of a stark, new-style icon.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. Maximum sequence objects on 2016

    How many sequence objects can create on SQL 2016? Is there any limitation about it?

    I have checked some documentation but could not find any info.

    Thanks.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. SQL Migration from 2012 to 2016

    Set up a fresh install of SQL on Amazon or Azure. Save a back up on the web and install to the mirror 2016. Once installed Migrate the data to an install from back up disk. Make sure to make a boot disk for your mirror. Or just install 2016 onto 2012. The first method is if you want to ghost and mirror multiple computers without using any room on the rack space plus the benefit of scheduled maintenance and fire-walled administrator control.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  12. DATA_COMPRESSION

    In SSMS Version v17.9.1, we are able to choose to review "Data Compression" at the Index Level, but the SQL generated only requests "Data Compression" savings at the Object Level.

    Generated code looks like :-

    exec sys.sp_estimate_data_compression_savings 'dbo','Customer',NULL,1,PAGE

    Please keep in mind the index_id should be the third argument, but NULL is being generated and passed.

    The data received is also for the entire table and not for the index.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. The OLE DB provider "MSDASQL" has not been registered. (.Net SqlClient Data Provider)

    when I apply the sql server 2017 in the Ubuntu 16.4 and connect it to mysql by SSMS, I linked by ODBC but failed. The error as blow:

    在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
    在 Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd, Boolean retry)
    在 Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection()
    在 Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LinkedServerConnectionTest.Invoke()

    ===================================

    The OLE DB provider "MSDASQL" has not been registered. (.Net SqlClient Data Provider)

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Unable to restore backup created in linux sql server 2017 in windows sql localdb 2017

    Recently, we migrate to sql server for linux. When we try to restore a backup in sql server for windows, the following error message is displayed: System.Data.SqlClient.SqlError: System table sysfiles1 is corrupted.

    The SQL server versions are the same 14.0.3076

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. SQL Server Management Studio 18RC1 status bar colors are missing

    The status bar color in SQL Server Management Studio 18RC1 is colorless. It should be pink for multi server connections and khaki for singe server connections.

    I can go into Tools, Options, Text Editor, Editor Tab and Status Bar and set it but the status bar will reverted to colorless the next time SSMS is opened,

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Ssis to connect with aws, Google etc

    It would be nice if SSIS has the capability of connecting AWS(Amazon web service), Google services etc.. Since most of the company migrating to aws and I'd data needs to pull from aws to sql using Ssis is not possible which leads to have third party tool to connect.. Hence if this option available in Ssis than it will be great to way forward. Thanks

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. TFS integration for DDL for SQL server

    Add a feature to integrate SQL Server with TFS, so any DDL changes (stored procedures, views, functions, table definitions) are checked out/in of TFS. All DDL is versioned and tracked (by users login/domain names).

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Bad contrast in dark theme

    It's really hard to work with such bad contrast.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. Plug-ins to connect Aws, Google etc from SSIS

    Hi Team, it's my small suggestion to improve ssis. Kindly build plug-ins to use AWS, Google etc from Ssis and now we could use only third party tool.. Instead try to build own plug INS and you can charge accordingly or if any built already please let me know.

    1 vote
    Sign in
    (thinking…)
    Password icon
    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 457 458
  • Don't see your idea?

SQL Server

Feedback and Knowledge Base