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. Pivot Function

    The pivot function needs to be improved to not require knowledge of the columns beforehand. Access had this feature a long time ago and sometimes you don�t know what the columns will be in advance.

    2 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 →
  2. Allow SQL Agent jobs to be scheduled using UTC time

    SQL Server 2008 has introduced UTC based date/time data types. However SQL Agent jobs can still only be scheduled using the server's local time.

    Often there is a requirement to have a job run at a fixed time and not to move based upon daylight savings changes. Being able to select a schedule based on either server time or UTC time would allow the flexibility to schedule the job exactly when it needs to run and not have to make changes to schedules/jobs whenever daylight savings time starts or ends.

    2 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

    <=-=Mar 7 2011 1:11PM=-=>

    Thank you for proposing a DCR for our component. We will consider it as a part of our next major release.

    Thanks,

    Alex Grach

    <=-=Mar 1 2013 11:24AM=-=>

    Hello

    We took a look at this DCR along with several others. Unfortunately triaging it against other critical DCRs I do not think we would get to investigate and implement this in the near future, so we decided not to proceed with this DCR in the next SQL Server release.
    However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this implemented.

    Thanks for writing to Microsoft.
    Alex Grach (MSFT)

    <=-=Dec 8 2017 5:19AM=-=>

    Hello,

    Any update on this issue?

  3. A Better Collision-Free Hash Function for Comparing Rows of Data

    This is a request for a new function which would accept input column names similar to CHECKSUM, with an additional hash algorithm name parameter, and generate a hash value using a collision-free hash algorithm. A common business case for this enhancement is for change detection in BI solutions, such as updating Slowly Changing Dimensions.

    SQL Server has long supported a function known as CHECKSUM, which takes string values or column names as input and returns a hash value generated by a simplistic proprietary hash algorithm. Because of its problems, a new collision-free hash function should be introduced that will allow…

    2 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: 38

    <=-=Nov 28 2009 10:48AM=-=>

    There was a question about the statement above that CHECKSUM can produce different hash values dependent on the platform (32-bit or 64-bit). Here are some simple tests to demonstrate this:

    —First test query:
    SELECT CHECKSUM, CHECKSUM;
    —Results on SQL 2008 32-bit: 2306, 2306
    —Results on SQL 2008 64-bit: 554584078, -1626451698

    —Second test query:
    WITH CTE
    AS
    (
    SELECT 65 AS c
    UNION ALL
    SELECT c + 1
    FROM CTE
    WHERE c < 90
    )
    SELECTCHAR + CHAR,
    CHECKSUM + CHAR),
    COUNT
    FROM CTE c1
    CROSS JOIN CTE c2
    GROUP BY CHECKSUM + CHAR)
    HAVING COUNT > 1;
    —Results on SQL 2008 32-bit: 244 two-letter combinations of ‘AA’ – ‘ZZ’ produce duplicate checksums
    —Results on SQL 2008 64-bit: 0 two-letter combinations of ‘AA’ – ‘ZZ’ produce duplicate checksums; checksums generated are different from 32-bit checksums

    —Third test query:…

  4. XQuery functions fn:starts-with() and fn:ends-with() against the xml data type

    the functions fn:starts-with() and fn:ends-with() will be very helpful for wildcard search on XML string values.
    Using these functions comparison logic as in the relational cases <value> LIKE 'ABC%' and <value> LIKE '%XYZ' can be easy specified. Otherwise it is difficult to express this kind of comparison.

    2 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

    <=-=Dec 7 2009 2:28PM=-=>

    Thanks for your request. We are gathering asks for such specific XQuery functions and will add them based on customer requests and available resources. Until we have added this, the current workaround is to use the value() method to extract the value and perform the like predicate in SQL. If it is needed as a filter in a path, you would need to use the nodes() method to break the path open to insert the relational filter.

    Cheers
    Michael

  5. Add sys.indexes create_date and modify_date fields

    My company needs a way to easily identify when an index was created. It would also be useful to know when an index's ddl was last modified.

    2 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: 28

    <=-=Jan 15 2009 2:43PM=-=>

    Hi Brian,
    Thanks for your request. We are aware of your ask and we will consider it for a future version of SQL Server. For now, you can create DDL trigger and track the index creation/alter in your own tables. This will allow you to get the information you are looking for.


    Umachandar, SQL Programmability Team

    <=-=Dec 3 2009 7:55AM=-=>

    I’d also like to throw some support around this as something to include in the next version of SQL Server

    <=-=Dec 3 2009 7:59AM=-=>

    I’d like to see thes as well. I’d also add that seeing last rebuild date and last reorg date would be helpful as well, even if they were via function like STATS_DATE().

    <=-=Dec 3 2009 8:04AM=-=>

    Upvoted as I think this is definitely something that needs to be added. In addition to adding this, please add a related report…

  6. string aggregate function, something like SUM for numbers

    I wonder why the list-function in Sybase, which exists for more then 15 years, is never built by other database suppliers:
    I wish I had an aggregat function for strings. So that, instead of crawling through the table with a cursor, I could easily just write:

    select idCompany, Companyname, AGG_CONCAT(Name, ';')
    from Company inner join Contact on Company.idCompany =
    Contact.idCompany
    group by Company.idCompany, Company.Companyname

    Just like for numbers, with SUM or so.
    An then I get a nice comma-separated list:

    "Handelshaus Huber"; "Schmidt, Meier, Huber"
    "Waschk�che Weier"; "Widmann, Wenzel"
    etc.

    How about that ? Would be great!
    Liz

    2 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: 11

    <=-=Jan 8 2009 11:48AM=-=>

    Hi,

    Thank you for your feedback. This is a good point and we will take it into consideration for coming releases of SQL Server.

    Currently there is one simple workaround that may work for you, it is not as simple as a string aggregate function would be and is not related to the GROUP BY clause but it at least solves your problem (note that the solution works in both SQL Server 2005 & 2008).
    Consider the following example using the AdventureWorks sample database:
    SELECT
    soh.OrderDate
    ,(
    SELECT
    p.Name + ‘, ’
    FROM Production.Product AS p
    INNER JOIN Sales.SalesOrderDetail AS sod ON p.ProductID = sod.ProductID
    WHERE sod.SalesOrderID = soh.SalesOrderID
    FOR XML PATH(’‘), TYPE
    ).value(’/‘, ’NVARCHAR(max)’) AS ProductsOrdered
    FROM Sales.SalesOrderHeader AS soh

    Hope this helps!
    /Tobias Ternstrom

    <=-=Jun 2 2009 3:25AM=-=>

    I strongly support this suggestion. From BOL I can see that there might…

  7. MSFT - Maddog: Arithmetic overflow error should link properly in SSMS

    I've got a big long query that takes forever to run, and occasionally it gives me an arithmetic overflow error message. There's tons of counts, sums, avgs, etc. in the query, so it's not obvious where the error is coming from. I've got each "column equation" on a seperate line, but the arithmetic overflow error message is basically useless - "there was an error somewhere, we don't know where.". Normally for error messages in SSMS, I double click on them and it takes me to where the problem is - not for arith overflow; it just takes you to the…

    2 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

    <=-=Dec 21 2008 5:24PM=-=>

    Hi,

    Thank you for your feedback. This is a good point and we will take it into consideration for coming releases of SQL Server.

    Thanks!
    /Tobias Ternstrom

    <=-=Mar 17 2011 4:53PM=-=>

    Hello,

    Thank you for submitting this suggestion, but we’re trying to clean house and remove items we feel we will likely not address given their priority relative to other items in our queue. We believe it is unlikely that we will address this suggestion, and so we are closing it as �won�t fix�.

    This cleaning will help us focus on the high-priority items that we feel need to get done, and we hope that it help provide better clarity to you about the issues we will (and won’t) address.

    While we’ve tried to look at each of these items individually, this was a large effort, and so we may have erred in assessing…

  8. Add digital signature to a pdf document in Reporting Services

    (EN) I want to digital sign a PDF create by exporting a Reporting Services' Report to PDF, but there is no way to do that. Can this be possible?

    (ES) Quiero a�adir a un PDF al generar una exportaci�n a PDF de un report de Reporting Services, pero no veo que se pueda hacer. �Ser�a esto posible?

    2 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: 25

    <=-=Nov 24 2008 4:25PM=-=>

    Hello,

    Thans for writing in with this feature request. SSRS does not provide a way to digitally sign its PDF output out-of-the-box. We have a feature request for this on file. So, I’ve resolved your request as a duplicate of the one that we already have in our database. We hope to add this feature in a future release.

    I encourage the community to continue to vote on this feature if there is demand for it!

    Best regards,
    Chris B.
    SQL Server Reporting Services

    <=-=Sep 13 2011 3:07AM=-=>

    Helo,

    I would like to add a request that, I also need the e signature feature from SSRS support for WORD also.

    Thanks
    Bala

    <=-=May 21 2014 10:07AM=-=>

    Hi,

    I would also like to see this feature available in SharePoint integrated mode.

    Regards,
    Mark

    <=-=May 2 2017 3:46AM=-=>

    Hey,

    Yes this feature is required. Pls bring…

  9. MSFT: EDW - Inability to return table-value parameters is restricting usefulness of the feature

    Current implementation requires that TVPs are READONLY.

    This significantly decreases usability of the feature.

    For example, I was going to code a stored procedure "for a given list of paths, give me all databases that have at least one file in this path".

    I was going to pass list of paths as TVP, and return list of databases a TVP.

    But this does not work, so I have to invent workarounds.

    2 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: 15

    <=-=Aug 16 2007 12:58PM=-=>

    Hi,
    Thank you for your feedback on TVP. This is a known current Katmai Restriction and requires substantial additional work to enable output/return parameters. We are planning to address this issue in the next major release of SQLServer. A possible current workaround for this is to use Table valued functions that return table structures back.

    Srini Acharya
    Senior Program Manager, Relational Engine.

    <=-=Feb 13 2009 1:29PM=-=>

    Hi Alexey,
    I have resolved this request as duplicate of feedback item below:

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299296


    Umachandar, SQL Programmability Team

  10. Multi Column Sub Query Support

    Still there is no support for multicolumn sub queries....

    e.g. in oracle....

    Select * from CallDetails where (CustomerID, ProductID) IN (Select CustomerID, ProductID from CustomerGroups Where GroupID=1)

    I was in big trouble when converting queries of oracle financials when I was creating Reporting Server on SQL2005, in Oracle Financials it doesnt have one column primary keys.... almost in all the tables multicolumn primary keys.... same scenario i need to handle when developing ETL and Reporting Layer for Convergys.... Geneva Billing System....

    Scenario is difficult when joining 10...15 tables to retrieve data and almost 3...5 of them needs a sub query…

    2 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

    <=-=Dec 14 2007 4:56PM=-=>

    Thanks for your feedback. We are looking into adding such functionality in a future release. Until then a work around to rewrite the query explictly to use a join syntax is recommended.

    Best regards
    Michael

    <=-=Aug 18 2008 3:10PM=-=>

    Note that the query could be written as

    SELECT * FROM CallDeatils CD WHERE EXISTS (SELECT * FROM CustomerGroups CG WHERE CG.CustomerID = CD.CustomerID AND CG.ProductID = CD.ProductID)

    There are other situations where the need for row constructors is more compelling, though.

    <=-=Mar 23 2010 2:03PM=-=>

    Hi,
    I have resolved this feedback item as duplicate of one below:

    https://connect.microsoft.com/SQLServer/feedback/details/299231/add-support-for-ansi-standard-row-value-constructors?wa=wsignin1.0


    Umachandar, SQL Programmability Team

  11. Need true timeStamp data type to automatically update the update time (instead of update trigger)

    We all know that the TIMESTAMP datatype is a sequence number having nothing to do with time. It's very common to have a column "Update Time Stamp" indicating the time of the last update. Currently you need to do this with an update trigger. It would be nice to have a TIMESTAMPReally datatype with the same exact semantics as the rowversion type/ TIMESTAMP datatype - but instead of inserting a sequence number, a true time stamp is inserted. Obviously you could use TIMESTAMPReally in time comparisons.

    SQL Server can automatically populate DateTime fields on insert (via DEFAULT GetDate() …

    2 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

    <=-=Jan 27 2009 3:14PM=-=>

    Why not just use a non-nullable datetime column with a GetDate() default? Like this:

    CREATE TABLE TestTS
    (Col1 int,
    Col2 datetime NOT NULL DEFAULT GetDate()
    )

    INSERT TestTS (Col1)
    SELECT 1

    SELECT * FROM TestTS

    <=-=Jan 27 2009 3:22PM=-=>

    Hey Aaron – that only works on insert, not on updates.

    <=-=Jan 27 2009 6:48PM=-=>

    Oooo, yes. That’s painfully obvious, isn’t it? I missed that part of your post. Are you requesting this for auditing, or concurrency control?

    <=-=Jan 28 2009 10:11AM=-=>

    Auditing. It’s possible but far more work to make a time stamp a sequence # for concurrency. I’m only asking for time.

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

    Hi,
    Thanks for your request. You do not need a trigger to maintain the updated timestamp. You can use the DEFAULT keyword in your UPDATE statements like:

    UPDATE tbl
    SET
    , ModifiedTime = DEFAULT

    Using explicit…
  12. Package Concepts, Global Variables

    Hi,

    I like to see the Package concepts like in Oracle, in which we can declare the variables and then use in the multiple stored procedures in the package.

    This will be lot helpful in breaking the big stored procedures into small ones.

    Please consider the request in future release

    2 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

    <=-=Nov 13 2007 5:05PM=-=>

    Hi Vijay

    Thank you for your feedback. The concept of global variables and the ability to ‘package’ stored procedures and modules is very useful functionality. We are considering it for a future SQL Server release.

    Sara Tahir
    Microsoft SQL Server

    <=-=Nov 19 2007 9:24AM=-=>

    Hi Sara,

    Thanks for your info. Can you let me know which release of SQL Server that it is planned.

    Thanks & Regards

    Vijay Anand Kannan

    <=-=Dec 19 2007 9:36AM=-=>

    Hi Vijay,

    At this point of time, we havent decided on which release of SQL Server we will add this. Unfortunately this will not be in SQL Server 2008 but we will definitely consider it for the release after that.

    Thanks,
    -Vineet Rao.

    <=-=May 20 2008 12:22PM=-=>

    Hi,

    Can you please let me know if you have any plan for the implementation of the package.

    Thanks & Regards

    Vijay Anand…

  13. Automatically register SPN for Analysis Services

    The SQL Server Database engine automatically tries to register an SPN for itself. It would be nice if Analysis Services did the same - it would simplify configuration in a lot of cases.

    2 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. Add New Folder Function in Visual Studio Reporting Services

    In Reporting Services 2005 Visual Studio Business Intelligence Project, there is currently no feature to add a new folder in order to group developed reports.

    2 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

    <=-=May 3 2009 9:11AM=-=>

    Thank you for using SQL Server Reporting Services.
    We will review this for a future release. Enhancing the usage of solution explorer and generally maanagment of of project and solution files is something that is planned but time and exact scope have not been worked out.
    Thank you for your patience.

  15. Support bcp out/in and bulk insert compressed (or named pipe support at least)

    Using zippipe from http://jcarlossaez.spaces.live.com/blog/cns!B3378F057444B65C!108.entry I attempted to do a bcp out to a named pipe that was zlib compressed. This worked fine. However, just like the author stated, I ran into trouble trying to do a bcp in or bulk insert using the compressed named pipe. It also doesn't work for non-native bcp out.

    I'm running SQL 2005 SP2 and I compiled ZipPipe with zlib 1.2.3.

    Compressed bcp support would be excellent to save disk space, I/O, and time just like the compressed backup feature does for SQL 2008. It would be great to have some way to do this.

    2 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: 8

    <=-=Apr 11 2008 9:46AM=-=>

    Thank you very much for your feedback. We have had other requests for compression and use of standard input and ouput by bcp recently and we will take them all into consideration for a future release of SQL Server. Unfortunately it’s to late to consider this request for SQL Server 2008.

    <=-=Mar 23 2010 7:40AM=-=>

    It’s probably not the type of feature in scope for 2008 R2 either, but this would be an excellent feature for the next full release of SQL server.

    <=-=Nov 23 2010 2:04PM=-=>

    Any movement on this in the last 2 1/2 years?

  16. BCP enhancements

    This is referring to bulk import and export between files and SQL tables. My requests are that BCP can read from STDIN and write to STDOUT, that BCP and BULK INSERT can read files in standard compression formats, and that BCP can output data in standard compression formats. The next request I'm not too sure about, but I think it is valid. My understanding of BCP and BULK INSERT is that the file-side of the operation is doing buffered I/O but the table-side, being managed by SQL Server, is unbuffered I/O. Can BCP and BULK INSERT support a new option…

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

    Thank you very much for your feedback.
    These are all very reasonable suggestions. The feature set for SQL Server 2008 is now frozen but we will give them serious consideration for inclusion in a future release of SQL Server.

    <=-=Dec 16 2011 6:44PM=-=>

    Include the snapshot agent while your at it. It needs it just as much as any of the other tools.

  17. Formatting SQL otion

    Hi,

    When we write complex T-SQL query it could be difficulet to read it.
    Formatting is very important to help in this way.

    Regards,

    Laurent

    2 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 →
  18. bcp and stdio

    A useful enhancement to the bcp program would be support for STDIN and STDOUT where actual file paths are currently required. So that commands like the following would be possible:

    Input
    gzip -dc "path\myTable.txt.gz" | bcp myDB..myTable in - T -f "path\myTable.fmt"

    Output
    bcp "SELECT * FROM myDB..myTable" queryout - -T | gzip -c - >myTable.txt.gz

    or to output a huge table to multiple files
    bcp "SELECT * FROM myDB..myTable" queryout - -T | split -d -l 10000000 "path\myTable.txt."

    I saw this suggested in a few different ways while SQL 2008 was in development and the response was agreement that…

    2 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: 17

    <=-=Nov 20 2009 2:50PM=-=>

    Hi,
    Thank-you for your feedback and feature request for the BCP.exe utility. We are investigating the best way to address your scenario. We will post an update once we have something concrete.

    Regards,
    Jimmy Wu
    Microsoft SQL Server

    <=-=Nov 21 2009 12:48PM=-=>

    The ability to pipe input and output with the BCP command would greatly enhance automation for applications that I support. We use similar techniques for other DBMS systems since the bulk loading utilities support the capability. The example above which shows the use of compression tools in conjunction with BCP are just the beginning.

    <=-=Nov 15 2012 9:05AM=-=>

    Any updates on this? Saving data to a slow disk completely defeats the purpose of a bulk copy facility. Postgres has had this feature for years.

    <=-=Jun 26 2013 6:03AM=-=>

    1) Many GNU programs accept – (dash) filename which means “use stdio”. bcp…

  19. SSRS 2008 export formulas to Excel

    As per books online - http://msdn.microsoft.com/en-us/library/ms143380.aspx , support for exporting RDL expressions to Excel as formulas has been dropped in SQL 2008.

    2 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: 92

    <=-=Oct 20 2009 2:24PM=-=>

    Hello,

    Thanks for writing in with this feature request. We will consider this for a future release of Reporting Services. I have resolved your request as a duplicate of one we alread have on file for this feature, and linked the requests together so we do not lose track of it. I encourage the community to continue to upvote this feature request if there is demand/need for it.

    Best regards,
    Chris B.
    SSRS Team

    <=-=Apr 20 2012 9:13AM=-=>

    Yes Chris there still is a need for this!

    <=-=Jul 18 2012 11:17PM=-=>

    Any word on whether this is going to be included in a future version?

    <=-=Oct 24 2012 6:39AM=-=>

    This is the single largest reason why my clients choose other reporting solutions, instead of SSRS. Group aggregations (SUM, AVG) not exporting to Excel (the most basic functionality) still is ignored…

  20. Data Masking

    Data masking (also known as data scrambling, data anonymization and data Obfuscation) is the process of replacing sensitive information copied from production databases to test or
    non-production databases with realistic, but scrubbed, data based on masking rules.

    Data masking is the process of protecting sensitive information in non-production databases from inappropriate visibility. After sanitization, the database remains perfectly usable - the look-and-feel is preserved - but the information content is secure.

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

    <=-=Aug 31 2009 1:31PM=-=>

    Hi,

    Thank you for your feedback. We understand that datamasking is an important feature and we will consider providing the feature in a future release of SQL Server. In the meantime, similar results can be achieved by using the Data Generation Plans feature of VS Team Server Database Edition, creating a SSIS package, or through the use of views and custom CLR funtions that will mask the data.

    Il-Sung.

    <=-=Jan 10 2013 6:29AM=-=>

    Hi,

    Has this feature been added in SQL Server 2012?

    Thanks
    Rakesh

    <=-=May 9 2013 6:00PM=-=>

    Hi, unfortunately this did not make it into SQL server 2012 but we are tracking this for future version of SQL Server.

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base