User Profile
luistorres
Brass Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Is Encoding SQL_ASCII and Collation en_US.1252 supported in Azure Flexible Server PostgreSQL?
Is encoding SQL_ASCII with Collation en_US.1252 supported in Azure FlexibleServer PostgreSQL? CREATE DATABASE databaseforme WITH ENCODING = 'SQL_ASCII' LC_COLLATE = 'en_US.1252' LC_CTYPE = 'en_US.1252' IS_TEMPLATE = False; I am trying to create the database but I am getting the error: ERROR: invalid locale name: "en_US.1252" SQL state: 428091.2KViews0likes5CommentsTransaction log General Purpose -Serverless
Based on the Azure SQL Serverless documentation: "Azure SQL Database automatically shrinks transaction log file to avoid excessive space usage that can lead to out-of-space errors. It is usually not necessary for customers to shrink the transaction log file." I have been checking the transaction log file size for a database and the space is never reclaimed. Is the transaction log cleared and reclaimed space with the regular backups? Is the space used by the transaction log charged?334Views0likes0CommentsError BCP109: The type "Microsoft.KeyVault/vaults/secrets" does not contain function "getSecret"
Hi, I am trying to pass the secret value as a secure parameter to a Bicep module, but I am getting the error:Error BCP109: The type "Microsoft.KeyVault/vaults/secrets" does not contain function "getSecret". Code in main. Bicep file resource myVaultSecret 'Microsoft.KeyVault/vaults/secrets@2023-02-01' existing = { name: 'myVault/mySecret' } .... module sqlModule 'sqlserver-module.bicep' = if (databaseService == 'sql') { name: 'sqlDeployment' params: { administratorLogin: administratorLogin administratorLoginPassword: myVaultSecret.getSecret('mySecret') location: location resourceGroup: resourceGroup serverName: serverName servicePlanSku: servicePlanSku sqlDBName: databaseName subcription: subscription tags: tags workloadEnv: workloadEnv } } #end main.bicep code sqlserver-module.bicep file @description('The administrator password for the SQL server.') @secure() param administratorLoginPassword string I am following the instructions based on the document: https://learn.microsoft.com/en-us/azure/azure-resource-manager/bicep/bicep-functions-resource#getsecret Any help will be appreciated !! Thanks1.3KViews1like1CommentSQL Server 2022 compatibility level 160
I have SQL Server 2022 on a Windows Server 2019 server and I can create databases up to compatibility mode 150 (SQL Server 2019), and in a Windows Server 2022 with SQL Server 2022 it allows me to create databases with compatibility mode 160 (SQL Server 2022). Is that right? Is there any reason to allow to create databases with comp mode 160 only in Windows server 2022? Thanks,6.9KViews0likes0Comments
Groups
Recent Blog Articles
Re: Windows Authentication for Azure AD principals for SQL Managed Instance is now Generally Availab
Likely that's the issue: Based on a Microsoft communication:After installing updates released on November 8, 2022, or later on Windows Servers with the domain controller (DC) role, user, computer, ...0likes0Comments