This message was deleted.

sparse-intern-71089

06/12/2023, 7:04 AM

This message was deleted.

echoing-dinner-19531

06/12/2023, 9:41 AM

sql db on which provider? There's probably a resource property, but can't go look at docs unless we know what sql resource your using.

clever-addition-88333

06/12/2023, 10:33 AM

We use sql server in azure

clever-addition-88333

06/12/2023, 10:41 AM

I would like to turn off the createindex in the red frame:

clever-addition-88333

06/12/2023, 10:42 AM

With pulumi on db create

echoing-dinner-19531

06/12/2023, 10:50 AM

I think you can do this with azure-native and the DatabaseAdvisor resource: https://www.pulumi.com/registry/packages/azure-native/api-docs/sql/databaseadvisor/ I don't think it supported for the old azure provider.

clever-addition-88333

06/12/2023, 10:55 AM

Thanks, I will try it out.

clever-addition-88333

06/12/2023, 11:36 AM

yes. The Databaseadvisor did the work. Thank you 🙂 - Example:

Copy code

var databaseAdvisor = new AzureNative.Sql.DatabaseAdvisor("sqlDatabaseAdvisor", new AzureNative.Sql.DatabaseAdvisorArgs
        {
            ResourceGroupName = resourceGroup.Name,
            ServerName = server.Name,
            DatabaseName = database.Name,
            AdvisorName = "CreateIndex",
            AutoExecuteStatus = AzureNative.Sql.AutoExecuteStatus.Disabled,
        });

🙌 1

Open in Slack

Previous Next

Pulumi Community

No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.