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. Installing Report Builder as Stand Alone application

    We are currently using Report Builder 9.00.3042.00, which deploys as a cloick-once application. Many of our users do not have local rights allowing them to install applications, so these users have no means of accessing our ad hoc report facility. Is there a method for including this in the base image so that it does not need to run as a click Once application?

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Oct 13 2008 8:37PM=-=>

    Thank you for using SQL Server Reporting Services.
    click-once is an area we are investigating for a future release.
    thank you for your patience.

    <=-=Dec 9 2008 11:55AM=-=>

    Thanks for your feedback. In SQL 2005 we do not provide a standalone installer for Report Builder. However, this is available in SQL 2008 with Report Builder 2.0. Note that SQL 2008 Reporting Services is required.

    The download page is here:
    http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en

    Hope that helps!

  2. OPEN { SYMMETRIC | MASTER } KEY Password Parameterization

    Consider the following SQL statement to open a symmetric key, decrypting it by a certificate that has its private key protected by a password:

    OPEN SYMMETRIC KEY [MyKey] DECRYPTION BY CERTIFICATE [MyCert] WITH PASSWORD = '<password>';

    Since OPEN ... KEY SQL statements do not accept parameters, you need to formulate the SQL string as inline-SQL (YUCK!). Assuming your password is 'abc123', your SQL statement will look something like this:

    OPEN SYMMETRIC KEY [MyKey] DECRYPTION BY CERTIFICATE [MyCert] WITH PASSWORD = 'abc123';

    Nothing wrong there.

    Now assume we select a password of [';SELECT 'SQL INJECTION';--] (excluding the square brackets []), your…

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 12

    <=-=Sep 25 2008 2:39PM=-=> The tile for the bug is a little bit misleading as there is no direct SQL injection vulnerability in the DDL statement, but since there is no parameterization on DDL, it forces any application to use dynamic SQL by concatenating strings in order to generate the statement. Because using dynamic SQL opens the opportunity for SQL injection problems in case the user data (in this case the password) is not properly escaped. We definitely agree that there is a potential for improvement in this area, and I would like to generalize it a little bit more: Allow DDL parameterization for DDL that accepts passwords, including OPEN (SYMMETRIC | MASTER) KEY. We are currently considering how to improve in this particular area, but I would like to invite anyone who is forced to use dynamic SQL for DDL/DML to…
  3. Intellisense -- Collapse shortcut

    1.)It would be nice to implement a collapse outline feature which collapses regions of code with a quick shortcut key. For instance, if you have multiple nested begin end's it would be nice to collapse them to quickly get a visual if you are missing an end.

    2.)Also would be nice to have intellisense automtaically add the end in the correct tab placement when a begin was entered.

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 116

    <=-=Sep 19 2008 11:02AM=-=>

    Hello Exempo,

    Thank you for your suggestions. Intellisense is a new feature in SQL Server SSMS 2008 and it is expected to be enhanced over multiple releases. There were multiple features/enhancements that were considered for the first release but not all could make it due to timing constraints. Your suggestions on outline shortcuts and smart identing are indeed useful to the end user and will be considered for a future release of SQL Server. Please watch out this space for updates on this bug.

    Thanks,
    Karthik

    <=-=Sep 1 2010 1:08AM=-=>

    Still not looked at?

    Visual Studio had this for years. VS and SQSMS share a lot of common functionality.

    <=-=May 17 2012 4:34AM=-=>

    This feature would be most welcome. Using the work around for now.

    <=-=Jul 20 2012 1:31PM=-=>

    Hope this has been implemented in SQL Server 2012

    <=-=Mar 22 2013 9:06AM=-=>

    Thanks for…

  4. Embedded subreports for use with ReportExecutionService.LoadReportDefinition

    Our product uses ReportExecutionService.LoadReportDefinition to execute reports from templates stored in an enterprise content management system which attaches further workflows and policies.

    Executing reports in this way reduces the IT footprint of the product.

    Further development of the product is limited by the following problem:

    SQL Server Reporting Services do not currently support nested data regions (http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=336556).

    The common workaround is to use subreports.

    However, ReportExecutionService.LoadReportDefinition does not currently support subreports that are not stored in the report server's catalog.

    These problems require us to implement temporary storage management for subreport templates (rendering our use of LoadReportDefinition unnecessary…

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. SSMS - Add multiple job enabling/disabling

    In SSMS when you open Object Explorer Details window (by pressing F7) and navigate to SQL Agent jobs there is an ability to select multiple jobs. But when you right-click on the selected jobs there are only Script and Delete options available.

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 7

    <=-=Sep 22 2008 11:49AM=-=>

    Hi,

    Acting on set of objects is something we are considering for the next release.

    Thanks,

    Gil

    <=-=Oct 26 2009 1:28PM=-=>

    I’ve resolved this bug as a Duplicate of another work item tracking this functionality.

    Thanks,

    Amy Lewis

  6. More feedback when running long operations

    I would like to be able to see how far through an operation isn (any operation) - so if sql is doing a scan of an index - it knows how many pages there are in that index so it could let me see how far through that scan it is.

    This way I would know when a long running query is going to take - it doesn't matter if it isn't totally accurate but just gives a feel for how long it will take.

    It would either give the seconds or preferably, give the percent of the way through…

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add Templates for Report Builder 2.0

    Report Builder 2.0 doesn't support templates.

    0 votes
    Sign in
    (thinking…)
    Password icon
    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?

  8. 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…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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…)
    Password icon
    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.

  10. 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…)
    Password icon
    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…

  11. Allow Rounded Rectangle report control

    Allow Rounded Rectangle report control

    0 votes
    Sign in
    (thinking…)
    Password icon
    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,…

  12. 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…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. exec proc pr_GivesTableBack into tmpTable

    It would be great if we could put the result(table) of a procedure into a non existing table.
    This because of dynamic pivots so we do'nt know the columns up front.

    Maybe the result of the procedure could be used in a query! This way we could filter it.
    My procedure returns a lot of columns based on dynamic pivots, this for consulting purposes. Because of the dynamic pivots I have to use sp_executesql so I can't use a function for this.

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 1

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

    Hi,
    Thanks for your feedback. We will consider your suggestion for a future version of SQL Server. This is not something we can do in SQL Server 2008 so I have moved your request to the next major release milestone.


    Umachandar, SQL Programmability Team

    <=-=Jul 30 2010 12:12PM=-=>

    I would agree with the “or” part Wim Sql Server’s solution proposal. We don’t need dynamic sql in functions but the pivot statment should be implemented differently. I don’t always know the values I am aggregating at design time.
    Below is an example including the current syntax and a possible improvements:
    —Growing List of Persons that could get an award
    CREATE TABLE persons
    (
    person nvarchar(50) NOT NULL
    CONSTRAINT pkPerson PRIMARY KEY CLUSTERED
    )
    go
    CREATE TABLE mybridgetable
    (
    person nvarchar(50) NOT NULL
    CONSTRAINT fkBridgePerson FOREIGN KEY REFERENCES persons (person)
    ,award nvarchar(50) NOT NULL
    CONSTRAINT

  15. 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…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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…)
    Password icon
    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.

  17. 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…)
    Password icon
    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

  18. 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…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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…)
    Password icon
    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.

  20. 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…)
    Password icon
    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

  • Don't see your idea?

SQL Server

Feedback and Knowledge Base