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. Merge Agent auto resume when downloading snapshot

    When the merge agent is downloading a snapshot either compressed or not a communication error causes it to fail and it must start downloading all over again. International downloads to some countries can be trouble some and we have to use a more reliable download manager to get the cab file accross.

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

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Sep 16 2008 10:32AM=-=>

    We will take a look at this with other improvements for next release. Thanks

    <=-=Sep 16 2008 10:58AM=-=>

    Thanks for reporting this issue

    <=-=Jan 4 2012 4:08PM=-=>

    Hi Martin,

    We’ve looked into this. Although we would like to improve the product this way we will not have the means to do it in a foreseeable future.
    That said your feedback is very valuable to us, we keep track of the suggestion.

    Best regards
    Jean-Yves Devant
    Program Manager (Replication/CDC/CT)

    SQL Server Engine Team

    <=-=Jan 4 2012 4:08PM=-=>

    Hi Martin,

    I’m closing this discussion item for now.
    Best regards

    Jean-Yves Devant
    Program Manager (Replication/CDC/CT)
    SQL Server Engine Team

  2. Prompt for selection of a parameter in SSRS

    If you donot select a parameter "XYZ" in report and clicked on "View Report" button then the report will prompt as -
    Please select a value for the parameter "XYZ" .
    This error prompt should be editable to write in own words like-
    Please select "XYZ" .

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. After an XML modify() operation, need a way to know if the operation succeeded or not.

    After performing an insert/update/delete operation in an XML variable or column using the modify() method, there is no way to know if the operation succeded or not. There needs to be a way to know if any element/attribute is updated/deleted/inserted and the number of elements/attributes affected. Something like @@rowcount.

    Edited on 30 Aug 2008.
    SQL Server does not raise an error if the modify operation fails (if it could not modify the value). So there is no easy way to identify where the update/insert/delete operation actually modified the value or not. We need a way to identify this.

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

    We’ll send you updates on this idea

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

    Upvotes: 5

    <=-=Sep 9 2008 5:10PM=-=>

    Dear Jacob and people voting on this item.

    Thanks for the request to report how many elements or nodes have been updated. How do you see the this work across multiple rows? Do you want it on a per average, per row, or the min and max values?

    Best regards
    Michael

    <=-=Sep 9 2008 8:27PM=-=>

    I think if we can get a count of elements/attributes updated, that will be good enough to start with. If the update operation did not modify anything, it may return 0 and if it updates 2 elements it may return 2.

  4. Unable to access new instance of SQL as member of administrators

    After installing 2008 I was unable to connect to the database using any protocol as a member of the administrators group.
    I had to logoff and log back on as "Administrator" for the local machine and then add my domain account directly to SQL server as a Sysadmin.

    Then I had too alter the windows firewall to allow even cmd line access to the local instance of the database.

    Vista Enterprise edition.
    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 6.0 <X86> (Build 6001: Service…

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Sep 10 2008 10:38AM=-=>

    In versions earlier than Windows Vista and Windows Server 2008, members of the local administrator group do not need their own SQL Server logins and they do not need to be granted administrator privileges inside SQL Server. They connect to SQL Server as the built-in server principal BUILTIN\Administrators (B\A), and they have administrator privileges because B\A is a member of the sysadmin fixed server role.

    In SQL Server 2008, the BuiltIn\Administrator login group is NOT provisioned by default during setup install. Instead during SQL Server 2008 setup install (on the account provisioning screen), users are required to provision one or more admin account into the sysadmin fixed server role to perform administrator actions on SQL Server.

    Secondly BuiltIn\Administrator rights (by default) are stripped away in Windows Vista and Windows Server 2008 because of UAC feature, so box administrator users cannot connect to SQL

  5. Report Manager Communications should be compressable

    While using the report manager with reports that have cascading parameters that is connected to an AS cube we get poor performance during the parameter selection process when connected over the internet OR a VPN connection. This does not occur when on the local network.

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Sep 15 2008 3:51PM=-=>

    Thank you for filing this bug.

    We are currently investigating your request for the next version of SSRS. Will keep you posted.

    thanx,
    Prash

    <=-=Apr 16 2010 9:21PM=-=>

    Thanx you for filing this bug.

    After further review we decided not to include your suggestion in the SSRS 2008 R2 Report Manager. We plan to keep it under consideration in our plans for the next version of SSRS.

    thanx,
    Prash

    <=-=Apr 16 2010 9:21PM=-=>

    Thanx you for filing this bug.

    After further review we decided not to include your suggestion in the SSRS 2008 R2 Report Manager. We plan to keep it under consideration in our plans for the next version of SSRS.

    thanx,
    Prash

  6. Custom Report Item should support other types then only images

    Allow create custom report item of other types like HTML and with this we could create custom report item that create flash chart or silverlight charts, it will give much more power to Report Services.

    Others BI tools like MicroStrategy and Business Objects have this out of the box (flash charts).

    And why do not allow to create custom items of other types?

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Sep 30 2008 6:53PM=-=>

    Hello,

    Thanks for writing in about this feature request. We will evaluate this for a future version of SQL Server. If we have information to give you regarding the status of this bug, we’ll do so via MS Connect.

    I’m keeping this active, but marking it to be re-evaluated as we begin our next round of planning.

    Best regards,
    Chris B.
    SQL Server Reporting Services

  7. Ability to handle temporal data / columns within the engine core

    Enterprise Data Warehouses require "start / end" or "load/load-end" dates to house data over time.

    What I would like is the ability to issue a select statement as follows:

    Select <most recent data>
    from the EDW.TABLE
    where
    data is current AS OF <my date>

    In other words, a whole host of "temporal based" functionality where SQL is capable of recognizing "layers" of data for a specific point in time.

    Thanks,
    Dan Linstedt

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

    We’ll send you updates on this idea

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

    Upvotes: 2

    <=-=Aug 26 2008 5:06PM=-=>

    Dear Dan

    Thanks for your feedback and suggestion. Are you specifically interested in the so-called transaction time (where the timestamp is immutably given at the time the data is inserted) or the so-called valid time (a user-specified timestamp indicating the validity of the data) or both?

    We are looking into a variety of interesting solutions in this space and your feedback, including your rating would be valuable input.

    Thanks
    Michael

    <=-=Mar 9 2011 5:04PM=-=>

    Dear Dan, we are closing this as a duplicate of the Feedback item 557002 since the other item has collected some votes on it already. Please go and add your own vote and comments on the other item.

    Thanks
    Michael

  8. Change or remove message 1061 from sys.messages

    When you perform:

    select * from sys.messages where language_id = 1033 and text like '%yet implemented%'

    there is a row refering to message_id = 1061. The text is: "The text/ntext/image constants are not yet implemented."

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

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Aug 19 2008 11:30AM=-=>

    Hi,
    Thanks for your feedback. We will remove this error message in a future version of SQL Server. This error message is not used by the engine currently.


    Umachandar, SQL Programmability Team

    <=-=Mar 8 2011 3:11PM=-=>

    This has been resolved as duplicate of connect item below:

    https://connect.microsoft.com/SQLServer/feedback/details/650174/cleanup-error-messages


    Umachandar, SQL Programmability Team

  9. Column widths and editing data for DB views in Management Studio

    The biggest issue for me is entering and editing data in a SQL Server or Express edition database without having to develop a .NET application. Using views in SQL Server Management Studio (SSMS) are a good choice for this task and work OK once I figured out that I had to use "TOP (N)" and not "TOP (100) Percent" to be able to edit data in a sorted view. I am also using INSTEAD OF triggers to "flatten data" from multiple tables. What I find really annoying is that the field column widths can be saved for the results pane…

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

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Aug 26 2008 8:28AM=-=>

    Hi,

    Thank you for filing the enhancement request to us. We understand that adjusting columns can sometimes be painful during repeated script executions and directly editing results can be a convenience. I have marked your bug as direct feature feedback for a future release of SQL Server.

    Thanks again,
    Karthik

    SQL Server Manageability Team

    <=-=May 30 2011 1:58AM=-=>

    Hi,

    We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

    Thanks for writing in to Microsoft.

    Cheers,
    Karthik Vijayakumar

  10. SQL 2008 Report Model Enhancement

    The possabilites to add a good description in a report Model are sometimes limited (due to readability). For example a Tooltip in Report Builder for an Entity is nice for some words but not for more extensive descriptions

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. SQLAgent Job Notifications

    SQL Server just keeps getting better, by the way, so thanks. DMVs rock! But (!) could you please change SQLAgent job notifications to be more specific about the result than just Succeeded or Failed? When you look at the job history the icons tell you whether all steps succeeded or only some. I'd love to see something in the notification email that would prompt me to check the results in detail.

    For example, I have a job to do my backups with a step for each database. Each step goes on to the next step even if it fails because…

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Jul 18 2007 6:04AM=-=>

    I agree, that would be very helpful. In the interim, I run this query to monitor jobs. This query can easily be customized to retrieve specific job and instance info….so you could tie it in as the last step of a job and email the results.

    select name,server,step_name,message,run_date,run_time,run_duration from sysjobs j
    inner join msdb.dbo.sysjobhistory h on j.job_id = h.job_id
    where run_status = 0
    order by j.name,instance_id

    <=-=Jul 24 2007 1:23PM=-=>

    Thanks for the report. We’ll be investigating this for a future release.

    -Richard Waymire

    <=-=Oct 29 2008 4:23PM=-=>

    Hi,

    Your feedback make a lot of sense and we will consider it for the next release,

    Gil

  12. RS: support PDF with digital certificates

    In enterprise environments, there is more and more demand for "signed" PDF documents, that a signed/protected with a digital certificate.
    Depending on the local regulation, invoice documents have to be "signed" to be accepted by the tax authorities (e.g. Germany)

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Report Model Perspective Security

    Unable to secure permissions for perspectives

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Reporting Services 2005 - Hide in List View

    Visual Studio or BI Develop. Studio should allow us to set by default a especific value for the "Hide in List View" property. This way if we deploy thousands of sub-reports we dont lose time by hiding it one by one in the Portal.

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

    We’ll send you updates on this idea

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

    Upvotes: 5

    <=-=Oct 29 2007 5:18PM=-=>

    Thanks for the suggestion. We will consider this for a future release.

    <=-=Sep 5 2008 1:39PM=-=>

    I would also like to see the ability of setting a Friendly Name(display name) for a report, as opposed to it’s visual studio file name.

  15. BPA : Should offer at least local instance choices

    When I get to the "Register SQL Server components" screen in the latest version of BPA (9.0.1004.0), and I select "Database Engine", I have a dropdown for SQL Server instance name. However, this dropdown is empty, which is inconsistent with several other tools (e.g. Profiler, Mangement Studio) which offer a list of recently-connected instances and/or local instances.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow finer grain of control for database level permissions

    There are a number of database level command that can be executed but only if you are a db_owner. These permissions are implicit and cannot be explicitly granted or denies, unlike other database level permissions such as "backup database".

    This can cause several security issues. For example, if you have someone who uses DTS or SSIS for the data warehouse which is updatable and usually in full recovery mode, you would like to permit this person to be able to switch between bulk recovery and back to full recovery. Unfortunately the only way to allow this is to grant full…

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

    We’ll send you updates on this idea

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

    Upvotes: 3

    <=-=Mar 31 2008 2:44PM=-=>

    Hi Richard,

    Thank you for your feedback. We can’t make any changes to SQL Server 2008 but we will consider your request for a future release of SQL Server.

    Thanks,
    Il-Sung Lee.

    <=-=Feb 11 2013 2:23PM=-=>

    Hi Richard, Thank you for your feedback. We can’t make any changes to SQL Server 2008 but we will consider your request for a future release of SQL Server.

  17. Add flag to CREATE DATABASE command which specifies if data file should be zeroed out on create or on the fly.

    I think that an excellent addition to Microsoft SQL Server would be the ability for the CREATE DATABASE command to be able to specify if the physical files should be zeroed out at creation (aka SQL 2000 style) or on the fly (aka SQL 2005 style).

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Dec 13 2007 3:16PM=-=>

    Thanks for your suggestion.
    We are looking at more explicit methods for controlling file initialization.
    Likely this will take the form of an instance switch, since it impacts more than database creation (restore, grow, add file). The switch would be dynamic however.

    <=-=Dec 13 2007 6:03PM=-=>

    An instance level switch would be perfect.

    Thank you for looking into adding this into SQL Server.

    <=-=Dec 13 2007 6:08PM=-=>

    I was thinking with a create database flag so that you could have different databases setup to work different ways. Also I would assume that this way it wouldn’t to change able. (I would assume that you wouldn’t want to allow this to be changeable after database creation.) With a database instance I would assume that the setting would in some way be changeable which you probably wouldn’t want to be able to happen.

  18. Dynamic Sub-Report

    Hi,

    I have been waiting for this option for several time now. Till today i am currently overlapping (causes warnings) sub-reports and setting proper visible settings to each one along the settings choosen.
    If we could load this sub-report dynamically we would definitly get an improvement in report building and possibilities.

    Best Regards,
    Luis Sim�es

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

    We’ll send you updates on this idea

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

    Upvotes: 9

    <=-=Jul 9 2007 3:10PM=-=>

    Thank you for requesting this functionality. This will be considered for a future release of SQL Server Reporting Services.

    <=-=Aug 8 2008 9:36AM=-=>

    Hi, Should i duplicate this post for 2008 version? Or is this item still a go for 2008 either? Regards

    <=-=Apr 16 2010 1:16AM=-=>

    I am using SSRS 2008. I am struggling with trying to call sub reports dynamically. Could you please confirm if there is a way of doing so via coding or some other option.

  19. Reporting Services 2005 - Email Report Feature

    End users would sometimes like to email a report (or filtered report) to others within the organization that may or may not have access to Reporting Services. While do so before they send the report they would like 1) select the attachment type (Excel, PDF etc) 2) add some text on the email dialog box describing the attachment.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Role Playing dimension - change level name

    In order to use the dimension�s role playing functionality, it should be possible to change the name of the attribute/hierarchy� levels.
    E.g., you use 2 time dimension using role playing, it is not possible (at least to my knowledge) to change the name of the attribute/hierarchy� levels. The first dimension is related to orders time and the second to delivered time, the end-users would like to be able to figure out if the month is related to the order or the delivery.

    Order Time:
    � OT Year
    � OT Month
    � OT Day

    Delivered Time:
    � DT Year
    � DT…

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

    We’ll send you updates on this idea

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

    Upvotes: 20

    <=-=Feb 6 2008 3:18PM=-=>

    Thanks, this is a good idea. We’re looking into this for upcoming releases of Analysis Services.

    -Analysis Services Team

    <=-=Apr 27 2008 3:39AM=-=>

    I found a similar request from Chris Webb https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=144500&wa=wsignin1.0

    Tiago.

    <=-=Apr 28 2008 12:33AM=-=>

    This is the singlemost frustrating aspect of SSAS for us.
    It effectively means that every role playing dimension that is required to have its own uique name needs to be created as a real cube dimension with the consequent impact on development time, storage space and processing time.

    <=-=Oct 27 2011 6:12PM=-=>

    Is this atleast addressed in SQL Server 2012 which is right now in CTP 3?

    <=-=Sep 5 2012 7:36AM=-=>

    I too would like to know if this has been included in SQL 2012 as we are contemplating individual dimensions (Date is killer as we have tons and very time consuming to do the identical setup…

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base