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. 'Windows API call "RegGetValueW"' error when displaying version in SQLLocalDB Utility 2016 and newer

    When using the "v" switch for the SQLLOCALDB command-line utility, it can only display versions 2012 and 2014. Starting with SQL Server 2016, the utility can no longer display installed versions of SQL Server Express LocalDB.

    In a command prompt, if I run the following:

    C:>sqllocaldb v

    It returns the following (and I have versions 2012, 2014, 2016, and 2017 installed, running on Windows 10 Home Edition):

    Microsoft SQL Server 2012 (11.0.7462.6)
    Microsoft SQL Server 2014 (12.0.5214.6)
    Windows API call "RegGetValueW" returned error code: 0.

    The SQL Server 2017 version of SQLLOCALDB.EXE is being used, as indicated by the first…

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

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. Bring Back TFS and Git in SSMS

    According to this post: https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/ these features were removed "because they didn't fit in the overall experience" for SSMS. This seems like an incredibly short-sighted decision for your user base. Many SQL developers use SSMS specifically because it is lightweight and does not require the massive baggage and learning curve of the full VS. That doesn't mean we don't need source control or task tracking in our process. Removing functionality that integrates two Microsoft products seems like a massive step backward. The suggestion to "work around" this poor decision by manually editing a definition file comes across as particularly condescending,…

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

    We’ll send you updates on this idea

    23 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. CDW from 2016 to 2017 ends with "Property HasMemoryOptimizedObjects is not available for Database"

    Hi
    I'm trying to copy a couple of databases from a SQL2016 to SQL2017 using the Copy Database Wizard.
    I'm using SQL Management Object Method in SSMS 17.3
    SSIS Proxy account is sysadmin on both instances and local admin i Windows on both servers.
    When running the job I get the error "Property HasMemoryOptimizedObjects is not available for Database '[DATABASENAME]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
    The databases has no Memory Optimization configured.

    If I try to use detach/attache methods I can't select any of the databases witch…

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

    We’ll send you updates on this idea

    21 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. sql server on Linux reports 100% cpu when using RING_BUFFER_SCHEDULER_MONITOR to monitor

    RINGBUFFERSCHEDULER_MONITOR - reports that sql server uses 100% cpu but that is not true.

    e.g.

    <Record id="17239" type="RINGBUFFERSCHEDULER_MONITOR" time="4619440182">
    <SchedulerMonitorEvent>

    &lt;SystemHealth&gt;
    
    &lt;ProcessUtilization&gt;100&lt;/ProcessUtilization&gt;
    &lt;SystemIdle&gt;0&lt;/SystemIdle&gt;
    &lt;UserModeTime&gt;0&lt;/UserModeTime&gt;
    &lt;KernelModeTime&gt;0&lt;/KernelModeTime&gt;
    &lt;PageFaults&gt;0&lt;/PageFaults&gt;
    &lt;WorkingSetDelta&gt;0&lt;/WorkingSetDelta&gt;
    &lt;MemoryUtilization&gt;100&lt;/MemoryUtilization&gt;
    &lt;/SystemHealth&gt;

    </SchedulerMonitorEvent>
    </Record>

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. getting issue while using SSRS 2017 counters using performance tools

    Hi , I need to monitor SSRS 2017 counter using performance monitor tools. but i am not able see any counter related to SSRS 2017 in performance monitor. I already installed SSRS 2k17 and configured properly. I raised this issue on MS forum but it looks like it is not supported on sql server 2k17 . Please add respective perf counter

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Remove or make optional the $ShardName column for sp_execute_remote

    This will enhance portability between SQL Server and Azure SQL Database. It will also make the output look like sp_executesql. Otherwise, when doing cross-database queries, we cannot use the following logic:

    IF @@VERSION LIKE '%Azure%'
    BEGIN

    INSERT INTO myTable
    
    EXEC sp_execute_remote @stmt

    END
    ELSE
    BEGIN

    INSERT INTO myTable
    
    EXEC sp_executesql @stmt

    END

    Instead the output of spexecuteremote has to be copied into a temporary table variable, which impacts performance, just to strip away the $ShardName field.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Please bring back Swith to Table Preview for editing partitions in Tabular Models in Visual Studio 2017.

    For those of us former Excel gurus turned SSAS Tabular Model developers, who lack the background in writing SQL queries the Table Preview view has always been helpful in defining queries for individual tables and partitions. This feature has been inexplicably Greyed Out in the 2017 version of Visual Studio. The option and capability still exists in Visual Studio 2015. Please add this capability in Visual Studio 2017 as well.

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

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SQL Server won't install on Linux Ubuntu 18.04 due to Openssl version issue

    Doing an Ubuntu OS upgrade to VERSION="18.04 LTS (Bionic Beaver)", my SQL Server had to be removed, and can't be reinstalled. The following message shows during the apt-get installation step:

    "
    maxt@mars:~$ sudo apt install -y mssql-server
    Reading package lists... Done
    Building dependency tree

    Reading state information... Done
    Some packages could not be installed. This may mean that you have
    requested an impossible situation or if you are using the unstable
    distribution that some required packages have not yet been created
    or been moved out of Incoming.
    The following information may help to resolve the situation:

    The following packages have…

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Fix intellisense in OVER clause (SSMS)

    Intellisense in SSMS is great, but it appears that it doesn't work inside an OVER clause.

    Could this be fixed?

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSDT error SQL46010 on iif

    SSDT reports an error on this valid syntax:

    create procedure test
    as

    if (iif(1 = 1, 1, 0)
    
    )
    &lt; 2
    select &#39;ok&#39;

    Severity Code Description Project File Line Suppression State
    Error SQL46010: Incorrect syntax near ). Stored Procedures\Procs2\test.sql 4

    See https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ec0a584-1eec-4ffb-b5b2-1df6092817e6/sql46010-incorrect-syntax-near-?forum=ssdt

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

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. Bug in Merge Replication snapshot agent with FILESTREAM and UNIQUE constraints

    The snapshot agent fails when running on a publication that contains a merge article with FILESTREAM columns and a UNIQUE constraint.
    The full description of the bug with repro script and workaround can be found here: https://spaghettidba.com/2018/07/03/a-bug-in-merge-replication-with-filestream-data/

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Enhance the "AT TIME ZONE" functionality to allow specifying "use server local time" instead of an explicit time zone name.

    Enhance the "AT TIME ZONE" functionality to allow specifying "use server local time" instead of an explicit time zone name. Right now you need to know the server's time zone when using the AT TIME ZONE functionality.

    Something like:

    DECLARE @TZ NVARCHAR(100) = 'Server Time Zone'
    DECLARE @D DATETIMEOFFSET = '2017-01-01T00:00:00+00:00'
    SELECT @D AT TIME ZONE @Tz

    Right now you need to know the server's time zone (e.g., 'Eastern Standard Time'). This isn't always know when you are installing software around the world.

    I don't care about the syntax.

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

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSDT Database projects need a mechanism to handle static or reference data

    There needs to be some sort of design surface and storage mechanism to handle static/reference tables in a database project. Right now, the only real way to handle static data is to have a laundry list of MERGE statements in the post-deploy script, which gets very difficult to manage over time.

    Ideally, the table design surface would have a way to store the static data, and then the publish workflow would either build out the Merge statements at a minimum, or even better, do the data lookup compare and create just the statements needed to bring the reference data table…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. SSMS v17.x slow launch time

    Why does SSMS v17.x take so long to load from initial launch? From the time I click on the icon to launch it to the time it asks me to select the server to connect to is 30+ seconds. At least 20-25 seconds until the splash screen is displayed.

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. Make it possible to have transactions doomed only where there is a reason to

    Today when you enter a CATCH handler, the transaction may be doomed, meaning that you cannot continue or roll back to a savepoint. And this is perfectly OK for concurrency errors like deadlock or errors with severity >= 17, like running out of disk space. The problem is that many other errors also doom the transaction for no good reason at all. And when SET XACT_ABORT ON is in effect, all errors doom the transaction.

    This means that it is not possible to implement a recoverable error handling for unexpected errors. For instance, if you are in a procedure that…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add SQL Code Formatter

    Please add a SQL code formatter to the query editor. It should work like the C# code formatter in Visual Studio except for SQL.

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

    We’ll send you updates on this idea

    4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. 5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. I like a system DMV to tell me when the last time a stored procedure was executed

    I like a system DMV to tell me when the last time a stored procedure was executed

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Please add the Scroll bar to the Parameters section in SSRS Report Manager like in SSDT

    When viewing a SSRS report on a device with a smaller screen, such as an iPad or iPhone, if there are several parameters, it takes up a lot of space, and with SSRS 2016, it does not scroll out of view - only the report section scrolls.
    Could you please provide scroll bar for parameters section in Report Manager like in SSDT.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. ssas tabular 1400 web connector

    The new compatibility level 1400 of SSAS allows you to use on M Query language to define the Data Source of your Model.

    In a way this is the alternative to the Content Packs on Power BI online.

    You can develope your Tabular Data Model with Power BI desktop and then implement it on SSAS without having to recode your queries with SSIS.

    MS Excel or Txt files are accepted but always as local file only.
    My issue is that todays SSAS 1400 accept JSON File as a Data Source but only local files.
    Json is typically return by web…

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

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base