↓ Skip to main content

Azure SQL Server

Multi-Tenancy

Multi-Tenancy

·10 mins
What Is Multi-Tenancy? “Software Multitenancy refers to a software architecture in which a single instance of a software runs on a server and serves multiple tenants. A tenant is a group of users who share common access with specific privileges to the software instance. With a multitenant architecture, a software application is designed to provide every tenant a dedicated share of the instance including its data, configuration, user management, tenant individual functionality and non-functional properties. Multitenancy contrasts with multi-instance architectures, where separate software instances operate on behalf of different tenants” (Wikipedia)
How to export all tables to csv by one export job

How to export all tables to csv by one export job

·1 min
If you just want to export all the tables in a SQL database in to separate CSV files, then this is a quick and easy way of doing it. Execute below query which generates BCP commands SELECT ‘bcp ‘ + st.NAME + ‘ out c:\Target\’ + st.NAME + ‘.csv -c -r -d ‘ + DB_NAME() + ‘ -U user@??????.database.windows.net -S tcp:?????.database.windows.net -P ?????? FROM sys.tables st Paste the result set into text file. Make batch file and schedule it. (It can also be run in CMD manually)
Allow access to Azure services, what does this actually mean?

Allow access to Azure services, what does this actually mean?

·1 min
I did some quick research on the SQL Server Firewall “Allow Access to Azure Services” option in Azure today. And I sorry to say that my fears were right, that by setting this option does pose a significant security risk and leaves the SQL Server vulnerable.