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. Microsoft.AnalysisServices.Deployment.exe not in ssms 2018

    It appears that the deployment utility for SSAS is not included in the latest release of SSMS 18. Are there plans to include it or is this being ported over to ssdt?

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSMS 18.1

    SSMS 18.1 has a bug in restoring databases from UNC folders

    Repro:
    - Object Exploere right click restore database
    - Source: Chose Device and Press ...
    - Press Add
    - Enter a UNC path into the field Backup File Location and press Enter

    In the older versions (17.x and older) the dialog showed the content of the UNC folder. Now nothing happen.

    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 →
  3. 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 →
  4. 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 →
  5. SQL Server Management Studio: Restore Database from Device HANGS on clicking "..."

    When I wish to restore a database from a *.back file, I go into SSMS, select Tasks->Restore Database, and on the dialog, I click the "From Device" radio button, and then click the "..." button to browse to the *.bak file I wish to restore. This then HANGS for MINUTES before the "select a backup device" dialog appears and allows me to drill down and select the backup file.

    I have literally HUNDREDS and HUNDREDS (maybe THOUSANDS) of *.bak files on a big data drive with lots of folders. It seems like it might be trying to iterate over all…

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

    We’ll send you updates on this idea

    30 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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 →
  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.get_DisabledCheckBoxBitmap()
    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…

    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 "UnicodeOnly_BIN2" and "UTF8_BIN2").

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

    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