THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 8 (75 total posts) < 1 second(s)
  • Azure Data Lake Store encryption using Azure Key Vault for key management

    Case You want to create an encrypted Azure Data Lake Store (ADLS) with a master encryption key that is stored and managed in your own existing Azure Key Vault. Using this setup, which is showed in the diagram below, all data in your Data Lake Store will be encrypted before it gets stored on disk. To decrypt the data, a master encryption ...
    Posted to Jorg Klein (Weblog) by jorg on July 11, 2017
  • Hybrid-BI data platform network architecture

    This blog post gives an overview of a typical hybrid Azure/on-premises BI data platform network architecture. The most important settings, configurations, shortcomings and other things you should take into account are described. For more details and in-depth documentation links to Microsoft pages are provided at the bottom of this post. The ...
    Posted to Jorg Klein (Weblog) by jorg on March 9, 2017
  • re: Process Azure Analysis Services databases from Azure Automation

    Hi Ryan, If you search your computer for file &quot;SQLASCMDLETS.PSD1&quot;, do you find it in some folder with &quot;140&quot; in the path? If you do, you can take the files from there.
    Posted to Jorg Klein (Weblog) by jorg on February 1, 2017
  • Process Azure Analysis Services databases from Azure Automation

    In my last blog post I showed how to trigger Azure Data Factory (ADF) pipelines from Azure Automation. I also mentioned the option to process an Azure Analysis Services cube from Azure Automation. For example right after your ADF data processing finishes, which will probably be a common use case. In this blog post I show you how you can use the ...
    Posted to Jorg Klein (Weblog) by jorg on January 27, 2017
  • Microsoft Data Platform MVP

    What a great start of 2017! I have received my first Microsoft Data Platform MVP award: Thank you to everyone who felt I deserved this! I am honored to be part of such a great group of experts now and I look forward to collaborate with everybody in 2017. Special thanks to my employer Macaw for always encouraging me to share my knowledge ...
    Posted to Jorg Klein (Weblog) by jorg on January 2, 2017
  • Orchestrate Azure Data Factory pipelines and other Azure Data Platform management tasks using Azure Automation

    Azure Data Factory (ADF) is a great SaaS solution to compose and orchestrate your Azure data services. It works fine to create, schedule and manage your data pipelines but it has limitations that can make it hard to use in some scenarios. The two main ones are: 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Some tasks that you regularly want to perform ...
    Posted to Jorg Klein (Weblog) by jorg on November 14, 2016
  • Azure Data Lake Analytics U-SQL decryption possibilities

    The following information applies to the situation as of October 2016. One of the things that make U-SQL so powerful is C# integration. It gives you the possibility to create your own C# classes and methods and then use them in your U-SQL scripts. Recently we executed a couple of big data projects at Macaw using the Azure Data Lake Store (ADLS) ...
    Posted to Jorg Klein (Weblog) by jorg on October 3, 2016
  • Script Azure Data Lake Analytics assembly deployments to U-SQL Catalog

    Registering your custom assemblies using Visual Studio Data Lake Tools is easy, just right click your U-SQL C# Class Library project, click Register Assembly, fill in the details and your assembly gets published and created in your U-SQL Catalog. But what if you want to script this process to automate your deployments? That is not documented ...
    Posted to Jorg Klein (Weblog) by jorg on September 29, 2016
  • re: Relational Data Lake

    Hi Joel Mamedov, yes it is!
    Posted to Jorg Klein (Weblog) by jorg on September 8, 2016
  • re: Setup Azure Data Lake Analytics federated U-SQL queries to Azure SQL Database

    Creation of the secret can also be performed using the Azure Command Line Interface instead of PowerShell. Instead of using the PS command &quot;New-AzureRmDataLakeAnalyticsCatalogSecret&quot; you can use the CLI command &quot;azure datalake analytics catalog secret create&quot;. CLI syntax: azure datalake analytics catalog secret create ...
    Posted to Jorg Klein (Weblog) by jorg on July 11, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement