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

    Please add a DATEADDBIG function with a "number" input parameter that takes a signed bigint value. This would be to match the DATEDIFFBIG function.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support TODO comments in SSDT Visual Studio Database Projects

    In Visual Studio SSDT Database Project T-SQL code show comments starting with "--TODO" in the Error List as Warnings or in the Task List.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSMS 2018 Database Diagrams - Display Only

    I, among many others, was dismayed to find that Database Diagrams were discontinued in SSMS 18.

    My organization's documentation processes are based on SSMS diagrams, which we have counted on since SQL Server 2000.

    We do not use the diagrams for database design. We use them to support our team of developers by giving them a visual representation of what is in our databases. (I do database design brainstorming in an old copy of Visio 2010 installed on a VM. I can type column names in a DDL script as fast as I can type them into a GUI designer.)

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Deliver SQL Server Management Studio in Microsoft store on Windows 10

    Our company uses Intune to manage devices, including PCs. With this we can establish Azure AD role-based deployment of software to devices. This is particularly easy via the Windows Store for business; any app in the store can be automatically deployed to all users with a certain Azure AD role.

    One complaint we often hear from our developers, QA testers, etc. is that there's too many things to install to do their job - it takes far too much time. One item on this long list is SSMS. If it were accessible via the store, anyone in the Azure AD…

    14 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. ssms startup is particularly slow

    ssms startup is particularly slow

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

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. New feature: Pin files in SQL Server Management Studio

    I'd like to be able to pin files to the "Recent Files" list in SQL Server Management Studio, the way you can in Microsoft Word.

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. ssas tabular 1400 web connector

    The new compatibility level 1400 of SSAS allows you to use on M Query language to define the Data Source of your Model.

    In a way this is the alternative to the Content Packs on Power BI online.

    You can develope your Tabular Data Model with Power BI desktop and then implement it on SSAS without having to recode your queries with SSIS.

    MS Excel or Txt files are accepted but always as local file only.
    My issue is that todays SSAS 1400 accept JSON File as a Data Source but only local files.
    Json is typically return by web…

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

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Any table column should be able to be hidden

    HIDDEN as a column property is currently only allowed on the system-generated columns in Temporal tables. I think any column should be hidable, so that columns can be added with improved backward compatibility. It would also allow expressions to be added as computed columns and then indexed without changing the results of SELECT *, as in https://connect.microsoft.com/SQLServer/feedback/details/566418/indexes-on-expressions

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. SSRS without having to install a VM

    I and likely many others really don't want to have spin up an entire VM with all the extra bloat (and MASSIVE costs) just to be able to run reports. Especially when we're using Azure SQL services to host our database.

    Even if it's a bit scaled down or something, please bring back Reporting without a VM

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSDT diagrams

    Database documentation is as paramount as it gets in terms of database development.

    SSDT should include a robust diagram experience with the ability to comment tables and fields.

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

    We’ll send you updates on this idea

    4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Make it possible to force plan in Query Store even if you are using table variable with Clustered index

    A Query containing a table variable with clustered index will not use the forced plan in Query store, because the name of the index will be different for every execution.

    Please make it possible to reuse the forced plan or possible to name the clustered index.

    13 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. Extended Event wait_info should report microseconds instead of millisecond duration

    The wait_info extended event should report microseconds instead of millisecond duration. This is required for inmemory low latency performance tuning.

    The rpccompleted-event returns microseconds already. It would be great (more precise and consistant) if waitinfo duration would return the same unit.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. View client connection properties from the server.

    Currently there's no way to see whether a user arriving at the database is connecting by instance name or port number, or by server name, ip, or alias.

    Being able to see this would make it simpler to plan migrations / detect deviations from a standard without causing unwanted disruption.
    More info: http://dba.stackexchange.com/questions/151410/find-sessions-connected-by-ip

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Mar 13 2017 6:35AM=-=>

    Hi,
    Thanks for the suggestion. We’ll be tracking to see how much interest this generates. We could consider the idea of auditing this information if it can easily be ascertained and there is high demand for this requirement.

    Thanks
    —Ronit.

  14. Sort Environment Variable Drop Down List

    When using Management Studio (2014) to configure an SSIS parameter so that it uses an environment variable, the resulting drop-down list shown on the "Set Parameter Value" dialog box is not sorted. With a lot of environment variables it becomes difficult to find the one you want to select.

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

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add Query IO Stats Roll Up To Query Plans

    When you get an actual execution plan in SSMS, the root operator has a QueryTimeStats attribute where you can view CPU and Elapsed Time for your query as a whole.

    There are also IO stats per operator, but no roll up at the root node. It would be handy to have this, similar to SET STATISTICS IO ON, so you would know which operators to dig into based on table reads.

    Right now, you have to click around to figure anything out, and that can be painful in large execution plans.

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Increase the maximum number of user connections from 32k to 64-128k

    For large transaction databases 32k of user connections sometimes is not enough. Moreover, SQL Server doesn't have in-built tools to limit user connections by user types (permissions) so when it runs out of connections the entire instance is getting into bad state when SQL Agents jobs doesn't run, monitoring tools can't connect and admins are limited by one connection only.
    Increasing this this number allows more vertical scaling.

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

    We’ll send you updates on this idea

    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Use UTF-8 encoding for error log files on all operating system

    At this time SQL Server on Windows encode the error log files using UTF-16 while on Linux (at least on Ubuntu) it uses UTF-8 to encode the error log files. This result in incompatibility when we need to work with logs from different operating system.

    For example,
    (1) when we develop application using .Net we might need to use the following command, which specify the encoding:
    "string allText = File.ReadAllText(unicodeFileFullName, Encoding.UTF8);"
    The above commend will not fit to log file which was created on windows, and if we will choose to use utf16LittleEndian which fit the logs from windows, then…

    12 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. Add an index on plan_persist_wait_stats.plan_id to improve performance when pruning query store data

    We are consistently seeing one of the query store cleanup queries showing up in our worst performing queries.

    DELETE sys.planpersistwaitstats WHERE planid IN (SELECT planid FROM sys.planpersistplan WHERE queryid = @query_id)

    When I look at the indexes defined on the query store table, it comes back with two indexes neither of which are on plan_id:

    planpersistwaitstatscidx - runtimestatsintervalid, planid, waitcategory, executiontype

    planpersistwaitstatsidx1 - waitstatsid

    It would be beneficial to have an index on plan_id in order to reduce the amount of system resources required to prune the query store wait stats.

    12 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 →
  19. Add Data Compression to Create New Index Window in GUI

    It would be nice to have the option to choose data compression directly from the Create Index window when creating an index using SSMS. Currently you would have to either script it and then add the Data_Compression = to the script, or you would have to go back after the fact in the GUI to compress. It could be added to the "Options" tab or the "Storage" tab as a drop down with "Row" or "Page".

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. I like a system DMV to tell me when the last time a stored procedure was executed

    I like a system DMV to tell me when the last time a stored procedure was executed

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base