THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 7 (70 total posts) < 1 second(s)
  • 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
  • Use AdlCopy to generate U-SQL jobs that copy data between Azure Blob Storage and Azure Data Lake Store

    AdlCopy is a command-line tool (it runs on the users machine) that allows you to copy data from Azure Storage Containers or Blobs into Azure Data Lake Store. You can use the AdlCopy tool in two ways: Standalone, where the tool uses Data Lake Store resources to perform the task. This can be a cheap and more ad-hoc/manual option to move data ...
    Posted to Jorg Klein (Weblog) by jorg on June 27, 2016
  • Setup Azure Data Lake Analytics federated U-SQL queries to Azure SQL Database

    One of the major value propositions of U-SQL is that it allows to query data where it lives. For external systems, such as Microsoft Azure SQL Database, this is achieved with federated queries against data sources. &nbsp; &nbsp; In order to query these external data sources, a data source object has to be created and referenced that ...
    Posted to Jorg Klein (Weblog) by jorg on June 17, 2016
  • See you at the PASS Summit 2015 in Seattle!

    My employer Macaw gave me the opportunity to attend the SQL PASS Summit this year, so I am traveling to Seattle tomorrow! Im excited to be there this year because there are so many new technologies being pushed in our direction like the Cortana Analytics suite and SQL Server 2016. At the moment I am already involved in some PoC/pilot ...
    Posted to Jorg Klein (Weblog) by jorg on October 23, 2015
  • SharePoint Server 2016 IT Preview from a BI point of view

    SharePoint Online and Power BI have a lot of attention and focus lately, but what about the on-premises version of SharePoint thats used in almost all serious BI solutions today? Well SharePoint Server 2016 IT Preview has just been released by Microsoft, by many stated as the last on-premises version of SharePoint ever. In this blog post I will ...
    Posted to Jorg Klein (Weblog) by jorg on August 28, 2015
  • re: BI on your terms with SQL Server 2016

    Hi Nacho, I recently attended a session from a SQL Server MVP about SQL 2014 and he told me adding the MSDB to an AlwaysOn Group should be possible from SQL 2014. I had some contact with him about this matter and he told me this was probably in a CTP version of SQL 2014 because it is indeed not possible anymore in SQL 2014 today. So you are ...
    Posted to Jorg Klein (Weblog) by jorg on June 3, 2015
1 2 3 4 5 Next > ... Last »
Privacy Statement