HomeAzure Synapse Analytics/SQL DWAzure SQL Data Warehouse

Comments

Azure SQL Data Warehouse — 14 Comments

  1. Hi James

    We are looking into using the azure DW as dev/test environment for our on-prem APS.
    Can tsql, ddl and ssis/pdw destination adapter be used directly without any rewrite?
    Thanks
    Peter

    • Hi Peter,

      I can’t say for certain yet, but there should be no changes needed in tsql and ddl. Not sure of the SSIS adaptors yet, but shoot me an email and I’ll find out for you.

  2. Hi James,

    Couple of questions for you, maybe you’ve come across some information that can shed light on this 🙂

    1. I’m guessing that since Azure SQL Data Warehouse includes PolyBase, it is implied that it can simultaneously query traditional star-based warehouse data AND data residing in an Azure Data Lake, and combine it’s results and visualize it in e.g. PowerBI? That would be so sweet.

    2. Have you seen anything with regards to migrating an existing on premises MS SQL 2008 warehouse directly into Azure SQL Data Warehouse, and treat it as a known baseline for subsequent analytics?

    3. Also, what about combining traditional warehouse data, raw data in an azure lake, and ad-hoc data from third party APIs? I’d like to be able to perform ad-hoc analytics based on not only my own data in a warehouse and a lake, but also the data coming from multiple third party aggregators, but _not_ have to write custom API clients to copy the third party data into my lake first.

    Cheers,
    Linus

    • Hi Linus,

      1. PolyBase can query Azure SQL Data Warehouse, Hortonworks HDP, Cloudera CHD, and Azure HDInsight and the results combined in Power BI. It seems very likely that PolyBase can query Azure Data Lake but I have not heard for sure yet
      2. The migration from a data warehouse in MS SQL 2008 would be the same to either APS on-prem or Azure SQL Data Warehouse
      3. This sounds like a good future use case for PolyBase – being able to query data from third party APIs. Unfortunately it’s not there yet

  3. Hi James,
    Recently I learned fundamentals of Machine Learning on Microsoft Azure when I had 1 month free access.
    The question I wan to continue to use the platform for Learning but it sounds to be expensive for the subscription. Could you suggest me the best way to go about it. My aim is not make it expensive but I am ready to pay reasonable amount to use the platform.
    Thanks in advance
    Vijay

  4. Pingback:SQL Server 2016 | Garrett Edmondson

  5. Pingback:Copying data from Azure Blob Storage | James Serra's Blog

  6. Pingback:Getting data into Azure Blob Storage | James Serra's Blog

  7. Magnificent goods from you, man. I’ve have in mind your stuff previous to and
    you’re simply too great. I really like what you’ve got right here, certainly like what
    you are stating and the best way by which you assert it.
    You make it enjoyable and you still take care of to stay it smart.
    I can not wait to learn far more from you. That is really a terrific site.

  8. Pingback:Data loading into Azure SQL Data Warehouse - SQL Server - SQL Server - Toad World

  9. Pingback:Data loading into Azure SQL Data Warehouse | James Serra's Blog

  10. Hi James,

    Can we consider Azure SQL DW as the cloud version of APS ? Recently in a MS led training , the instructor mentioned that it is NOT so but unable see any major difference between the two of them except cost and that APS has compute and storage coupled while it is de-coupled in Azure SQL DW. This would really help me to understand and then position the 2 accordingly.

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>