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. Add Templates for Report Builder 2.0

    Report Builder 2.0 doesn't support templates.

    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: 18

    <=-=Sep 17 2008 3:19PM=-=>

    Thanks for your feedback. Many other customers have requested this feature as well. We are considering ways to add this in a future release. You may find that creating a “starting” report containing the essential elements, then granting users read-only access to it, is a reasonable solution in the meantime.

    <=-=Mar 25 2010 8:28AM=-=>

    This feature very important and should be resolved. If its good enough for Visual Studio SSRS developers, why wouldn’t it be for RB writers?

  2. Add Cardinality Indicator in Analysis Services Dimension Attribute Relationship Designer

    When creating and maintaining attribute relationships in BIDS/SSAS 2008, there is no visual indication in the designer of the Cardinality of the relationships.

    It would assist maintainability and troubleshooting if the Cardinality was exposed visually, much like the RelationshipType is.

    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. Add support for CSS and branding in report builder

    Currently there is no way to tailor the template(s) used by SSRS Report Builder to make user reports consistently exhibit companies' look and feel (and I understand from a news thread with Sean Boon [MSFT] that the situation is the same in SQL 2008/RB2). This is a major drawback for our users and our customers who want to use the product, because every time they create a new report, they have to spend the first five minutes adding logos, moving objects around, and changing textbox formats.

    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: 27

    <=-=Sep 19 2008 6:49AM=-=>

    Thanks for your feedback on Report Builder. These features are high on our priority list, and are frequently requested by other customers as well. We are working on adding them in a future release.

    <=-=Nov 30 2010 1:36PM=-=>

    Based on the age of this post and a lack of comments, everyone must be using another reporting solution. Would you mind sharing what that solution is?

    The ability to, at minimum, establish a template per client, or better yet, CSS Stylesheet support is crucial to any widespread adoption of this tool.

  4. Activity Monitor Windows Scrollbars and Sizes

    The "new" activity monitor, used in the SQL 2008 tools is not useable. On many servers, I have between 500 and 2500 connections and have to scroll a lot because I can only see 8 connections at a time in the process list.

    To get to the up/down scrollbar, there are two horizontal scrollbars on the bottom that I have to navigate on my narrow screen in order to get to the vertical scrollbar.

    I use a monitor flipped sideways to see long screens.

    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: 12

    <=-=Sep 16 2008 5:09PM=-=>

    Hi bryanivie,

    Thank you very much for reporting the issue on usability of the process list window inside the Activity Monitor. We will consider making improved UI designs, including your specific ask, in the next release of SQL Server.

    Shirley Wang

    <=-=Dec 4 2008 5:48PM=-=>

    I wonder sometimes if Microsoft employees actually use SSMS to manage their own production databases. Changes like this take SSMS one step forward (by adding the new tabs like CPU history and Expensive Queries) and two steps backward (by making the data harder to browse). If you compare the Activity Monitor in SSMS 2005 with that in SSMS 2008, you readily see that 2005 has horizontal scroll bars, while they’re gone in 2008. Additionally, 2005 has light gray column and row dividing lines, and they too are gone in 2008.

    Please reconsider adding back the horizontal scrollbars and restoring…

  5. Allow Rounded Rectangle report control

    Allow Rounded Rectangle report control

    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: 180

    <=-=Sep 17 2008 7:56AM=-=>

    Thank you for using SQL Server Reporting Services.
    We will review your comments/request for rounded rectangles for a future release.

    <=-=Nov 13 2009 6:10PM=-=>

    Hey, while you are at it, can you please add some drop shading to that puppy? What about a blend like you have in chart? And maybe a little 3D? Reflection? Glow?

    Give the people want they want! Power rectangles!

    <=-=Dec 29 2009 3:50AM=-=>

    Maybe adding a corner radius to the Rectangle would be just what we need, a rounded control would be to much.

    <=-=May 27 2010 12:25PM=-=>

    Yes please. Ability to specify rectangles with rounded corners and to set the size of the corner in millimeters

    <=-=Oct 25 2010 8:58AM=-=>

    Agreed — Tables, Rectangles, Text Boxes all need rounded edges — there is really not a reason not to.

    <=-=Nov 17 2010 1:13PM=-=>

    Agree. Tables, Rectangles, Text Boxes,…

  6. Deploying Reports For Different Environments

    Currently there is not way to easily deploy reports to multiple environements, like a dev, test and production environment. I believe other users have a similar problem except for it deals with multiple customers.

    Please see this Forum Post:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=91394&SiteID=1

    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 →
  7. SSRS - Allow custom data extensions to launch the connection string builder UI.

    In SSRS, only out-of-the-box SSRS data extensions/providers are able to launch the connection string builder UI when configuring a new data source.

    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 →
  8. Export to Excel - Add workbook and/or cell protection

    We have many "power" users who likes to get their reports in Excel so they can manipulate them to their likings. Often times, this is what they are use to getting. However, some managers want them to have access to the data but not be able to change it. It would be nice to have the option to "protect" the workbook and/or cell.

    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 →
  9. Provide ALTER Permissions at the Database Object Class Scope Level

    Currently, I can GRANT or DENY explicit CREATE TABLE, PROCEDURE, FUNCTION, etc. permissions at the Database Object Class level.

    In order to GRANT a particular object class (PROCEDURE for example), I must GRANT CREATE PROCEDURE at the database scope and ALTER at the schema scope levels. However, that ALTER SCHEMA permission exposes modification to every other object class within the scope of that schema. I must then explicitly DENY ALTER on every specific object within that schema that I want to restict modifications.

    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 2 2008 12:46PM=-=>

    Hi Anthony,

    Thank you for your suggestion. It’s too late to make any changes to SQL Server 2008 but we will consider this for a future version of SQL Server.

    Thanks,
    Il-Sung.

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

    Hi Anthony, Thank you for your suggestion. It’s too late to make any changes to SQL Server 2012 but we will consider this for a future version of SQL Server.

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

  11. 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 →
  12. 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.

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

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

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

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

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

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

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

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base