User Profile
luistorres
Brass Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Is Encoding SQL_ASCII and Collation en_US.1252 supported in Azure Flexible Server PostgreSQL?
BabatundeDallas I created the database using the encodings UTF8, then I created the Collation 1252 in the database. Internal customer tested read/write with the ASCII fat client and works without issues CREATE DATABASE "test-dev-002" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' LOCALE_PROVIDER = 'libc' IS_TEMPLATE = False; CREATE COLLATION "English_United States.1252" (provider = icu, locale = "English_United States.1252"); highlighted: library C and Template0 needed for creating the database1KViews0likes1CommentRe: Is Encoding SQL_ASCII and Collation en_US.1252 supported in Azure Flexible Server PostgreSQL?
I am migrating a database from Azure PostgreSQL Single server to posgreSQL Flexible Server and the application is using en_US.1252 this is the definition of the database in single Server CREATE DATABASE "database_name_here" WITH ENCODING = 'UTF8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252' TABLESPACE = pg_default CONNECTION LIMIT = -1 IS_TEMPLATE = False; I was able to create the database using this SQL sentence, but not sure yet if I will get application errors CREATE DATABASE "database_name_here" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII' C_COLLATE = 'C' LC_CTYPE = 'C' LOCALE_PROVIDER = 'libc' CONNECTION LIMIT = -1 IS_TEMPLATE = False;1.2KViews0likes3CommentsIs 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.4KViews0likes5CommentsTransaction 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?337Views0likes0CommentsRe: Can you create an SQL database table with columns via an Azure ARM Template?
Yes, you can. ARM templates can have multiple resources. ARM template syntax is a little bit complex, for that reason I use Bicep for coding and then export the ARM template or deploy it directly from Azure CLI2KViews0likes0CommentsError 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.4KViews1like1CommentRe: Using Forms as a front end for a database
I am following this post because I have a small project as well. I don't have Power Apps in my list of tools because I am not sure if all the users that are going to access the forms must has a license in Microsoft, and second the users need access to Internet for accessing the Power Apps hosting and the Power Apps host connects to On-premises database, which is a lot of network traffic, I know that a form has very small foot print regarding to network traffic. I think Power Apps is more suitable for all the layers online, web host and database. I am reading about .Net MAUI and I like it because the code can be deployed for Desktop and Mobile and, it is easy to code a form. One point for Power Apps is security, hosted and maintained by Microsoft, while .Net MAUI is deployed to a folder so the form will be accessed in the office only.26KViews0likes0CommentsRe: According to Microsoft SQL Server configuration best practices, what should you do to configure cach
ngbeken1monday 1. According to Microsoft SQL Server configuration best practices, what should you do to configure caching on volumes that host log files? Enable read caching only. 2. You plan to deploy Microsoft SQL Server 2019 to an Azure virtual machine that has eight CPUs and four disks. You expect that SQL Server will run tempdb heavy-workloads. You need to optimize the performance of tempdb. What should you do? Store tempdb in eight files of the same size. Enable trace flag 1117 3. You need to ensure that the virtual machine disks hosting the database and log files provide predictable latency. The solution must minimize costs. Which disk type should you use? Premium SSD 4. To implement multi-factor authentication (MFA) for Azure SQL Database, you can authenticate by using Azure AD. Yes 5. You manage a SQL Server 2019 instance that hosts a single user database. The instance runs on a Windows Server 2019 server. You need to be able to create a user in the user database. The solution must NOT have a corresponding SQL Server login. From the user database, enable partial containment. 6. You can control access to database objects by using schemas. Yes 7. You can configure authentication to an Azure SQL database on the database level. Yes 8. You need to assign a permission that grants the right to view data within an object. The solution must use the principle of least privilege. SELECT 9. You need to implement a database-level firewall rule for an Azure SQL database. the Azure portal 10. You need to implement Transparent Data Encryption (TDE) for an Azure SQL database. The solution must use your company’s internal certificate. Azure Security Center (I am not sure, if this is the right one) 11. You need to ensure that network traffic from an Azure virtual network to an Azure SQL database uses the Azure backbone network only. Private Link 12. The default masking rule presents the same output for string, number, and date values. No 13. You are creating an Azure Monitor alert rule on an Azure virtual machine that hosts a Microsoft SQL Server instance. an action group 14. You need to identify the Performance Monitor metric that demonstrates CPU pressure. Which metric should you identify? System\Processor Queue Length (No Sure) 15. Which three types of information can you identify by using Azure SQL Database Query Performance Insight? Each correct answer presents part of the solution. the highest resource consuming queries the highest long running queries 16. the query IDs for top resource consuming queries and long running queries When using Dynamic Thresholds of Azure Monitor alerts, you must provide the value of the threshold for the metric that triggers the alert. No 17. You need to analyze the read/write latency for the data and transaction log files of a SQL Server that runs on an Azure virtual machine. The solution must use the least amount of administrative effort and provide statistics for database files. the Azure portal 18. By default, Query Store contains every query executed by Azure SQL Database. No 19. When creating an index, you reduce the likelihood of fragmentation by setting a high fillfactor value. No (No sure) 20. Fragmentation applies to both clustered and nonclustered indexes. Yes 21. You need to use Transact-SQL to perform a full database restore. After the restore, you will restore the transaction logs. WITH NORECOVERY 22. A full backup contains the transaction logs. No 23. With the simple recovery model, you can restore transaction logs. No 24. You have an Azure virtual machine that runs Windows Server 2019 and hosts a SQL Server 2019 instance. You plan to automate the full back up of databases by using the SQL Server Automated Backup v2. What is the maximum frequency that can be configured for the backups? Every 12 hours I chose the longest in the options but really full back frequency options are Daily or Weekly 25. You plan to implement SQL Server on an Azure virtual machine. Which database can you store on drive D? tempdb 26. You need to grant the most permissive permission to a database view. Which permission should you grant? ALTER 27. You can trigger the execution of an Azure logic app as a response to an Azure Monitor alert. Yes 28. When you run Microsoft SQL Server on an Azure Linux virtual machine, you must install additional software to capture metrics similar to those provided by Windows Performance Monitor. No 29. A deadlock in Microsoft SQL Server requires an administrative action to be resolved. No20KViews0likes1CommentSQL 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,7.2KViews0likes0Comments
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