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. sqlpackage.exe DropObjectsNotInSource overrides options to not drop specific objects

    sqlpackage.exe has the option DropObjectsNotInSource . It's a useful option when that's what we would like.

    However, most times we would like to have some exceptions: avoid dropping some objects. There are many options in sqlpackage.exe to achieve this, the problems is the option DropObjectsNotInSource overrides the options about which objects should be ignored, making this task very difficult.

    I'm able to work around the problem with a custom deployment contributor filter, but just a simple change on how the options are applied would make everything easier.

    1 vote
    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. ssdt needs a default schema compare options

    This was present in old visual studio versions, but not anymore.

    We can still work-around this by saving one compare and never again using new schema compares, always open the saved one, but it would be interesting to have a better way to start the schema compare using default settings.

    1 vote
    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. When you release SSMS you should release it with a better name such as "SSMS-Setup-ENU_REL_18.6_Build_15.0.18338.0_22-JLY-2020.exe" .

    When you release SSM USE THE full name not some abbreviated DOS name. Please use "SSMS-Setup-ENUREL18.6Build15.0.18338.0_22-JLY-2020.exe" where you have all the release, build and date information in the name. The use of the name "SSMS-Setup-ENU.exe" is really not desirable.

    1 vote
    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 →
  4. I would like to see dynamic column headings for SQL queries

    The ability to have dynamic column headings allows me to generate SQL Result Sets with columns that match my data. This would be especially helpful for cross tab queries or things that summarize for a date range

    In Example:

    Declare @Column1 as varchar(10),

        @Column2 as varchar(10), 
    
    @Column3 as varchar(10),
    @Column4 as varchar(10),
    @Column5 as varchar(10),
    @Column6 as varchar(10),
    @Column7 as varchar(10)

    Set @Column1 = Datename( weekday, dateadd(dd, -6, Getdate()) )
    Set @Column2 = Datename( weekday, dateadd(dd, -5, Getdate()) )
    Set @Column3 = Datename( weekday, dateadd(dd, -4, Getdate()) )
    Set @Column4 = Datename( weekday, dateadd(dd, -3, Getdate()) )
    Set @Column5 =…

    1 vote
    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. Query Store - Force Recompile

    It would be useful to have an option in query store to "Force Recompile" for a plan. This would effectively have the engine add an "Option (Recompile)" to the statement to force recompilation each time it is submitted. Use case is where you have very variable data profiles such that forcing a specific plan isn't useful, and you can't change the code (vendor supplied etc.) to add the hint yourself. In these scenarios the overhead of plan recompilation can be minimal compared to the cost of the query when it uses a suboptimal plan (either optimiser determined or forced).

    1 vote
    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. SSRS Web portal, Change default texts

    We have a SSRS Power BI server up and running, branding done to customers satisfaction

    However it is not possible to control the texts used in the below framed sections

    they derive from the language chosen by the user, but even if it is the 'correct' language, we want to change it to something for known to the users

    1 vote
    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. Support for Change Tracking queries in AlwaysOn Secondary replicas

    Change tracking is a great feature for auditing or for capturing the data changes for an ETL process, but there is a limitation that the change tracking queries are not supported in AlwaysOn secondary replicas, If the secondary replicas can support change tracking queries we can leverage the secondary replicas as a data source for the ETL work load.

    1 vote
    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. Distributed database support for SSRS scale-out deployement

    In SSRS scale-out deployment, the SQL Server support shares one common database for the entire RS nodes in the cluster. In a busy reporting environment like ours besides the normal locking and concurrency issues, I have seen bottlenecks in report processing and internal RS cleanup processes (like segment and its child tables cleanups).

    If there is a support for distributed database for the report server database, for example the data and work load is evenly spread across multiple RS databases, there would be a significant improvement in RS performance and would reduce common issues like locking contentions during the Report…

    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 →
  9. Connect to Database option in SQL Connection Prompt of SSMS?

    Show Database selection along with the Server Name in the SQL Connection Prompt SSMS as many of the times it confuses when it needs to go to options and select the database you want to connect or even, when you only want to connect to the master only, then it may confuse the user why it is not connecting. Improving SSMS UX by promoting visibility of connection properties will help a lot.

    7 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 →
  10. Package in T-SQL like Oracle

    Hi Team,
    The Package functionality in Oracle PLSQL is an excellent feature which provides encapsulation. The package will help global variables (including User Defined-TYPE).
    1. Global variables related to a component can be stored and re-used within multiple procedures.
    2. Since there is no ALTER command for TYPE, the TYPE structure can be changed without impacting the multiple objects if the TYPE is used within a same package. As User Defined-TYPE is especially helpful when there are lots of parameters sent into a Stored Procedure.
    3. All the related procedures and functions can be grouped under an umbrella. This will…

    1 vote
    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 →
  11. A dynamic measure (with a calculation) that can be resued for various columns

    In the process of designing a Tabular Model for one of business areas. User has multiple measures that do the same calculation but using different columns so they wanted to make it efficient by creating one Global measure that can be dynamically updated depending on a selection and output the results. This is to reduce the number of measures and use a single dynamic measure.

    Please consider to enable it in the future release as this is important for user

    3 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. Allow a Data Format of "dd Mmm YYYY" for date columns in SSAS tabular model

    Currently it is not possible to select a Data Format of "dd Mmm YYYY" for a date column in a table in an SSAS tabular model. As a workaround, one must create another column that is a data type Text, and which is populated by formatting the date as "dd Mmm YYYY" manually, and then set the new column's Sort By to sort by the original date column. This is not desirable, and is extremely inefficient for models with a large number of date columns.
    Please allow "dd Mmm YYYY" as a Data Format for date columns in SSAS tabular…

    1 vote
    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 →
  13. Make MSOLEDBSQL OLEDB driver support xcopy deployment and registration-free COM

    Short Version

    The MSOLEDBSQL OLEDB COM driver looks for 3 registry entries in HKLM, otherwise it throws an error.

    ```
    HKEYLOCALMACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI18.0\GeneralFlags

    NumberOfFlags: DWORD = 2
    

    HKEYLOCALMACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI18.0\GeneralFlags\Flag1

    Label: REG_SZ    = "Force protocol encryption"
    
    Value: REG_DWORD = 0

    HKEYLOCALMACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI18.0\GeneralFlags\Flag2

    Label: REG_SZ    = "Trust Server Certificate"
    
    Value: REG_DWORD = 0

    ```

    Change the driver to not require these values to be present, and instead accept the default values.

    Long Version

    Windows has shipped with an SQL Server OLEDB COM driver since Windows 2000; it is now a part of the operating system. But it's also been abandoned.…

    1 vote
    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. See statement that produced results from results window

    Results window can contain results from one or more statements. Would be nice to right-click menu "Go to Statement" and jump to the statement that caused the results in the editor

    1 vote
    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. Pop out results window so it can be put on another monitor

    Would be nice to have the results come up on another monitor so you can maximize the space for editing with having to ctrl-R show/hide results.

    1 vote
    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 →
  16. SSMS:Add a Keyboard Shortcut that Executes the Statement where the First Bookmark is placed

    Similar to "SSMS:Add a Keyboard Shortcut that Executes the Statement where the Cursor is placed" it would be nice to quickly execute up to a Bookmark. Then you don't have to click to set the cursor.

    1 vote
    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 →
  17. Moving through Object Dependencies

    A quick idea would be to make it to when you are looking at Object Dependencies, if you right-click on any of the objects, you could move to it. This is for whichever side the dependency is on, be it Objects the Object you chose to View Dependencies under is dependent upon, or Objects that are dependent up it.

    1 vote
    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. 1 vote
    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 →
  19. Better file management in SSMS

    I live in SSMS all day long. I work on development projects as well as respond to numerous inquiries throughout the day. I would like the ability to categorize my files in to projects. Not the lame single project, move my files to a different location current offering.

    Please provide the capability to create a named project and add references to files to that project. And allow me to create as many projects and work with as many projects as I would like at the same time. I can provide much more detail if you are interested.

    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 →
  20. SSMS - modifying object right way and not via sp_executesql

    We, database developers, are using SSMS for modifying objects like stored procedures daily. My routine is to list object in Object Explorer and click MODIFY. What I get is object definition wrapped with sp_executesql which is NOT SUITABLE FOR MODIFYING AT ALL!

    Yes, I have „Check for object existence“ set to True in Options > SQL Server Object Explorer > Scripting. And I want to keep it like that.
    This should not have anything in common with the act of modifying objects. The purpose of modifying is not to script things out but edit the object definition the most comfortable…

    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 →
← Previous 1 3 4 5 210 211
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base