Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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 Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Report parameter defaults not updated during deployment

    Parameter defaults do not get updated when re-deploying existing reports. These either have to be updated manually or the reports deleted and re-deployed. The latter regenerates all report ID's (GUID's) and makes traking usage from the ExecutionLog more difficult.

    This is explained here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1 as being by design however I can't envisage parameter defaults and prompts being maintaned by an administrator.

    An override mechanism similar to OverwriteDataSources should be added to Reporting Services projects to allow deploymnent from Visual Studio.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 132

    <=-=Oct 25 2007 6:20PM=-=>

    Thanks for the suggestion. We’ll consider for a future release.

    <=-=Aug 14 2008 3:56PM=-=>

    Parameter defaults could easily be maintained by an administrator in an ISV scenario, as opposed to an internal IT solution scenario. The ISV ships reports with hidden parameters used to customize behavior, using sensible default settings. Those defaults are changed by the customer’s administrator after the report is deployed to customize the behavior of the report to their needs.

    Those customized defaults should not be overwritten when an updated report definition received from the ISV is deployed.

    <=-=Sep 12 2008 10:09PM=-=>

    A default parameter override check-box should be available. Not all reports have an administrator setting default params. And having to go and set parameters after a deploy is not an optimal use of a report developers time.

    <=-=Aug 4 2009 2:33PM=-=>

    I agree with TDog3, and so does every…

  2. Support Distributed Availability Groups with Distributed Network Names

    Instead of needing an ILB for AGs and FCIs, IaaS-based SQL Server deployments in Azure now support the use of a Distributed Network Name (DNN) for FCIs or an AG's listener. This makes deployment a little easier.

    However, if you have Enterprise Edition, are using FCIs or AG listeners with DNNs instead of traditional network name resources, you cannot currently deploy a distributed AG. That requires an ILB.

    Microsoft should build the right plumbing into DNNs to support distributed AGs as it is an important disaster recovery and migration feature.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  3. Poor transaction handling causes CU upgrade to fail

    On every upgrade (CU, SP etc) the install process runs the script msdb110_upgrade.sql.

    I have spotted a few places where the error handling is not good. Consider this passage:

    BEGIN TRY
    
    EXEC sp_grantdbaccess @loginame = @owner_name
    END TRY
    BEGIN CATCH
    RAISERROR(&#39;A problem was encountered ...&#39;, 10, 127) WITH LOG
    END CATCH

    The CATCH handler should include the line

    IF @@trancount &gt; 0 ROLLBACK TRANSACTION
    

    sp_grantdbaccess, a remnant from SQL 2000, includes this passage:

    exec (@stmtU)
    
    if @@error &lt;&gt; 0
    begin
    ROLLBACK TRANSACTION
    return (1)
    end

    But the ROLLBACK will of course never be executed, if the error is caught by…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  4. Update Collation of Partition Functions and User-Defined Table Types via SQLSERVR -Q

    𝓟𝓵𝓮𝓪𝓼𝓮 add support for Partition Functions and User-Defined Table Types (UDTT) to the global Collation update process performed by the "-Q" switch of SQLSERVR.EXE. As far as I can tell, these are the only two objects that are not modified by this operation.

    ☑ Yes, I am fully aware that the global Collation update process initiated by the "-Q" switch is undocumented, and hence unsupported. (i.e. MS is not committing to maintaining this particular code)

    ☒ No, I am 𝑛𝑜𝑡 requesting, even implicitly, that the "-Q" switch become officially documented and supported.

    ☒ No, I am not expecting 𝑎𝑛𝑦 guarantees…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Unified Tools Page

    PowerShell tools and modules for SQL Server are being kept separate from the other SQL Server tools - the tools for SQL Server are kept in so many different places that it is impossible to find them. For example, I need information on the SQLServer PowerShell module and what it can/can't do, but when I type SQL Server Tools into a search engine (whether Bing or Chrome), I do not get the right results and have to dig for answers. This should be easy. Please consolidate your tools into a fashion where people can find the right tool for the…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow Query Store to be created in its own Filegroup

    When configuring Query Store you should be able to choose which filegroup you want it to be stored, so you don't store all that data in the PRIMARY Filegroup allowing a better management of the data it captures and preventing any type of performance impact on highly transactional databases just to mention some benefits.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  7. SSDT - Support T-SQL parameter defaults for SQLCLR objects via the SqlFacet attribute when generating the publish and create SQL s

    Currently there is no way to specify that any input or output parameters to a SQLCLR stored procedure or function should be optional and have a default value.
    The T-SQL wrapper objects (i.e. "CREATE {object} ... AS EXTERNAL NAME {Assembly}.{Class}.{Method};" ) do allow for default values to be specified
    (except for the LOB types: NVARCHAR(MAX), VARBINARY(MAX), and XML), but there is no way to indicate that to the SSDT publishing process.

    In order to set a parameter default value, you need to either update the SQL script that has the CREATE statement (prior to deployment)
    or issue an ALTER PROCEDURE…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 11

    <=-=Aug 3 2015 10:28AM=-=>

    Hi Solomon,

    Thanks for submitting this feedback. Your suggestion makes a lot of sense. Unfortunately, we’ve evaluated this suggestion relative to our other development tasks and decided not to implement support for this functionality at this time. We appreciate that you took the time to submit this feedback, and we hope you’ll continue to share your ideas for improving our SQL Server tools in the future.

    Regards,
    Steven Green
    SQL Server developer tools team

    <=-=Mar 23 2016 1:26PM=-=>

    Because with no function overloading, optional parameters is the only way to provide multiple calling signatures for a function is defaults… which you refuse to implement.

    Does anybody at Microsoft actually use SSDT and SQLCLR?

    <=-=Feb 19 2017 10:48AM=-=>

    It is always two sides opinion, from MS side, MS thinks no many people are using CLR inside SQL Server, but on the other hand from…

  8. Configuring mssql-server on Linux/documentation/automation

    It seems on Linux we are supposed to use mssql-conf to configure mssql-server, as there is no full documentation on how to edit /var/opt/mssql/mssql.conf directly: it's just mentioned with an example file of which it is unclear if it shows the complete list of parameters.
    Besides that, there is a mismatch between the configuration parameters in the file and the mssql-conf parameters[*], so it's hard to know what to put in there (unless a lengthy process of trial and error using mssql-conf).

    [*] https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-ver15

    I would like the documentation to be extended so that it includes the matching mssql.conf parameter.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  9. SSMS 18.5 Setup Error

    I encounter an error while trying to setup SSMS 18.5 :
    Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3

    pls. fix that issue ! thx !

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  10. add SQL Server Reporting Services upgrades to Windows Update Catalog

    Request to add SQL Server Reporting Services (SSRS) upgrade to windows update catalog.
    Since version 2016, SSRS is separate from SQL Server Engine setup.exe. SQL Server has cumulative updates and security patches which can be installed in an enterprise via WSUS. However SSRS updates do not show up on the catalog. Can these be added?

    https://www.catalog.update.microsoft.com/Search.aspx?q=SQL%20Server%20Reporting%20Services

    only finds updates to SSRS back from SQL Server 2016. Where is 2017 and 2019?

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  11. Update rs.exe to .net after 3.5

    rs.exe (even with SSRS 2017) requires .net 3.5.
    It should run in .net 4 or above

    Microsoft says .net 3.5 isn't included with Window Server 2016 and above without extra work as per
    https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/microsoft-net-framework-35-deployment-considerations

    This is literally my only requirement for .net 3.5 on the entire network

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  12. allow to reinstall or repair Python, R (and other components)

    When some components like Python or R are not correct installed then I can't find a way to reinstall them. These components can't be removed, the repair will not work, the Link in the error description will not work. But there should be a way to repair these components.

    Detailed results:
    Feature: Python
    Status: Failed
    Reason for failure: An error occurred during the setup process of the feature.
    Next Step: Use the following information to resolve the error, and then try the setup process again.
    Component error code: 0x84B40002
    Error description: The SQL Server feature 'sqlinstmpy' is not…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSIS Permissions to prevent only deployment of project

    ssisadmin gets all the privileges in ssis. There is no option to use custom roles in ssisdb as ssisadmin is hard coded in the ssis internal procedures. If we have to give users all the privileges (like create folder, create environments) but deny only deploying new projects, there is no way to do it. This leads to a lot of dependency on ssis administrator because he has to handle everything for the users..

    Can we have


    1. A new role for allowing everything of ssis_admin but not the deployment?

    2. Using custom roles, so that we can control access to…
    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  14. Please give control over installation location, don't want to use my C drive

    Please give control over installation location, don't want to use my C drive

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  15. Create a Softwareupdate Catalog for SCCM

    For automatic Update SSMS over SCCM

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  16. Give me an option to install SSMS to a drive other than my Operating System drive!

    Give me an option to install SSMS to a drive other than my Operating System drive! We have strict rules that require minimizing installations on the operating system drive which are in part related to common rules for antimalware and other applications.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  17. Install Linux SQL Server binaries in a user defined filesystem rather default filesystem /var/opt.

    As of now SQL Server binaries getting installed by default in a /var/opt, but as each user environment is different and wanted to set up in a dedicated filesystem, so it would be easy if the installs can go whatever user defined filesystem.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  18. Machine Learning Server 2017 GUI/Client For Model Building [R - Python] For Non-code Users

    If there is a GUI client model builder for SQL Server Machine Learning 2017 similar to Azure Cloud studio [the below screenshot] to do the data preparation and designing and deploying the model it will be a great feature. The current approach with the ML Server require a technical expert with extensive coding capabilities which make it almost impossible for the Business User to utilize the new feature where the trend and the requirement right now is Self Service Analytics, Augmented Analytics and Data Science Citizen. Adding such interface will add a large and important segment to the current users.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  19. SQL 2016 RC2 setup upgrade fails when default backup directory is a network share

    While upgrading instances SQL Server Setup can throw an error of "Updating permission setting for folder '\......' failed. The folder permission setting were supposed to be set to '...)'. This is because it's trying to set permissions on a network share.

    It is extremely common for environments to backup to network shares; a backup on the local server is worthless if the server fails.

    The option provided by Setup upon encountering the error is to either Retry (which will never work) or "click 'Cancel to cancel this action and continue setup.' This fails the database engine upgrade unnecessarily.

    Once this…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  20. Ability to Change Timezone at SQL Instance Level

    As SQL Server Consolidation gains stream it is conceivable that we will like to host SQL instances on same machine with different Time Zone Requirements. Being able to set Timezone at the Instance level will thus allow us to set individual Timezone setting for each hosted SQL Server Instance.

    Also, as Cloud Deployments increases and access to OS Settings such as Time Zone Setting is shielded away from the Administrator, significant Code development changes at the Client & Database layer may significantly delay or prohibit Cloud Deployment plans.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base