Chrissy LeMaire

My feedback

  1. 23 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 →
    Chrissy LeMaire commented  · 

    +1 to John Martin

    Chrissy LeMaire supported this idea  · 
  2. 103 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Chrissy LeMaire commented  · 

    Can we please get core dlls for CMS Registered Servers? it is one of our most popular commands since cms servers can easily be piped in to any command in the toolset

    Chrissy LeMaire commented  · 

    Yes, please! This is one of our most common requests. Here's what we currently support in dbatools, if there's some sort of priority needed.

    Backup and Restore
    Databases
    Diagnostics and Performance
    Export (Right click -> Export)
    High Availability (Availability Groups and Mirroring)
    Log Shipping
    Login and User Management
    Mail and logging
    Policy-Based Management
    Registered Servers
    Replication
    Resource Governor
    Security and Encryption
    Services
    Snapshots
    sp_configure
    SQL Agent
    SSIS
    Traces, Profiler and Extended Events
    Utilities
    Writing to SQL Tables

    Our most popular commands revolve around migrations and exports of:
    Databases
    Logins
    AgentServer
    Credentials
    LinkedServers
    SpConfigure
    CentralManagementServer
    DatabaseMail
    SysDbUserObjects
    SystemTriggers
    BackupDevices
    Audits
    Endpoints
    ExtendedEvents
    PolicyManagement
    ResourceGovernor
    ServerAuditSpecifications
    CustomErrors
    ServerRoles
    SupportDbs
    AvailabilityGroups
    ReplicationSettings

    Chrissy LeMaire supported this idea  · 
  3. 7 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Chrissy LeMaire supported this idea  · 
  4. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Lab Services  ·  Flag idea as inappropriate…  ·  Admin →
    Chrissy LeMaire supported this idea  · 
  5. 17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Chrissy LeMaire supported this idea  · 
  6. 36 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Hi, thanx for the feedback.
    As Ben points out, if you know which fields on the Database object you need, you can use Server.SetDefaultInitFields to make sure the collection is initialized with all those fields in the first query.

    Is there a particular scenario, using the latest SMO NuGet, where use of SetDefaultInitFields isn’t sufficient to speed up the query noticeably?
    If you have an Intellitrace or XEvents trace I could use for reference it’d be a great help.

    Chrissy LeMaire shared this idea  · 
  7. 30 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Chrissy LeMaire commented  · 

    Looks like we were missing streaming and now got it down to 67 seconds, which is far more reasonable 👍 Would still like a command line version but not as pressing ;)

    Chrissy LeMaire commented  · 

    Got it! 10-15 seconds to load into SSMS 17.4 then 45 seconds to export.

    So 60 seconds total. Our .NET export is still at quadruple that, 240 seconds.

    Chrissy LeMaire commented  · 

    Aw I didn't notice your comment! I'll ask Gianluca, he had the 1gb file.

    Chrissy LeMaire shared this idea  · 
  8. 6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    unplanned  ·  0 comments  ·  Azure Cloud Shell » General  ·  Flag idea as inappropriate…  ·  Admin →
    Chrissy LeMaire supported this idea  · 

Feedback and Knowledge Base