Erland Sommarskog

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  2. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 25

    <=-=Jan 25 2017 1:14PM=-=>

    There is risk that an evil DBA (who is about to get fired) can lock down a server entirely, by setting up a trigger which you cannot disable, because the trigger does not permit DISABLE TRIGGER. For this reason, there needs to be a hole, but that hole should only be open when the server is running in single-user mode. (Or started with a trace flag that diables the trigger for DISABLE TRIGGER). The current behaviour is not acceptable.

    Erland Sommarskog supported this idea  · 
  3. 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  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog supported this idea  · 
  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  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  5. 298 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    42 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    From Apr 24, 2019 (https://cloudblogs.microsoft.com/sqlserver/2019/04/24/sql-server-management-studio-ssms-18-0-released-for-general-availability/):
    Think of these two tools not as separate tools doing different things, but as one integrated tool. Each tool has different experiences built into it and can be launched from the other seamlessly.

    From Oct 20,2020 (https://cloudblogs.microsoft.com/sqlserver/2020/10/20/sql-server-management-studio-18-7-now-generally-available/):
    SQL Server Management Studio is a foundational tool for many working with Microsoft data solutions. First released in 2018, Azure Data Studio is a cross-platform and open source desktop environment for data professionals using the Azure Data family of on-premises and cloud data platform solutions. Architecturally, SQL Server Management Studio has long been combined with additional tools, including Profiler, Database Engine Tuning Advisor (DTA), and Database Mail. As Azure Data Studio continues to mature, the Microsoft data tools experience on Windows has become a combination of SSMS and Azure Data Studio. Beginning in the 18.7 release of SQL Server Management Studio, Azure Data Studio…

    Erland Sommarskog supported this idea  · 
  6. 172 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  19 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog supported this idea  · 
  7. 8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog supported this idea  · 
  8. 517 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog supported this idea  · 
  9. 519 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    23 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Erland Sommarskog commented  · 

    It would also be cool to have a shortcut to execute the current batch.

    Erland Sommarskog supported this idea  · 
  10. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  11. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  12. 10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog supported this idea  · 
    An error occurred while saving the comment
    Erland Sommarskog commented  · 

    Here is a repro for the bug:
    CREATE TABLE TM5ProjectProperty_history (id int NOT NULL,
    property varchar(40) NOT NULL,
    value sql_variant NULL,
    SysStartTime datetime2(0) NOT NULL,
    SysEndTime datetime2(0) NOT NULL,
    )

    CREATE TABLE TM5ProjectProperty (id int NOT NULL,
    property varchar(40) NOT NULL,
    value sql_variant NULL,
    SysStartTime datetime2(0) GENERATED ALWAYS AS ROW START NOT NULL,
    SysEndTime datetime2(0) GENERATED ALWAYS AS ROW END NOT NULL,
    PERIOD FOR SYSTEM_TIME (SysStartTime, SysEndTime),
    CONSTRAINT pk_TM5ProjectProperty PRIMARY KEY (id, property)
    )
    WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.TM5ProjectProperty_history))

    CREATE CLUSTERED INDEX history_table_ix ON TM5ProjectProperty_history(SysStartTime, SysEndTime)
    CREATE INDEX pk_ix ON TM5ProjectProperty_history (id, property, SysStartTime, SysEndTime)
    go

    CREATE TABLE #prop (id int NOT NULL, property varchar(40) NOT NULL, value sql_variant NULL, PRIMARY KEY (id, property))
    INSERT #prop(id, property, value)
    SELECT /* TOP (10) */ object_id, name, system_type_id
    FROM sys.columns
    go
    MERGE TM5ProjectProperty a
    USING #prop p ON p.id = a.id AND a.property = p.property
    WHEN NOT MATCHED BY TARGET THEN
    INSERT (id, property, value)
    VALUES (p.id, p.property, p.value)
    WHEN MATCHED AND a.value <> p.value THEN
    UPDATE
    SET a.value = p.value
    ;

    go
    ALTER TABLE TM5ProjectProperty SET (SYSTEM_VERSIONING = OFF)
    DROP TABLE TM5ProjectProperty
    DROP TABLE TM5ProjectProperty_history
    DROP TABLE #prop

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

    We’ll send you updates on this idea

    27 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 72

    <=-=Mar 10 2016 11:26AM=-=>

    It’s a shame that this was submitted as just a “suggestion”. It should actually be listed as a “bug” because there’s only a comparatively small set of use cases where enumeration of the result set of elements is not important.

    <=-=Mar 11 2016 12:47PM=-=>

    I agree that an order column is required; one example use case is where two lists are passed in, and ordinal positions in one list correspond to positions in the other.

    <=-=Mar 11 2016 3:12PM=-=>

    Please see the related suggestion: STRING_SPLIT needs “RemoveEmptyEntries” option, like String.Split in .NET ( https://connect.microsoft.com/SQLServer/feedback/details/2462002/ ).

    <=-=Mar 12 2016 12:02PM=-=>

    This kind of function is primarily needed for de-serializing previously serialized arrays of values of any type format-able as text.
    I therefore recommend to have the result set of this function work excellent with this use-case.

    With de-serialized arrays there is a need to…

    Erland Sommarskog supported this idea  · 
  14. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  15. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  18. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog shared this idea  · 
  19. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Erland Sommarskog commented  · 

    It could be argued that the call could be wrapped in an EXECUTE AS statement and REVERT. However, an error may occur during execution of the procedure, so that the REVERT statement is not executed, which can lead to confusion if you don't observe that you are the impersonated user.

    Erland Sommarskog supported this idea  · 
  20. 291 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Erland Sommarskog supported this idea  · 
← Previous 1 3 4 5 6

Feedback and Knowledge Base