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. Intellisense not work

    IntelliSense keywords not show please fix it SSMS 18.9.1

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. Having trouble installing Microsoft SQL Server Management Studio with Azure Data Studio

    I'm trying to install Microsoft SQL Server Management Studio with Azure Data Studio, release 18.9.1 on my desktop. It gets stuck at the "loading packages, please wait" window and I have to close via Task Manager.
    Advice please.

    1 vote

    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. Fix SSMS recovery once and for all. This has been broken forever!!!

    When your computer reboots unexpectedly you have about 50/50 shot of SSMS actually recovering the windows you have open. This is absolutely ludicrous that in 2021 your developers can't seem to get this right. Perhaps look at a free public application like Notepad++ for reference on how this should work. Just allow the windows that were open to always come back. Let the developer decide to close them. The recovery fails so often and you end up losing work it's ridiculous already. Please fix this!!!

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Global python variables do not work when running python scripts

    Global python variables do not work when running python scripts.

    For example the code below errors:
    EXECUTE spexecuteexternal_script @language = N'Python'

    , @script = N'
    

    myGlobal = 5

    def func1():

    global myGlobal
    
    myGlobal += 1

    def func2():

    print(myGlobal)
    

    func1()
    func2()
    '
    GO

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow sp_setapprole and sp_unsetapprole to be executed by sp_prepexec

    Currently, it is not possible to use the sp_setapprole or sp_unsetapprole with the JDBC driver to make use of the CallableStatement interface to retrieve and use the cookie.

    That's because in JDBC-the-API (as opposed to just MS-JDBBC-the-driver), all CallableStatements are considered to be a subclass of PreparedStatement. The MS JDBC driver accordingly attempts to do the sp_setapprole in the context of an sp_prepexec. Which fails with Stored procedure sys.sp_setapprole can only be executed at the ad hoc level.

    The workaround of using a regular Statement puts upon the application developer the burden of encoding the cookie bytes…

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. azure sql deny internet

    It would be great to allow "Deny Internet" If Service Endpoint is configured. currently we can only deny internet if we have private endpoint. A service endpoint is still in a private network. Not the same as PE but still secure and private. so we should be able to close of internet with this OR Private endpoint. thanks

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. SSMS 18.9.1 crashing on startup after latest windows updates!

    Event Logs (in order of appearance). Dump file excluded to protect the innocent:

    Application: Ssms.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.NullReferenceException
    at Microsoft.SqlServer.Management.RegisteredServersUI.AzureDataStudioTree+<>cDisplayClass10.<GetConnectionNodes>bf(Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnection)
    at System.Linq.Enumerable+WhereListIterator1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
    at Microsoft.SqlServer.Management.RegisteredServersUI.AzureDataStudioTree+&lt;GetConnectionNodes&gt;d__12.MoveNext()
    at System.Linq.Buffer
    1[[System.Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.Collections.Generic.IEnumerable1&lt;System.__Canon&gt;)
    at System.Linq.Enumerable.ToArray[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable
    1<System.
    Canon>)
    at Microsoft.SqlServer.Management.RegisteredServersUI.AzureDataStudioTree.BuildFullTree(System.Windows.Forms.TreeNode, Microsoft.SqlServer.Management.RegisteredServers.AzureDataStudioConnectionStore, Int32, Int32, Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree)
    at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.Initialize(Microsoft.SqlServer.Management.RegisteredServers.ServerGroup, Microsoft.SqlServer.Management.Common.ServerType, Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType, Microsoft.SqlServer.Management.RegisteredServers.AddCentralManagementServerDelegate, Microsoft.SqlServer.Management.RegisteredServers.AddNewCentralManagementServerDelegate, Microsoft.SqlServer.Management.RegisteredServers.DeleteCentralManagementServerDelegate, Microsoft.SqlServer.Management.RegisteredServers.GetServiceProviderDelegate)
    at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerControl.RegisteredServerControl_Load(System.Object, System.EventArgs)
    at System.Windows.Forms.UserControl.OnLoad(System.EventArgs)
    at System.Windows.Forms.UserControl.OnCreateControl()
    at System.Windows.Forms.Control.CreateControl(Boolean)
    at System.Windows.Forms.Control.CreateControl()
    at System.Windows.Forms.Control.WmShowWindow(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.ContainerControl.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.UserControl.WndProc(System.Windows.Forms.Message…

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add a feature so a New Query (CTRL+N) can be Editable

    Allow me to open a new query window with a hotkey (similar to CTRL+N) that uses the same interface as the "Edit Top 200 rows" feature provides. This would give me a more direct way modifying data in an editable SELECT query. Have it open with the SQL Pane visible.

    Another idea is to allow me to select text in a normal query editor, and similar to the CTRL+SHIFT+Q to open the Query Designer, open a new tab with the selected query but using the "Edit Top 200 Rows" interface with the SQL Pane visible.

    As far as I can…

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Start job at step...

    According to UI standards, menu items ending with ... imply that there will be yet another dialog to specify additional information before initiating the action. But in SSMS context menu of SQL Server Agent job has the item "Start job at step..." which actually starts the job immediately, without asking at which step - see the screenshot

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSMS - Error - "Constructor on type 'Microsoft.SqlServer.Management.SqlManagerUI.ManageSchedulesControl' not found. (mscorlib)"

    1) Launched SQL Server Management Studio

    2) Connected to Microsoft SQL Server Instance

    3) Accessed SQL Server SQL Server Agent Node

    4) Accessed Jobs

    5) Right clicked Jobs and tried to access Schedules by choosing " Manage Schedules" from the dropdown menu

    6) Error Received. The error reads "Constructor on type 'Microsoft.SqlServer.Management.SqlManagerUI.ManageSchedulesControl' not found. (mscorlib)"

    Version

    Product

    SQL Server Management Studio - v18.9.1

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. Trace flag 3688 no longer works after SQL 2014: Removes messages to errorlog about traces started and stopped

    THis is a regression it appears. Ever since we moved to SQL 2016, this trace flag: 3688, which we used to suppress messages about "stop and start trace" in the ERROR LOG.

    There was a hotfix released in SQL 2008, but has since NOT been included in versions past SQL 2014, not sure why.

    Here's the original bug:

    https://support.microsoft.com/en-us/topic/kb922578-fix-lots-of-messages-that-have-message-id-19030-and-message-id-19031-are-logged-in-sql-server-2005-sql-server-2008-or-sql-server-2008-r2-errorlog-file-when-you-use-sql-server-profile-in-sql-server-2005-in-sql-server-2008-or-in-sql-server-2008-r2-af51f56d-9073-bbd6-b280-98d68cf9b3b0

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Custom Window Titles

    I often have several copies of SSMS running, with different queries for different projects I am working on.

    If I could click on the title bar of the SSMS window, and change the title of the window, to show whatever text that I type, instead of the filename, that would be AMAZING. Then I could alt-tab and quickly see that one SSMS has HR stuff in it while another SSMS has Student Datamart stuff in it, and still another has my Student ODS in it, without having to look too closely at the file names to figure out which SSMS…

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. CREATE LOGIN/USER Windows Auth - please get the Display Name from AD and store that as a column in [msdb].[sys].[server_principals].

    CREATE LOGIN/USER for Windows Auth accounts - When running this command, please get the Display Name from AD and store that as a column in [msdb].[sys].[server_principals]. Once that is collected, it would be possible to create a report that would show real names of users. This would help with validation of accounts for business users using a standard report in SSMS. I am able to do this, but I would like to be able to empower business users to be self sufficient and have better insight into their security footprint.

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. MERGE UPDATE SET */INSERT * - implicit column resolution

    The idea is to extend the MERGE statement in a way that allows to automatically resolve column list for both UPDATE/INSERT.

    MERGE target
    
    USING source ON source.key_column = target.key_column
    WHEN MATCHED THEN UPDATE SET *
    WHEN NOT MATCHED BY TARGET THEN INSERT *;

    Here: UPDATE SET * is equivalent to UPDATE SET col1 = source.col1 [, col2 = source.col2 ...] except the columns used in ON clause.

    INSERT * is equivalent to INSERT(key_column, col1, ...) VALUES (source.key_column, source.col1, ...)

    Normally SELECT * is an antipattern. In this scenario it has potential as it allows for "automatic" schema evolution/useful also for…

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add the ability to query the default values for stored procedure parameters

    At the moment, it is virtually impossible to query default values for stored procedure parameters. Being able to do so would assist the data dictionary as well as possible data mismatches.

    2 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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Polybase CONNECTION_OPTION Retry Connection

    I use PolyBase quite often and normally the connection for the external data source works great. We do have some situations where there are just network blips when trying to query data. If you then a second later try to query again, it works fine.

    My request is, can there be implemented some way to set a Retry connection limit or something similar.

    For example, if in the previously mentioned situation set my data source to CONNECTION_OPTION="RetryConnection=5", this would allow PolyBase to then try to reconnect a total of 5 times with a delay of maybe half a second or…

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. SQL Server VS Oracle Database

    I'am starting to develop with Azure SQL. I normally use Oracle DB. Here are some exemple why I still prefer using Oracle DB:

    1) The SQL syntax in Oracle is more complete.

    1a) Using keyword
    The Using keyword isn’t implemented in SQL server. This is an essential keyword for writing concise SQL

    1b)Tuple comparison
    Tuple comparison are not available in SQL Server
    In Oracle, we can write:
    Select * FROM Customer WHERE (CustomerID, CustomerType) IN (Select CustomerID, CustomerType FROM SpecialCustomer)
    In SQL Server you must use unclear NOT EXIST keyword syntax.

    1c) Create Table As
    This is not possible to…

    1 vote

    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. In-Memory table and parallel execution throws error

    Having multiple parallel agent jobs executing and they update the same in-memory (status) table, randomly fails the jobs with the following Error:

    A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master. [SQLSTATE 42000] (Error 41317). The step failed.

    We do not use transactions when selecting or updating the in-memory table at any given time.

    Server:
    - SQL 2019
    - MEMORYOPTIMIZED TEMPDBMETADATA=ON;

    Database:
    - COMPATIBILITY_LEVEL: 150
    - Delayed Durability = Allowed
    - ADR ON
    - Allow Snapshot Isolation…

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. Missing Azure Option in Authentication dropdown

    Missing Azure Option in Authentication dropdown even in latest version 18.9

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. Missing Azure Option in Authentication dropdown

    Missing Azure Option in Authentication dropdown even in latest version 18.9

    1 vote

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 544 545
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base