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. Have SSMS respect a Resource Lock

    When I set a lock on the Resource Group where my Azure SQL Server and DB reside - I can still delete the DB using SQL Server Management Studio This action should at least generate a prompt in SSMS indicating a Resource Lock has been set

    5 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

      SSMS doesn’t know anything about Azure resource groups at this time. I suspect the lock only applies to the ARM REST API. Perhaps this suggestion should be copied over to Azure SQL Database; they could check for this lock on the server side and fail the TSQL query.

    • Please discontinue the use of italics in the Filter textbox in DocumentDB DataExplorer

      Extremely poor UI design and UX - please implement plain fixed-width font to assist with SQL coding

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
      • Can we make MySQL and SQL using local time zone like China Standard Time?

        Can we make MySQL and SQL using local time zone like China Standard Time?

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
        • THIS IS OUR IDEA AT THE UNIVERSITY OF WESTERN AUSTRALIA AND HARVARD BY A POST-DOCTORAL STUDENT WHO HAS ALWAYS WANTED MORE... I STILL DO.

          Information Systems software coding for a proprietry Learning Management System (LMS) with complete integration and stringent Active Directory hybrid CISCO Systems/IEEE port map stack to route The University of Western Australia and Harvard University from a hardware SQL Server with RAID-configured Virtual SQL Servers in the cloud-hybrid Multipoint-protocol virtualisation of a composite Internet of Things (IoT) to relay packet signals in real-time with Hbb Broadcasting frequency signals routed through ezy-proxies and our respective Universities for Institution-wide, minimal labour hour information systems administration to maximise positive outcomes of student, faculty, library and student administration for protocol pedagogy and intranet-directed Strategic Management…

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
          • Unable to deploy SSIS packages from Visual Studio 2017 (15.8.0)

            The latest version of Visual Studio 2017 (15.8.0) appears to have introduced a bug preventing deployment of SSIS project files.

            When attempting to connect to a server the deployment wizard returns the following error:

            TITLE: SQL Server Integration Services
            ------------------------------

            Could not load file or assembly 'Microsoft.SqlServer.Management.IntegrationServicesEnum, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

            ------------------------------
            ADDITIONAL INFORMATION:

            The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

            ------------------------------
            BUTTONS:

            OK
            ------------------------------

            295 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              under review  ·  52 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            • Porting SMO Library to .NET Core

              SQL Server has been ported to Linux for over a year now and it is time the complete SMO library (or what can be) is ported over to cross-platform as well.

              Only 9 or so core files have been ported over to .NET Core and this allowed the sqlserver module to port over a small set of cmdlets to PS Core. This does not work for other modules like dbatools that use a wider berth of the library.

              There are plenty of other modules in PowerShell (and applications too) that would like to provide cross-platform support for managing SQL Server…

              69 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                planned  ·  2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
              • Run DBCC CHECKDB WITH PHYSICAL_ONLY automatically in the background

                When RAID controllers are idle, they automatically check the storage to make sure it's still okay. Why not SQL Server too?

                Some of the pieces are there – for example, SQL Server already has the ability to watch for idle CPU times and run Agent jobs when it’s bored. For starters, that’d probably be good enough to save a lot of small businesses from heartache. For the databases over, say, 100GB, it’d be really awesome to have resumable physical_only corruption checking – tracking which pages have been checked (just like how the differential bitmap tracks page changes), with page activity…

                290 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  14 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                • Restore CTRL-D shortcut for ResultsToGrid in SSMS

                  In SSMS 18 Preview 4, the default binding have changed to Edit.Duplicate lines, quoting https://feedback.azure.com/forums/908035-sql-server/suggestions/32896594 as a the motivation.

                  CTRL-D has been bound to ResultsToGrid, for almost 20 twenty years (that is since Query Analzyer came out in SQL 7.) That is engraved in many people's minds.

                  Yes, I can change the key binding, but so can people who prefer to use it to duplicate lines.

                  Please restore the original default. It does not serve the community to change existing bindings.

                  22 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

                    Note: this is a behavior that is only observed in SSMS 18.0 Preview 4.

                    It turned out that the migration to the new VS2017 Shell in SSMS 18.0 ended up changing the binding for the CTRL+D, which accidentally was a request from a few other users.

                    Due to popular demand (and also to preserve the old behavior), I’m going to bring back CTRL+D and have it bound to the ResultToGrid in the Query Editor.

                    I’m going to bind the “Edit.Duplicate” to CTRL-K, CTRL+V, which is consistent with the current VS2017 behavior.

                  • Trigger symbol on tables and views in object explorer

                    In SSMS Object Explorer, you can find DML triggers by expanding the table (or view) and then expanding the Triggers node. That is fine.
                    However, it would be great to have a visual indication, as a kind of warning, on the table or view symbol. This symbol should only appear on tables and views that have one or more active triggers
                    My suggestion for the symbol would be a lightning bolt (similar to the icon used for the actual triggers). Preferably in red.

                    25 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                    • EXCEPTION_ACCESS_VIOLATION during plan compilation with incremental statistics (SQL17 CU11)

                      If a query uses one or more partitioned tables that use incremental statistics and whose partition function has been modified using the MERGE and SPLIT partition commands, a connection-terminating access violation can occur when the incremental statistics need to be automatically updated during plan compilation.

                      The attached script reliably reproduces the error on multiple SQL Server 2017 database servers we've tried thus far, including a server running CU11. We've also attached dump files from both a real production occurrence of this error and a testing occurrence of the error using our repro script.

                      SQL Server 2017 CU8 contained a fix…

                      7 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                      • Change from normal Table to Temporal Table doesn't work with dacpac and sqlpackage.exe

                        Using sqlpackage.exe 15.0.4108.1

                        The generated Change Script from changing a normal Table to a Temporal Tables fails with the following Error:
                        Msg 515, Level 16, State 2, Line 44
                        Cannot insert the value NULL into column 'SysEnd', table 'analyse.tmp_ms_xx_Vergleich'; column does not allow nulls. INSERT fails.

                        See Attached Example:
                        -#1 Orignal Table
                        -#2 Changed Table in Dacpac
                        -#3 Generated not working Query
                        -#4 Correct Qeury in this Case

                        6 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                        • SQL Server Management Studio - search interface bug, crashing SSMS

                          There is a bug in SQL Server Management Studio (17.9 and all below) that force the application to crash/restart. In order to reproduce follow the steps below:

                          1. Select database from the object explorer
                          2. Press F7 to open Object Explorer Details window and perform a search to object
                          3. After the search completes, select the object, right click on it and then click "synchronized" from the menu.
                          4. Then click the `BACK` button several times (fast). You will get the following error:

                          "There is already a commandd handler for the menu command 'guid goes here: 189."

                          After several clicks…

                          13 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          • Restore a table from a backup

                            Hi Msft team!
                            I'm writing to reccomending a new feature that will help us a lot! Every time that we have data issues (truncate or DML by accident) we need to restore the entire database or filegroup and that takes a lot of time! it will be awesome if you can add the posibility to restore a table from a backup or restore to a point in time directly from SSMS instead off the whole process.
                            I hope this helps!
                            Thank you!

                            5 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                              • SQL Server 2019 Ukrainian_100_CI_AS_SC_UTF8 with "ьЬ" simmbol ( char 252 and 220 in Ukrainian codepage)

                                The last two lines will not return anything. For all other letters of the Cyrillic alphabet, this is not the case.
                                This is an old discrepancy in the Ukrainian_100_CI_AS encoding and similar.
                                Perhaps in UTF8 it is worth changing the behavior as in SQL_Ukrainian_CP1251_CI_AS?


                                select serverproperty('Collation')
                                exec sp_helpsort

                                create table #x (
                                a varchar(10) collate SQL_Ukrainian_CP1251_CI_AS
                                , b varchar(10) collate Ukrainian_100_CI_AS_SC_UTF8
                                , c varchar(10) collate Ukrainian_100_CI_AS
                                )

                                declare @x varchar(2) = char(252) + char(252) --ьь
                                declare @y varchar(2) = char(252) + char(220) --ьЬ

                                select @x, @y

                                insert into #x select 'ьЬ', 'ьЬ', 'ьЬ'
                                select * from #x where a like…

                                7 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                • Unable to see Database Diagram on SSMS 2017

                                  Hi

                                  I am trying to use the Database diagram option which is supposed to be within the folder of the database, but nothing is there, i can only view System tables,FilesTables,GraphTables and then my tables.

                                  4 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add SSIS to the SQL Server Docker Image

                                    I work for a large bank which it trying to move hundreds of SSIS packages into GitLab pipelines. This task would happen faster an easier with SSIS on the MS SQL Server Docker image.

                                    25 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      under review  ·  1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Cardinality estimator expects rows to be filtered in OUTER JOIN when dimension table has higher cardinality than fact

                                      Executing a query with an OUTER JOIN can cause the cardinality estimator to expect rows being filtered out. This should never be the case if we're doing an OUTER JOIN and can result in performance issues as the row set and memory needed for downstream operators is underestimated.

                                      Attached is a reproduction script and some sample data. A few additional observations:
                                      - This seems to happen when the dimension has a higher cardinality than the fact table. Perhaps not the main use case, but we have financials where codes may be added/removed over time, while the dimension table will contain…

                                      6 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                      • dont remove debugging from ssms 18.0

                                        what is ssms:

                                        SSMS is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

                                        --> build queries and scripts

                                        if you remove debugging from ssms --> https://cloudblogs.microsoft.com/sqlserver/2018/10/03/ssms-18-0-public-preview-released/

                                        ssms will be degraded to an simple editor with some nice helpers to write sql but not an integrated enveronment to write scripts and common database objects.

                                        every developer will write good and working code,…

                                        4 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                        • -Database parameter on Invoke-SqlCmd powershell cmdlet should accept the output from Get-SqlDatabase cmdlet

                                          Following on from a conversation on https://www.powershellgallery.com/packages/Sqlserver/21.0.17279
                                          The -Database parameter on the Invoke-SqlCmd cmdlet takes a [string] as its input, but ideally should be able to cope with receiving the output object from the Get-SqlDatabase cmdlet.
                                          As the -Instance parameter does successfully take the output of the Get-SqlInstance cmdlet, I assume this is a bug.
                                          Issue can be reproduced like so:

                                          $SQLCred = Get-Credential -UserName "dbUser"

                                          $instance = Get-SqlInstance 192.168.1.100 -Cred $SQLCred #Works fine

                                          $db = Get-SqlDatabase -Name "test_db" -ServerInstance $instance #Works fine

                                          $results = Invoke-SqlCmd -Database $db -ServerInstance $Instance -Query "Select column FROM view" -Cred $SqlCred # Throws that…

                                          8 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 423 424
                                          • Don't see your idea?

                                          SQL Server

                                          Feedback and Knowledge Base