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. Set-SqlColumnEncryption : Object reference not set to an instance of an object

    Hi,

    I am running following on one server (windows 2016) with SQL Server 2016 and it works fine, same commend on another server (windows 2016) but SQL 2017 gives the error as below, Column Master Key and Column Encryption Key does exist on both servers, I have imported latest (SqlServer 21.1.18080) module from powershell gallery, please help

    Also, I can encrypt the column using SSMS wizard on same server where I can't using powershell script in elevated mode...if that helps...

    PS CODE:

    Import-Module SqlServer

    $sqlConnectionString = "Data Source=server1\dw;Initial Catalog=DW;Integrated Security=True;MultipleActiveResultSets=False;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;Packet Size=4096;Application Name=`"Microsoft SQL Server Management Studio`""

    $smoDatabase = Get-SqlDatabase…

    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 →
    • SSRS HA: Updated Subscription Schedule cannot Synch up

      SSRS using SQL Server Always On availability groups as the Reporting Services databases, if Subscription schedule is updated, after failover and restart, the schedule change cannot be synched up between 2 replicas.

      Details: (Please refer to attachment)
      1. Create a Subscription when DB1 is primary, the scheduled time is 7AM
      2. Failover to DB2 and restart SSRS, same job created on DB2.
      3. Modified Schedule to 10AM in Web portal url.
      4. Failover to DB1 and restart SSRS, checked in DB1 Agent Job, the schedule was not updated (still 7AM).

      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 →
      • 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 →
        • SSMS displays the wrong version of certificate algorithm

          SSMS displays the wrong version of certificate algorithm.

          When using SSL certificates, SSMS shows the wrong version (SHA1) of the certificate as the one used was SHA3.

          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 →
          • SQL Server 2017 Installation: selection of Features should disallow the adding standalone R and Python in an Instance containg R and Python

            Specifying both options causes problems with the install and later on if they both a standalone version and an instance version are on the same machine. This should also be noted in the release notes for SQL Server 2017

            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  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
            • SSMS在Alt+x执行查询后会重置输入法状态

              SSMS 17.9
              Windows 10

              当我的输入法状态为输入中文时,Alt+x执行查询会使输入法切换为英文输入状态

              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 →
              • Unhandled Exception in unattended SQL Server 2017 Express setup.

                Hi, i get an error when running the online Installer of SQL Server 2017 Express on Windows 10 1809 with the parameter "/?". The .NET Framework version is 461814. On Windows 10 1803 with .NET version 461808 it works fine.

                Exception is:
                Unhandled Exception: System.ArgumentNullException: String reference not set to an instance of a String.
                at System.Reflection.RuntimeAssembly.GetResource(RuntimeAssembly assembly, String resourceName, UInt64& length, StackCrawlMarkHandle stackMark, Boolean skipSecurityCheck)
                at System.Reflection.RuntimeAssembly.GetManifestResourceStream(String name, StackCrawlMark& stackMark, Boolean skipSecurityCheck)
                at System.Reflection.RuntimeAssembly.GetManifestResourceStream(String name)
                at Microsoft.Sql.Installer.Engine.ManifestCache.GetManifestFromResource(String resourceName)
                at Microsoft.Sql.Installer.Engine.ManifestCache.InitializeDownloadManifest(String edition)
                at Microsoft.Sql.Installer.Engine.ManifestCache.Initialize(String edition, Boolean skipBootstrapInitialization)
                at Microsoft.Sql.Installer.UI.SSEIBusinessLogic.Initialize(String edition)
                at Microsoft.Sql.Installer.UI.App.AppInitialize(String[] args, String edition)
                at Microsoft.Sql.Installer.UI.App.App_OnStartup(Object sender, StartupEventArgs e) …

                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 →
                • SSIS - Instead of transferring the data between compatible SQL servers in rows, transfer the entire data of a table in a single chunk.

                  SSIS - Instead of transferring the data in rows between compatible SQL servers , transfer the entire data of a table in a single chunk. This would play out similar to the biggest benefit that FoxPro offered, the ability to copy and paste a data table file between two devices. Since the table in SQL is stored in an MDF file, possibly the most seamless way to accomplish this would be to set every table of a database to have its own MDF and LDF file. I know, it sounds like taking a huge step backward. Not really. Take a…

                  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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                  • Deadlock Error when Cache Expiration - SSRS 2017

                    I hope there is hotfix on this issue as current workaround is that I need to setup second timing for cache expiration. First cache expiration always got deadlock problem. luckily, the second cache expiration will not have this issue. I'm curious why this happened

                    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 →
                    • Microsoft OST to PST Converter Free Software - Download

                      Use Outlook OST recovery tool to successfully recover inaccessible OST files in offline mode and convert into Outlook PST. The OST to PST Converter is specifically designed software with a single aim that is to recover the damaged and ruined OST database. It can work with all the MS Outlook version from 97, 98, 2000, 2002, and 2003, up to 2019 without any hassle. Before the actual conversion of OST file to Outlook PST file, it shows the preview of the recovered mailbox in a safe manner and converts the whole data into multiple file formats such as PST, EML,…

                      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  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
                      • SQL Server Compact 3.5 SP2 Hotfix for Denali

                        Hi,

                        is there any way to access the old CU6 or CU7 hotfixes for SP2?
                        I have more then 25 Mobile 6.5 Scan Devices and need to move my SQL 2012 to a new machine. Without the hotfix I can't setup replication with 2012.

                        Any help appreciated

                        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  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
                        • Open Properties in SQL Server Agent LogFileViewer

                          In SQL Server Management Studio, in the SQL Server Agent Log File Viewer (View History button) it would be nice to right click on Jobs and Steps to open it's properties or to start the job at a specific step.

                          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 →
                          • Add support for static data masking in Transact SQL

                            Static "Masking" should be a property of a column and should be defined in meta data (create table and alter column).

                            In large organizations, databases may have hundred of tables and thousand of columns. Manually defines static data masking is not praticable.

                            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 Tuning Advisor really needs to improve its error reporting and user feedback.

                              Hi,

                              Database Tuning Advisor really needs to improve on its error reporting. I have gotten it to repeatedly fail today with the error "Tuning process exited unexpectedly.(DTAEngine)". No further information is to be found. I can see many online posts from people saying different reasons it may happen, for example one person says that they can run successfully from a 100MB trc file, but not a 200MB trace file. The trace file I'm using is about 3GB! The various ErrorDumps directories on my machine are empty.

                              Perhaps there should also be more information given by dta about what limitations 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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                              • Schema Changes History report slow because of telemetry_xevents ALTER security logging

                                Hi,

                                When we run the Schema Changes History built-in report in SSMS against SQL Server 2017 instances it takes a really long time (like 10 mins) to return the report. This is apparently because of numerous ALTER security events being recorded for the telemetry_xevents extended events session that now runs by default on SQL Server. It appears that 14 events are recorded every minute. This does not seem a reasonable update to happen every single minute so I'm reporting this as a bug.

                                This doesn't happen when the report is opened from a database node obviously because Xevents are server-level,…

                                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 →
                                • Incorrect syntax error highlighting in SSMS when field added

                                  When you add a field to a table (I have only used temp tables for this so far), the new field shows a syntax error (this is only underlined in the code, not when you actually run it). For example:
                                  CREATE TABLE #tempTable(originalField nvarchar(max))
                                  ALTER TABLE #tempTable ADD newField nvarchar(max)

                                  SELECT originalField FROM #tempTable --originalField will not be underlined
                                  SELECT newField FROM #tempTable --newField will be underlined as a syntax error

                                  This is a pain as I constantly see the red (the underline and in the scroll bar) and go to fix it and realize its not actually an error.

                                  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 →
                                  • parameter that confirms the execution of a command without the WHERE condition

                                    when an UPDATE or DELETE command is executed without the WHERE condition, SQL displays a confirmation message: DOES IT WISH TO RUN THE COMMAND WITHOUT THE WHERE CONDITION? S / N

                                    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                    • kill state generated by hotfix KB3213683

                                      SET QUOTED_IDENTIFIER ON
                                      GO

                                      --drop table [X]

                                      CREATE TABLE [X] (
                                      [a] int,
                                      [c] AS 1 ,
                                      [b] AS 1 PERSISTED
                                      )
                                      GO

                                      SET QUOTED_IDENTIFIER OFF

                                      SELECT * FROM [X]
                                      OPTION(QUERYTRACEON 176)

                                      drop table [X]

                                      /*
                                      TF 176 is related to KB 3213683

                                      this hotfix is to fix a problem related with index rebuild,

                                      but when you have a table with
                                      1 - any data type column
                                      2 - persisted calculated column
                                      3 - NOT persisted calculated column (any data type)

                                      SQL DUMP a error in log and session closes

                                      SQL descriptions:
                                      Microsoft SQL Server Enterprise: Core-based Licensing (64-bit)
                                      13.0.5264.1 …

                                      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

                                        2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Invalid T-SQL REPLACE function result for CH, Ch using czech/slovak non-binary collations

                                        The REPLACE function returns invalid result when using Czech_CI_AI (and similar + Slovak ones) collations for the

                                        SELECT
                                        REPLACE(N'Chachach' COLLATE Latin1_General_BIN, N'ጠ', N'#'),
                                        REPLACE(N'Chachach' COLLATE Czech_CI_AI, N'ጠ', N'#')

                                        The result:

                                        Chachach #hachach

                                        The starting C(h) character (regardless if in upper/lower case) is matched with the character N'ጠ' (the unicode 0x1320).

                                        In Czech CH is considered as single letter even though coded as 4 bytes, sorting is different for C and CH.

                                        This REPLACE function behaviour seems to be related to the specific czech collation(s), not to SQL SERVER version. I have tested this on

                                        Microsoft SQL Server 2017 (RTM-GDR) (KB4293803)…

                                        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 →
                                        • Compatibility between SQL Server Management Studio 2018 (SSMS 2018) and Visual Studio 2019 Database Solution File and Database Project File

                                          Compatibility between SQL Server Management Studio 2018 (SSMS 2018) and Visual Studio 2019 Database Solution File and Database Project File is missing.

                                          Could we just open Database project made by Visual Studio from SQL Server Management Studio 2018?

                                          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 445 446
                                          • Don't see your idea?

                                          SQL Server

                                          Feedback and Knowledge Base