Category Archives: Azure

Azure Access Tiers in Azure storage

There are various types and nature of data we store in Azure storage. All kinds of blob data have different accessibility requirements. Sometimes data accessibility reduces over time, whereas accessibility remains the same for some blob data types. There is no point in paying the same price for data that is rarely being accessed or not accessed at all. Azure provides Access Tiers property to address such scenarios and optimize the cost on blobs with less accessibility.

Continue reading Azure Access Tiers in Azure storage

Multi-Tenancy

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)

Continue reading Multi-Tenancy

How to export all tables to csv by one export job

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.

  1. 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
  2. Paste the result set into text file. Make batch file and schedule it. (It can also be run in CMD manually)