Relative Content

Tag Archive for azureazure-sql-database

Azure SQL Database instance is public

We just created an instance of “SQL Server” in Azure (not Azure SQL) and did a portscan to discover that the server was not private but public – anyone in the world could access port 1433.

Azure “SQL Server” instance is public

We just created an instance of “SQL Server” in Azure (not Azure SQL) and did a portscan to discover that the server was not private but public – anyone in the world could access port 1433.

How to Execute DB scripts to multiple Azure SQL DB

I have more than 100 plus SQL Database in Azure PaaS Component, the challenge what i am facing currently is execution of DB Scripts to all the databases takes time, is there a tool where i can execute the DB Scripts to all Azure SQL Server Database, current SKU which i am using is DTU Based

Nextjs Azure SQL Authentication

I’m building a fullstack application using NextJs and Azure SQL database. The database is Microsoft Entra-only authentication. I’m using NPM packages mssql for querying the database and @azure/msal-browser and @azure/msal-react for single sign on. For both dev (localhost) and production which is Azure Web App Services, I get this error message error: ConnectionError: Login failed for user ‘ ‘

Cant import a database into Azure?

I have exported a database which is about 200 G using the Azure portal . I saved it into a storage account. The bacpac file created is about 12 G.
The database is set to Standard S9: 1600 DTUs.
When i import i selected 1750 DTU and 1T of storage.