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. SSDT 17.x - Unable to preview SSIS OLE DB Data Source when using Oracle Connector

    I have an SSIS packages that queries an Oracle data source. When trying to preview the query in the data source configuration window, it errors out.

    Technical Details:
    Visual Studio 2015, Update 3, Version 14.0.25431.01
    SSDT 17.4 (Build 14.0.61712.050)
    Oracle Client 12.1.0
    OLE DB Connector: Oracle Provider for OLE DB
    Error Details:
    ===================================

    There was an error displaying the preview. (Microsoft Visual Studio)

    ===================================

    The system cannot find message text for message number 0x80040e51 in the message file for OraOLEDB. (OraOLEDB)

    ------------------------------
    Program Location:

    at Microsoft.DataTransformationServices.Design.UnsafeNativeMethods.ICommandWithParameters.GetParameterInfo(IntPtr& pcParams, IntPtr& prgParamInfo, IntPtr& ppNamesBuffer)
    at Microsoft.DataTransformationServices.Design.DesignUtils.GetQueryParameters(ConnectionManager connectionManager, String sqlStatement)
    at Microsoft.DataTransformationServices.Design.PipelineUtils.ShowDataPreview(String sqlStatement, QueryParameter[]…

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

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. DATETRUNC(datepart,datevalue) instead of dateadd-datediff

    The generally accepted way to truncate some part of a datetime is:
    DATEADD(datepart,0,DATEDIFF(datepart,0,datevalue))
    To save us from much typing, and probalby a good amount of CPU due to a good implementation, I propose we create a new function exactly for that:
    DATETRUNC(datepart,datevalue)
    which rids the datevalue of any component LESS than datepart (ie, truncates it to the dateart level)

    6 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSRS - Bullets and Number Lists in HTML

    SSRS text fields formatted as HTML which contain an <ol> or <ul> tag get list numbers or bulets (respectively) which do not have the font size specified in the text box properties. For example, a numbered list with a text box font size of 8pt gets numbers with a font size of 10pt. A bulleted list gets a symbol font with a font size of 10pt. This modified the line height and modifies the list spacing from the default line height as well.

    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 →
  4. SSIS package fails to start - application lock timeout in SSISDB.catalog.create_execution

    Details are described here:
    https://connect.microsoft.com/SQLServer/feedback/details/783291/ssis-package-fails-to-start-application-lock-timeout-in-ssisdb-catalog-create-execution

    In short: when a scheduled job tries to execute an SSIS package , there's a time-out in the communication between the job and the SSISDB database. The package is never executed. The original bug reports was closed as duplicate (no duplicate to be found though).

    I encountered this bug in SQL Server 2017, patched to the latest CU.

    Error message: Failed to execute IS server package because of error 0x80131904. Description: The operation failed because the execution timed out. Source: .Net SqlClient Data

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

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. 7 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 →
  6. Deploy issue for SSDT database extended property / external tables

    Deploy issue for SSDT database extended property / external tables

    Summary:
    Deployment of an extended property 'MS_DESCRIPTION' on an external table fails, if the Extended property is scripted together with the external table.

    Deployment of an Extended property 'MS_DESCRIPTION' on an external table succeeds, if the Extended property is added in a postdeployment script.

    If something is changed, redeployment of the database fails, because the extended property 'MS_Description' can't be deleted.

    The following code is produced:
    EXECUTE sp_dropextendedproperty @name = N'MS_Description';

    This code would be correct:

    EXEC sys.sp_dropextendedproperty
    @name = N'MS_Description',
    @level0type = 'Schema', @level0name = N'schemaName',
    @level1type = 'Table',…

    8 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 →
  7. sql server on Linux reports 100% cpu when using RING_BUFFER_SCHEDULER_MONITOR to monitor

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

    e.g.

    <Record id="17239" type="RING_BUFFER_SCHEDULER_MONITOR" time="4619440182">
    <SchedulerMonitorEvent>
    <SystemHealth>
    <ProcessUtilization>100</ProcessUtilization>
    <SystemIdle>0</SystemIdle>
    <UserModeTime>0</UserModeTime>
    <KernelModeTime>0</KernelModeTime>
    <PageFaults>0</PageFaults>
    <WorkingSetDelta>0</WorkingSetDelta>
    <MemoryUtilization>100</MemoryUtilization>
    </SystemHealth>
    </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 →
  8. 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 →
  9. dm_db_stats_histogram missing row when column/histogram step contains NULL

    When statistics on a nullable column contain a NULL sys.dm_db_stats_histogram will not return a row for the corresponding histogram step (when RANGE_HI_KEY is a NULL). DBCC SHOW_STATISTICS returns all steps including the aforementioned missing one. Without all the histogram levels dm_db_stats_histogram is not usable.

    I can confirm this behaviour with INT and VARCHAR columns, I haven't tested other data types). I have attached the reproduction code and a screenshot. Any questions please let me know. Thank you.

    SQL Version: 14.0.3025

    10 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. Add SSMS Option to show NULL value Differently than 'NULL' text

    It would be nice if SSMS could be used to help distinguish between NULL values and the 'NULL' string value. Perhaps show NULL in grey? Just spent 6.5 hours troubleshooting what turned out to be a string 'NULL' inserted by someone rather than NULL, and if it had been clear on the initial query results grid, I'd have found that much more quickly.

    2 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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. CEIP Service cause noisy error log

    We found that CEIP Service causes following error log messsage in production server.

    CImageHelper::Init () Failed load of symbol file with path = D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\;D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\BINN Error Code 0xc0000004

    - 0xc0000004 : The specified information record length does not match the length that is required for the specified information class

    following attached file is event log that I collected.
    Version of prod server is following (which is on AZURE):
    Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64) Sep 5 2017 16:12:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Datacenter 6.3 <X64>…

    8 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 →
  12. '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…

    5 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 →
  13. 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 →
  14. 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…

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

    We’ll send you updates on this idea

    19 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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  ·  3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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 →
  17. 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…

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

    3 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 →
  19. 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

    11 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. SSISDB Upgrade Failure

    SSMS 17.8 contains a bug with SSISDB, specifically, when connected to a SQL Server 2016 SP2 CU1 instance (locally on the same server), if you restore a SQL backup of SSISDB from a 2014 instance and select "Database Upgrade" from Integration Services Catalogs - you get the following exception:

    Object reference not set to an intance of an object. (Microsoft.SqlServer.IntegrationServices.UITasks)

    Inner exception of which is:

    Microsoft.SqlServer.IntegrationServices.UITasks.Helpers.GetDtsSetupPath(string subKeyName).

    This issue occured with SSMS running normally, and when elavated as Administrator.

    During a recent upgrade we were forced to abandon our 2014 SSISDB upgrade and create a new blank catalog on the…

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

Feedback and Knowledge Base