This message was deleted.
# dotnet
s
This message was deleted.
e
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.
c
We use sql server in azure
I would like to turn off the createindex in the red frame:
With pulumi on db create
e
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.
c
Thanks, I will try it out.
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