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 Stack Overflow or MSDN.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. SSMS 18.0 Preview 7 - Job Properties Window ArgumentOutOfRangeException

    The IDE crashed while working with a Job Properties window.

    Application: ssms.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.ArgumentOutOfRangeException
    at System.Collections.ArrayList.get_Item(Int32)
    at Microsoft.SqlServer.Management.UI.Grid.MemDataStorage.GetRow(Int32)
    at Microsoft.SqlServer.Management.UI.Grid.MemStorageView.GetCellData(Int64, Int32)
    at Microsoft.SqlServer.Management.UI.Grid.DlgStorage.GetCell(Int64, Int32)
    at Microsoft.SqlServer.Management.UI.Grid.DlgStorage.OnCustCellGDIObjects(System.Object, Microsoft.SqlServer.Management.UI.Grid.CustomizeCellGDIObjectsEventArgs)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.GetCellGDIObjects(Microsoft.SqlServer.Management.UI.Grid.GridColumn, Int64, Int32, System.Drawing.SolidBrush ByRef, System.Drawing.SolidBrush ByRef)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.PaintOneCell(System.Drawing.Graphics, Int32, Int64, Int32, Int64, System.Drawing.Rectangle ByRef, System.Drawing.Rectangle ByRef, System.Drawing.Rectangle ByRef)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.PaintGrid(System.Drawing.Graphics)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnPaint(System.Windows.Forms.PaintEventArgs)
    at System.Windows.Forms.Control.PaintWithErrorHandling(System.Windows.Forms.PaintEventArgs, Int16)
    at System.Windows.Forms.Control.WmPaint(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)

    Faulting application name: ssms.exe, version: 2019.150.18092.0, time stamp: 0x5c772f01
    Faulting module name:…

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

    We’ll send you updates on this idea

    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. Disabled non-clustered index still shows as enabled in a SQL Table

    I created a Non Clustered Index on SQL 2017 and 2016. After testing my workload I disabled it using the GUI. But the "Disable" sign still stays and it lets me click on it repeatedly.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. sql-server-2019-ctp

    Installing sql-server-2019-ctp succeeded, but starting SQL Server Configuration Manager failed

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

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  6. SSMS bug: missing ellipsis for truncated field values (Results to Grid)

    This bug led me to think the values were different than actual ones: sometimes, when truncating values due to column width, SSMS 2017 (17.7) doesn't put ellipsis (…) in the end of the truncated value, and users are misled to think the value is not truncated.

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

    We’ll send you updates on this idea

    14 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. SSMS 18.1 SQL Agent Job Step lost focus

    SSMS 18.1 SQL Agent Job Steps

    When deleting a job step, in previous versions of SSMS, the focus would remain at the place of deletion. eg. delete step 18, the step would be removed, then all steps move up and the new step 18 would be in focus. In SSMS 18 & 18.1 the focus returns to step 1 after deletion is time consuming when modifying jobs with large number of steps.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. SSMS 18 RC1 - Double Click On Job Step Parameter Is Not Valid

    In the job properties window if I click on the step of a job to view the contents I get this error:

    ```

    Parameter is not valid. (System.Drawing)


    Program Location:

    at System.Drawing.Graphics.GetHdc()
    at System.Windows.Forms.Internal.WindowsGraphics.FromGraphics(Graphics g, ApplyGraphicsProperties properties)
    at System.Windows.Forms.WindowsGraphicsWrapper..ctor(IDeviceContext idc, TextFormatFlags flags)
    at System.Windows.Forms.VisualStyles.VisualStyleRenderer.DrawBackground(IDeviceContext dc, Rectangle bounds, IntPtr hWnd)
    at Microsoft.SqlServer.Management.UI.Grid.GridConstants.GetStdBitmap(Bitmap bmp, ButtonState state)
    at Microsoft.SqlServer.Management.UI.Grid.GridConstants.getDisabledCheckBoxBitmap()
    at Microsoft.SqlServer.Management.UI.Grid.GridCheckBoxColumn..ctor(GridColumnInfo ci, Int32 nWidthInPixels, Int32 colIndex)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.AllocateCheckBoxColumn(GridColumnInfo ci, Int32 nWidthInPixels, Int32 colIndex)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.AllocateColumn(Int32 colType, GridColumnInfo ci, Int32 nWidthInPixels, Int32 colIndex)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.InsertColumnInternal(Int32 nIndex, GridColumnInfo ci)
    at Microsoft.SqlServer.Management.UI.Grid.DlgGridControl.InsertColumnInternal(Int32 nIndex, GridColumnInfo ci)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.AddColumnInternal(GridColumnInfo ci)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.AddColumn(GridColumnInfo ci)
    at Microsoft.DataTransformationServices.DTSExecUI.Controls.DataSourcesCtrl.InitGrid()
    at Microsoft.DataTransformationServices.DTSExecUI.Controls.DataSourcesCtrl..ctor(IDTSExecViewManager

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

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Write-SqlTableData SqlBulkCopy times out even with the Timeout parameter specified as 0

    Inside the SqlServer module (21.1.18102) the cmdlet Write-SqlTableData has a -Timeout parameter that I set to 0 and when running a decent amount of data to a table, you get an error below which means to me that the Timeout parameter is not honored. When I code my own SqlBulkCopy object and set the BulkCopyTimeout = 0 it does not timeout on the same import.

    Write-SqlTableData : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the
    server is not responding.
    The statement has been terminated.
    At C:\dba\bin\RunGRM.ps1:69 char:3
    + Write-SqlTableData -ServerInstance $ServerInstance -Database ... …

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. ssms 18.x not getting launched

    HI Team, I have installed SSMS 18.x when installed and launched it worked fine. After closing the app few time, when I am trying to launch it again its getting started and the window disappears even before launching the app. I could not find the app in the hidden tabs(Alt+Tab) even. I have tried to reinstall the app, even then this is the case. So raising this.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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 →
  12. cannot start 18 manager

    MS SQL Server Management Studio Release 18.0 can only start once after installation. The next time you start, you only see the logo for a very short time and nothing happens anymore.
    The program must first be uninstalled. After a new installation, it starts again only once.
    I'll test the SSMS version 17.9 next week
    It's a new Windows Server 2019 with SQL Server 2017.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. Cannot disable intellisense

    Even with Intellisense disabled, intellisense is enabled when opening a new query window.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. SSMS: Generate Scripts wizard does not respect that "match source" setting

    Generate Scripts wizard does not respect that "match source" setting

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

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. SSMS 18.0 doesn't script CREATE EXTERNAL LIBRARY properly

    I've tried to script all objects in a database using Tasks -> Generate scripts. The result was missing content and of course error 39044 during execution of the script on another instance:

    CREATE EXTERNAL LIBRARY [ml]
    FROM (content = '')
    WITH (LANGUAGE = 'R')
    GO

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. ssms - index was out of range error on Execute Stored Procedure + Enter

    In SSMS 17.9.1, there is an irritating bug. Right-clicking a stored procedure (one which has no parameters) in Object Explorer and selecting "Execute Stored Procedure..." and then hitting the "Enter" key on your keyboard generates an error message: "Index was out of range. Must be non-negative and less than the size of the collection.
    Parameter name: index (mscorlib)". If you mouse-click the "OK" button instead of hitting the "Enter" key, it works fine, as it always has.

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  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 18

    When double clicking on an sql file, a new instance of SSMS 18 will start up, but the file never opens. This never happened when I was using SSMS 17.8. I'm running on Windows 10 OS.

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

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. Batch mode window aggregate arithmetic overflow bug

    The following query performs a windowed SUM over a columnstore table with 1500 total rows, each of which has the value 0 or 1, and it overflows the INT data type. This appears to be a bug in the batch mode window aggregate operator.

    SELECT a, p, s, v, m, n,

    SUM(CASE WHEN n IS NULL THEN 0 ELSE 1 END)
    
    OVER (PARTITION BY s, v, a ORDER BY p) AS lastNonNullPartition

    FROM (

    SELECT a, p, s, v, m, n,
    
    RANK() OVER (PARTITION BY v, s, a, p ORDER BY m) AS rank
    FROM #t /* A columnstore table
    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. UTF-8 in SQL 2019: Binary UTF-8 Collations are missing

    In SQL Server 2019, CPT 2 there are no binary versions of the new UTF-8 Collations. Why not? There does not seem to be any good reason for this omission.

    1) It doesn't matter that the Code Page is the same for all UTF-8 Collations (Code Page = 65001): the same is true for all Unicode-only Collations (Code Page = 0) and there are multiples of those (not sure why though; it would make more sense to have a single "Common" / "Invariant" for "UnicodeOnlyBIN2" and "UTF8BIN2").

    2) It doesn't matter that binary Collations don't truly support Supplementary…

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

    We’ll send you updates on this idea

    8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base