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. SMSS 17.8 & 17.9 crash on tabular and cube

    SMSS 17.8 & 17.9 crashes as soon as I click on a tabular or a cube database. This is always and repeatable.

    Problem details show a: System.NullReferenceException.

    SQL Server Build 13.0.4522.0 (2016 SP1 CU8 or CU9).

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

    We’ll send you updates on this idea

    6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. UTF-8 in SQL 2019: Install fails with "Could not find the Database Engine startup handle." if a Unicode-only Collation is selected

    In SQL Server 2019 CTP 2.1 it became possible to select a UTF-8 Collation to be the Instance-level Collation. While the Installer UI does a good job of preventing one from selecting an invalid combination of Collation properties, it does allow one to select a Unicode-only Collation (i.e. a Collation that does not have a non-Unicode 8-bit Code Page, hence it reports that the Code Page for such a Collation is "0"). When selecting a Unicode-only Collation, the UI does properly indicate that both the "Supplementary characters" and "UTF-8" options are assumed to be selected (see attached image). These two…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. Give us option to not have square brackets when drag&drop in SSMS

    When we drag something from OE into a query window, then the identifier will always be enclosed in square brackets. Many of us do our due diligence and take care to use identifiers that do not require separators. These separators makes SQL code (a lot) harder to read, and we feel that we are punished with these square brackets. We don't want to do a search and replace all over and over again, when there could just be a setting in SSMS to not generate these.

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

    We’ll send you updates on this idea

    21 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. SQL Agent job move steps

    When using SSMS 18 Preview 6 & 7, there is a bug when you move a step in a sql agent job.
    If I click on one of the move step arrows, either up or down, I get the following error:
    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Index was out of range. Must be non-negative and less than the size of the collection.
    Parameter name: index (mscorlib)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. After SSMS Update to v17.8.1 I get Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal

    Don't really use replication server, so I didn't think this fit into that category, but the update to SSMS certainly messed up something....

    After updating my SSMS from v17.7 to v17.8.1, I get the following error. I also have Visual Studio Professional v15.7.5 and SQL Server 2017 Developer Edition. Yesterday, uninstalled SSMS, repaired VS v15.7.5, and reinstalled SQL Server 2017 Developer, which took forever, but everything seemed to run fine. I was up and running and then I usually restart my machine when I leave and when I logged in this morning, I'm getting this error again (I'm assuming the…

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

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Defect in DacFx extracting a DacPac with nullable persisted computed columns

    We are having issues with schema compare with visial studio 2017 (15.8.5) whereby comparing a dacpac with a null-able persisted computed column on a table is presententing a difference when in my opinion it shouldn't.

    Please see attached scenarios for examples where this issue is apparent.

    I have added the defect to github.com for your convenience so that you can run through the scenarios:

    https://github.com/fenngineering/sql2016-nullable-computed-column-defect
    Thanks

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. Could you also unlock TDE for the Standard Edition? Due to new legal regulations in DE/EU (General Data Protection Ordinance), many databas

    Could you also unlock TDE for the Standard Edition?

    Due to the new legal regulations in the DE/EU (General Data Protection Ordinance), many databases should be encrypted.

    For many small/medium sized companies it is impossible to switch to Enterprise.

    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 →
  9. SSMS 17.5 Intellisense not working for Azure Server

    I am running SSMS 17.5 and attaching to an Azure server with 35 Databases and over 50 users.

    If I connect to a local DB intellisense works fine. On the Azure server there is nothing. No Intellisense at all. It is turned on (TextEditor -> IntelliSense -> Enable Intellisense) and working against other servers.

    My questions are:

    Could this be a bug in SSMS 17.5?
    Is there a setting in SQL server to disable Intellisense queries?

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

    We’ll send you updates on this idea

    8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. Unable to horizontal scroll Results pane via mouse wheel in SSMS

    My mouse has a horizontal scroll wheel. I can use the horizontal scroll in the Query pane, but if I select the Results pane, I can't scroll horizontally using my mouse. If I scroll to the left by dragging the scroll bar, and then try to use the horizontal scroll wheel on my mouse, the Results pane snaps to the leftmost position.

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

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. The DELETE key does not work as expected when trying to rename a database object in Object Explorer.

    The DELETE key does not work as expected when trying to rename a database object in Object Explorer. The BACKSPACE key works correctly.

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

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. SQL Management Studio Copy Database Wizard Broken

    Copy Database Wizard is not working for local copy operation. v17.5 There are previous bug reports when trying to copy a SQL201x -> SQL2017 DB using management studio 17.x . However, it appears you cannot copy a SQL2017-SQL2017 DB as well using the same wizard using the SMO option when copying without taking the DB offline. ERR: Property HasMemoryOptimizedObjects is not available for Database '[test]'
    File attached

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSMS 17.3 Font and Color setting limit changes to 4 areas

    After upgrading to ver. 17.3 of SSMS 2017, I am unable to enlarge the default font size used for grids or the object explorer (Environment Font). After running a search I several posts in the SQL Server Forum, but after trying the fix mosts sided, which was uninstalling 17.3, then install 17.2 and do the upgrade to 17.3. This was ineffective for me and others.

    Under "Show settings for:" instead of listing all the options that should be listed, I see only the following. This is obviously a bug. Has anyone found a solution that fixes this problem?

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

    We’ll send you updates on this idea

    5 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. new TRANSLATE function syntax not recognized by SSMS 17.3

    The new TRANSLATE function is not recognized as valid syntax by SSMS 17.3 intellisense, though it executes just fine against SQL Server 17 instances. The TRANSLATE syntax is underlined in red with the warning "'TRANSLATE' is not a recognized built-in function name"

    Tested against SQL Server 17 RTM.

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

    We’ll send you updates on this idea

    completed  ·  6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. SSMS v17 - Object must implement IConvertible. (mscorlib)

    When a query is selected with the mouse/keyboard, and then "Analyze Query in Database Engine Tuning Advisor" option in the context menu is selected the following error appears.

    "The argument type 'server type = Sql, server name = KSHQ-DB, timeout = 30, database = KSH_Cloudcare, protocol = NotSpecified, workstation = , integrated security = True' cannot be converted into parameter type 'Microsoft.SqlServer.Management.Common.SqlConnectionInfo'. (mscorlib)
    Object must implement IConvertible. (mscorlib)"

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

    We’ll send you updates on this idea

    8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. SSMS Install with SQL Server 2016 causes Device Manager conflict on VS location sensor driver

    If you take (as an example) a clean machine, with no VS or SQL Server yet, install SQL Server 2016 (say community but doesn't matter), Device Manager is fine, no conflicts (no VS location sensor driver yet)...Then you install SSMS (production/GA version 16.5.3), you get a Device Manager conflict (yellow exclamation mark/can't load driver error) on a new sensor entry called "Microsoft Visual Studio Location Simulator Sensor".

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. Problem when filtering jobs with the Job Activity Monitor on SQL Server 2014

    I'm getting an error every time that want to filter the Executing jobs and set the View refresh settings to n seconds (5 seconds in my case). The filter works fine while there are jobs executing but once all the jobs finish their execution then the Job Activity Monitor window throws the following exception:
    ===================================

    Index was out of range. Must be non-negative and less than the size of the collection.
    Parameter name: index (System.Windows.Forms)

    ------------------------------
    Program Location:

    at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
    at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
    at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorUserControl.WorkerEntryPoint(Object o)
    After that exception the Job…

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. SSMS Intellisense shows useless parameter names for functions like REPLACE, SUBSTRING

    For functions like REPLACE, SUBSTRING, etc., the Intellisence shows the parameters as Expreession1, Expression2, etc. instead of useful parameter names like Expression, Pattern, Replacement. g (max. 5000 Zeichen)

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

    Hello

    In both SSMS 17.9.1 as well as SSMS 18 Preview 6, both REPLACE and SUBSTRING functions show meaningful hints.
    For REPLACE we show – expression_to_be_searched , search_expression, replacement_expression .. etc.
    For SUBSTRING, we show expression, starting_positionm length etc.

    If you are using older versions of SSMS, please update to the latest version as we are currently not supporting any versions older than 17.9.1.

    thanks,
    Dinakar

  19. SSMS 2016 does not remember added SQL Snippets folder

    You can add your own snippets in SSMS bij using the Code Snippet Manager.
    In the Code Snippet Manager window you have the possibility to add a folder containing customer snippets by using the "Add..." button.
    This works fine as long as you're not closing SSMS. After restarting SSMS you have to add the folder again because it is no longer available in the snippets.

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

    We’ll send you updates on this idea

    23 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. Make Scalar UDF with no data access running parallelly

    There are different scalar-value UDFs:
    - (1) Interpreted T-SQL UDF,
    - (2) Natively Complied T-SQL UDF and
    - (3a) CLR UDF with DataAccessKind.None, which is default option.
    - (3b) CLR UDF with DataAccessKind.Read.

    For CLR UDF, if its USERDATAACCESS = 0, then it�s not a parallel plan blocker.
    For other type of UDF, even we use WITH SCHEMABINDING option, and USERDATAACCESS = 0, it�s still a parallel plan blocker.

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base