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. BACKUP Encryption

    We all know that we can open up a BAK or TRN file using any text editor and see something readable. Anybody who can grab a hold of the backup files can simply restore it to any SQL Server instance and see the data inside the backup file.

    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 4 2007 11:40PM=-=>

    This is a very valid point. Might be a challange to read a terabyte backup with notepad. Securing backups, which tend to hang out on disk drives these days and not carried away tape drives anymore, is a very valid request.

    <=-=Nov 15 2007 1:03AM=-=>

    HI cpdaniel,

    thanks for reporting this issue. We will investigate and update this space accordingly.

    Regards
    Vinod

    <=-=Nov 15 2007 1:05AM=-=>

    HI bass_player ,

    ignore previous note. Thanks for reporting this issue. It is valid security issue you are suggesting and we will consider this for our future release.

    Regards
    Vinod

    <=-=Dec 18 2007 1:27PM=-=>

    This is functionality that we are planning to implement, however it will not make it into the SQL 2008 release. Your Connect entry and the other votes for it will help make sure that it is ranked appropriately in planning the next release. Thank…

  2. Usage Reporting in Reporting Services

    To be able to track report usage, size, and execution times, it would be nice to have some built in, supported reports.

    Samples of this are available here: http://www.codeplex.com/MSFTRSProdSamples/Wiki/View.aspx?title=SS2005!Server%20Management%20Sample%20Reports&referringTitle=Home.

    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. Data Obfuscation Facility in SQL Server

    Today, all organisations have to face the problem of data privacy and being from a financial organisation it's a real burden to at best, find a tool or at worst, have to develop techniques that can obfuscate our data when used outside of the Live environment.

    We need to obfuscate data when we allow developers access to Live data or have to send data off-site etc. Regulators are now seriously pressing organisations to provide evidence that they ensure customer data is in safe hands when taken away from the Live environment etc.

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

    <=-=Mar 27 2008 9:18AM=-=>

    Hello, thanks for the suggestion. We are considering this for the next release of SQL Server.

    <=-=May 9 2013 5:38PM=-=>

    Hi, Thank you for providing your feedback. You suggestion is something that we have already started thinking about. It’s unfortunately too late to add any new features to this release but we’ll definitely consider it for a future version of SQL Server.

    <=-=Jul 25 2013 2:18AM=-=>

    HI Team, Can you please confirm if we have added this feature in the SQL Server ?

  4. Add Global variables to SSRS for Browser DateTime and TimeZone

    Having the client browser culture setting available in SSRS is a great feature. It would also be very valuable to have the local time and timezone information from the client's browser available as global variables as well.

    Other web based applications can pick up on this information, and use it to good effect. not having the capability in Reporting Services hampers the ability to produce reports for an international audience when time zone considerations have to be worked into the report.

    I can think of more but the example that unveiled this need is a call center report. The global…

    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 →
  5. SQLXML4: The definition of "child" attribute should be optional in sql:relationship annotation

    In sql:relationship annotation, the definition of "child" attribute should be optional (like the "parent") for that case the child node contains sql:relation definition. At the following example both the parent and the child element has mapping information to sql tables. The child element has reference to the named relationship. The relationship does not need to contain "child" table mapping information.

    <xsd:annotation>
    <xsd:appinfo>

    &lt;sql:relationship name=&quot;CustOrders&quot;
    
    parent-key=&quot;CustomerID&quot;
    child-key=&quot;CustomerID&quot; /&gt;

    </xsd:appinfo>
    </xsd:annotation>

    <xsd:element name="Customer" sql:relation="Sales.Customer">
    <xsd:complexType>

    &lt;xsd:sequence&gt;
    
    &lt;xsd:element name=&quot;Order&quot;
    sql:relation=&quot;Sales.SalesOrderHeader&quot;
    sql:relationship=&quot;CustOrders&quot; &gt;
    &lt;xsd:complexType&gt;
    &lt;xsd:attribute name=&quot;SalesOrderID&quot; type=&quot;xsd:integer&quot; /&gt;
    &lt;xsd:attribute name=&quot;CustomerID&quot; type=&quot;xsd:string&quot; /&gt;
    &lt;/xsd:complexType&gt;
    &lt;/xsd:element&gt;
    &lt;/xsd:sequence&gt;
    &lt;xsd:attribute name=&quot;CustomerID&quot; type=&quot;xsd:string&quot; /&gt;

    </xsd:complexType>
    </xsd:element>

    By letting the…

    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 →
  6. SQLXML4: annotation for include the xml element name to SQL tables at bulk load

    An sql:element-name-field annotation item should be initiated so that to store the original xml element name to a proper column of an SQL Server table. This functionality is similar to the task of sql:overflow-field field, but the overflow-field contains data only when there is data cannot be inserted to any column. The sql:element-name-field should declare a column which always contains the name of the xml element inserted. The usage could be:
    <xs:element name="Note-Suggestion" sql:relation="XBL_Notes" sql:element-name-field="XmlElementName">
    <xs:complexType>

    &lt;!-- ... --&gt;
    

    </xs:complexType>
    </xs:element>
    <xs:element name="Note-Demand" sql:relation="XBL_Notes" sql:element-name-field="ClassName">
    <xs:complexType>

    &lt;!-- ... --&gt;
    

    </xs:complexType>
    </xs:element>
    <xs:element name="Note-Clause" sql:relation="XBL_Notes" sql:element-name-field="ClassName">
    <xs:complexType>

    &lt;!-- ... --&gt;
    

    </xs:complexType> …

    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. Reinvestigate tempdb, it's issues and how we use it as a scratch pad

    The tempdb system database, as we all know is becoming "overused", and thus is more frequently becoming a bottleneck.

    I know we are recommending multiple data files, trace flags, etc in white papers dedicated to this subject. Those recommendations do improve matters, but ultimately we can still have a bottleneck there. Think about all the activity in the transaction log being generated due to row-versioning, sorting, online DBCC checks, temp tables, etc, etc, etc. And the database catalog having to be maintained, etc.

    We also have the commonly documented issues of collation problems and TDE.

    All these issues are becoming…

    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. cannot access native client configuration

    Hi,

    We typically install only one SQL server which is to be accessed by one or more clients.

    Our software applications are using the 'SQL native client' to access the SQL server database. So we only install the 'SQL native client' for these systems. However, now we cannot review, modify or access the native client configuration as can normally be done by running the SQL server configuration manager. But the server configuration manager gets only installed when installing the SQL server itself, not when installing the client.

    We need to be able to configure the 'SQL native client' configuration when…

    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 17 2009 6:12PM=-=>

    Thank-you for reporting this enhancement recommendation to us. We are currently investigating what options are available and how we can enhance the user experience.

    To help us identify the configuration experience you are looking for, when you say that you want to configure the SQL Server Native Client, are you referring to something along the lines of cliconfg.exe? Or, are you referring to ODBCAD32.exe?

    Regards,
    Jimmy Wu
    Microsoft SQL Server

    <=-=Dec 18 2009 12:03AM=-=>

    Although I am not familiar with the tool cliconfg.exe, it looks like this tool is meant to be used for configuring SQL Server 2000/MSDE?

    What I need is a way to configure the way ADO connects to SQL server with the SQL native client 2005 or SQL native client 2008 if this client was installed by means of the the available ‘sqlncli.msi’ windows installer packages.

    - Is there…

  9. Logging Report Model usage in the ExecutionLog

    Currently, when Report Builder is used to access a published report model in reporting services (2005 & 2008) a usage record is created in the ExecutionLog reporting Services database table, however it does not identify the specific Report Model that was accessed - the ReportID in the ExecutionLog / ExecutionLogStorage table references the root-level item in the Catalog table regardless of which Report Model is accessed.

    The main problem with this is that because the specific Report Model being accessed is not recorded in the execution / usage log, there is no way of identifying which specific Report Models are…

    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 →
  10. Add data type to Properties window for plan operator

    When I look at the output list of a plan operator, the properties for a column under the Output list have Column (redundant?), alias, Database, Schema, and Table. I would like to also see data type here (and collation for string values). I am guessing it has been left out because it would be difficult to determine implicit vs explicit conversion, vs. data type of underlying column(s), but I think it would be useful to see this where possible so that we can quickly gauge why a scan went out of control (e.g. varchar vs. nvarchar, or collation a vs.…

    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

    <=-=Jun 29 2009 11:08AM=-=>

    Dear Aaron Bertrand

    Thank you for the feedback. The show plan xml and the properties window do not contain the datatype presently. We look at adding this field in the properties window. I have marked this issue for consideration by the product team.

    Thanks,
    -Karthik

  11. Enhance copy and paste package behavior to include assigning new IDs to new package AND all its components

    In Integration Services, copying and pasting packages to enable reuse does not currently assign a new GUID to the pasted/new package. Additionally, the pasted/new package componets also are not assigned new GUIDs.

    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. Windows Fileshare Report Delivery

    Fileshare deliveries from subscriptions in Reporting Services require user and password. As an administrator to reporting services it would be helpful if a stored system account of sorts could be used.

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

    <=-=Dec 29 2008 2:37PM=-=>

    Thanks for filing this enhancement request through connect.
    We will consider incorporating this in a future release of reporting services.
    Thanks

    <=-=May 14 2009 10:36AM=-=>

    Another enhancement that I would like to see is that where users should be able to change the network credentials used in report subscriptions in one central location.

    Currently when users setup windows file share subscription for report they have to enter their network credentials. Now when the users network password changes they have to go to every subscription they ever created and set the new password. This is cumbersome and users are resisting users the product for good reason.

  13. Reporting Services Shared Subscriptions

    The Shared Schedule feature of Reporting services works really well. However the more we have worked with the tool we have come across the need for a new/additional feature.

    In a similar fashion the ability to manage "Shared Subscriptions" would help to manage delivery of multiple reports simultaneously. Email and file shares across multiple reports could be changed through one interface as opposed to every single report.

    This feature is key to departmental and functional reporting that is either sent to large distributions or consumed by other applications.

    Thanks!

    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. Securing SQL server against SQL injection attacks

    I have found that securing the following objects within SQL server can effectively stop most if not all SQL injection attacks. By default SQL logins are granted select access to the following: Sysojects, Syscolumns. If an SQL server login is denied select on these objects the attack it stopped in its tracks.

    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 →
  15. Debugging in BIDS

    Can't debug code in BIDS. Can't set breakpoints in the Report's Code area. Can't inspect/watch the Expressions in a object to see why it's not working.

    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

    <=-=Oct 30 2008 9:15AM=-=>

    Thank you for using SQL Server Reporting Services.
    We woudl like to improve the coding/debugging expereince and we will investigate this for a future release but we do have to balance against the general report authoring features which a majority of customers use and wish enhancements for.
    Thank you for your time and your patience.

  16. Make code in BIDS a first class citizen

    Accessing a report's Code section or an object's Expression is too clumsy. Additonally, there's no Intellisense either. I might as well be editing the RDL in Notepad!

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

    <=-=Oct 30 2008 9:14AM=-=>

    Thank you for using SQL Server reporting Services.
    The coding experience is an area we would like to improve and we will investigate further for the next release. With that said there are a lot of other features/improvements customer would prefer over improving the coding experience.
    Thank you for your time.

    <=-=Dec 30 2009 6:23AM=-=>

    Agreed – a report’s custom code really should be editable in a normal Visual Studio code editor window with full Intellisense support.

    Similarly, when making references to custom code functions in an expression it would be a great help to have Intellisense support for the function.

    <=-=Nov 20 2010 12:03PM=-=>

    I think having something similar to SSIS .net script task would be ideal. I’m looking forward to Denalit CTP2 (with hopefully SSRS changes included!!)

    Regards
    Emil

  17. Make Subreport a page break-able object too

    I just developed a series of reports where 3 separate reports had to be rendered as a single report for the same group item. Although I worked around the issue by nesting groups off of the same parent and enabling a page break for each group; it would have been a much more natural solution for me to have simply checked a box on the subreport's properties telling it to do so.

    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

    <=-=Oct 30 2008 4:15PM=-=>

    Hello,

    Thanks for filing this request. We may consider this for a future release. For now, an easy workaround is to put the Subreport inside of a Rectangle, and set the page break on the Rectangle.

    Thanks,
    Chris B.
    SQL Server Reporting Services

  18. Intellisense for custom code

    It would be great to have intellisense for custom code.

    We are in the process of releasing a custom assembly to help development teams with common report writing issues. Developers have gotten so used to having the intellisense they can't seem to do without it.

    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

    <=-=Jun 19 2009 11:28AM=-=>

    Thank you for posting this feature request. We will consider adding intellisense for custom code in a future release of Reporting Services. Since you mention developers, I’m assuming that you mean we should integrate this into BIDS (Report Designer), not Report Builder. If not, please do clarify. Thanks.

  19. Make UnknownMemberName and AttributeAllMemberName attribute properties instead of dimension properties.

    I think user-experience would improve if these two properties were associated with attributes instead of with the dimension.

    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. Adding Database Mirroring Dependencies

    Currently database mirroring does not provide for inter-database dependencies. In many cases an application requires more than one database to function correctly on the same server. While creating high availability solutions for customers a common question is frequently asked? How many databases does your application require to function correctly and can your application work correctly if the databases were on separate servers? In many cases application can not function correctly on separate servers leading customers to SQL Clustering.

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

SQL Server

Categories

Feedback and Knowledge Base