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. 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!

    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 →
    • 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

      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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      • MSSMS v17.9 Script view as - Alter to, fails on Azure Data Warehouse

        When right-clicking existing view and choosing Script View As -> Alter to, it produces error message.

        Running on Azure Data Warehouse.

        Script View as -> Create To, works fine

        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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • Typo error in Error Message

          Hi,

          I was trying to restore Azure DB using 'Import Data-Tier Application'. In this wizard when I gave the path of .bacpac file, and press 'Next' it throws 1 error prompt. Where I found 1 Typo error in that error message.

          Actual error message is 'Count not load schema model from package. (Microsoft.SqlServer.Dac) '. I think the message should be 'Could not load schema model from package. (Microsoft.SqlServer.Dac) '.

          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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
          • Database Diagram

            hello this version should have database diagrams, this tool is very util

            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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • Custom access to dimension data with AllowedSet {} does not work as expected

              When setting the AllowedSet for a dimension to {}, the data set accessible through the role is larger than when the AllowedSet contains a single member.

              For example, add two roles to Lesson 10 of the SSAS Multidimensional Tutorial:
              1) "Test Role 1" with Read access to the cube "Analysis Services Tutorial" and the Allowed member set for the City attribute of the Customer database dimension set to {}. Enable Visual Totals.
              2) "Test Role 2" with Read access to the cube "Analysis Services Tutorial" and the Allowed member set for the City attribute of the Customer database dimension set…

              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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
              • check for updates

                Allow admins to disable SSMS update checks via per-machine registry key or by command-line at time of install.

                At present, it is only per-user at HKCU\Software\Microsoft\SQL Server Management Studio\14.0\UpdateChecker" Enabled=False (REG_SZ), but Dev users don't run user policy.

                Please do this for v17 and the upcoming v18.

                2 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  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
                • Performance Improvement for Personalization Extensions in Analysis Services

                  Analysis Services has a feature called personalization extensions which allows for a cube to have characteristics that are defined at the time the cube is used. For example, the user can access sets and members and kpi's that are specially defined for them alone.

                  Unfortunately the API that supports personalization is slow. For example, if there are several hundred custom sets or members that are needed, then it will take a long time for them to be created during the initialization of the cube session. Each new set or member involves running a server-side AdomdCommand, and things get exponentially slower…

                  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 →
                  • SQL Server 2016: In-Memory table creation during parallel execution throws error

                    Hello, we have a peculiar issue with the in-memory tables alter mechanism. During parallel installation of similar databases for application upgrade, a particular in-memory table is being updated. Though the name is same for all the databases, the in-memory table is specific to each database.

                    However during application upgrade that is failing with the below 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

                    Refer to this link for more details on this -

                    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/253bb120-4d34-41b7-98ee-959af7e2e6c6/sql-server-2016-alter-inmemory-table-throwing-error-during-parallel-execution?forum=sqldatabaseengine

                    This looks…

                    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                    • NULL values in UTF8 collations causes SSMS to hang or produce error messages

                      This appears to be the same issue as https://feedback.azure.com/forums/908035-sql-server/suggestions/35606671-utf-8-in-sql-2019-an-error-occurred-while-executi
                      I'm providing some information in case it can be helpful. I have not been able to nail it entirely, but it appears that this go wrong when there are NULL values in the mix.

                      Attached is a script to build the Northwind database with a UTF 8 collation.

                      This query:

                      SELECT TOP 3 * FROM Orders

                      causes the query to never complete, and from this point it is not possible to close SSMS in any civilsed way. (I need to kill it from Process Explorer.) I can still use other windows…

                      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

                        1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                      • How about supporting SSDT database projects into SSMS? This is to avoid working on both "Visual studio" and "Management Studio".

                        How about supporting SSDT database projects into SSMS? This is to avoid working on both "Visual studio" and "Management Studio". Also integrate SSMS with TFS as Source Control? For DB development, SSMS is the preferred choice over Visual Studio.

                        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 →
                        • database Diagrams

                          Hello, maybe would be good idea id MSSMS 2018 also provide Database Diagrams like the MSSMS versions before it.

                          2 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 →
                          • Missing error message when trying to create an indexed view on a computed column based on an imprecise type

                            When running the script below, the sole error message in SSMS is:

                            Msg 0, Level 11, State 0, Line 28
                            A severe error occurred on the current command. The results, if any, should be discarded.

                            Level 11 indicates that error is in the client API.

                            When you run the script in SQLCMD, there is no error message at all, but the index on the view is not created.

                            It does not seem that this view is indexable, since the computed colunm is based on a imprecise column, nevermind that the column is computed. So the issue appears to be that…

                            3 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 →
                            • Make Performance Dashboard Work With Azure SQL DB

                              The Performance Dashboard report in SSMS 17 and above should be made to work against Azure SQL DB's. It currently works against all on-prem servers back to 2008 (maybe further) and is a great help. It would be just as helpful to be able to run it against Azure SQL databases (DaaS).

                              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 →
                              • SSRS -- ReadOnly Columns

                                In our current project, our users are wanting to make few columns read only. And this capability doesn't exist ssrs 2016.

                                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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                • predictive scrolling in parameter lists with multi values, to accelerate selection

                                  Predictive scrolling in parameter lists with multi values, to accelerate selections for my users. When they run the reports, and click the 'employee' parameter (for example), we have a large list that is displayed, and they have to click the scroll to get down the list. They want to click the letter on the keyboard and jump to that name in the employee list (like clicking V on the keyboard, jumps down to names starting with V). This function happens if I'm not using a parameter with multi values option... but if I am, where the little boxes are next…

                                  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 →
                                  • Cannot open Maintenance Plan steps in SSMS 18 Preview 4

                                    Maintenance plans were created with earlier versions of SSMS (17.x and lower) and trying to open any step of the maintenance plan results in the follow error message,

                                    "The task with the name "AG Replica DB Differential Backups T-SQL Statement Task" and the creation name "Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceTSQLExecuteTask, Microsoft.SqlServer.MaintenancePlanTasks, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" is not registered for use on this computer.
                                    "

                                    2 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 →
                                    • SSMS 17.9 Backup not supported error not shown

                                      When connecting to an Availability group through the listener E.G AG-01 and the availability group has the backup preference "Prefer Secondary" selected SSMS 17.9 fails to display the error message "Backup type is not supported....". The yellow boxed area where the error message should reside appears, however, no text is shown within it.

                                      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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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.

                                        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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • latest version

                                          Build an RSS feed in docs.microsoft.com that reports the latest version of SQL Server, so we can programmatically compare if our company version is current and compliant.

                                          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 →
                                          ← Previous 1 3 4 5 423 424
                                          • Don't see your idea?

                                          SQL Server

                                          Feedback and Knowledge Base