high level understanding of setting up an azure database

db042190 1,516 Reputation points
2023-05-04T16:47:53.02+00:00

Hi, this is a very high level question. Let's say we don't even have an azure account yet. Are these the basic steps in getting to a point where we've stood up a db in azure? The db i have in mind is what is called an ODS which is an operational data store. It isn't a front end. It is not a warehouse. Its a very small window of data used for running a certain aspect of the business.

  1. my boss sets up an account. Does he bring his credit card? what other info does he need to have with him?
  2. my boss or someone he designates picks one of what looks like many choices for configuring that db.
  3. my boss adds "tenants" who are the people (like me) allowed to do certain things with that db. will i need to know power shell etc etc or can i use ddl etc i already know for creating tables , dbs , test queries etc etc? what permissions will the person who sets this up need to give me? will i need a separate email address on our email server? will i need an email address at all on our email server?
  4. we use ssis or factory to feed data to that db incrementally. are the same creds/accounts what we use to buy the privilege of using factory? i have to admit i dont know what the advantage of factory is over ssis. i've used ssis in the past to get data in and out of azure but its blurry. but what info will ssis or any other product need for connecting to azure from on prem and is there an install (.net?) for such plumbing to work?

from what i remember emails play an important role in all of this. and from what i saw recently 2 factor auth is going to play a part in all of this .

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,806 Reputation points MVP
    2023-05-04T17:52:16.09+00:00

    I am trying to answer your questions:

    1. Your boss needs to perform some Account administrator task including associating credit cards with the account. Please read here for a list of tasks.
    2. Here you will steps to create an Azure SQL Database and how to create tables on it.
    3. There are some fixed database roles in Azure SQL and one of them is the loginmanager role that allows to create logins and users that can access the database. Please read about this role here and how to add members to that role.
    4. Here you will find how to connect to Azure SQL to do administrative tasks and run queries, create objects (stored procedures, tables, etc.). Here you will find steps to connect to Azure SQL from SSIS. Here you will find how to connect to Azure SQL using Azure Data Factory (ADF) and copy data to the database. Here is a comparison of SSIS vs ADF to choose what is best for your organization. Finally, you can also connect from .NET apps to Azure SQL as explained here.
    0 comments