Jorg Klein's Blog

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

My employer Macaw gave me the opportunity to attend the SQL PASS Summit this year, so I am traveling to Seattle tomorrow!

SharePoint Online and Power BI have a lot of attention and focus lately, but what about the on-premises version of

The last few years Microsoft’s strategy was all about cloud first (or cloud only?), releasing new BI products and updates

The Power BI Analysis Services Connector can be used to connect from the Power BI service to your on premises

What is a Data Lake? Pentaho CTO James Dixon is credited with coining the term “Data Lake”. As he describes

SQL Server Analysis Services (SSAS) Multidimensional (MD) is a great product, and in my opinion it’s still the only real

Last week Microsoft released CTP3 of SQL Server Integration Services (SSIS), code name: Denali. In this blog post I will

We recently had a few customers where a connection to Oracle on a 64 bit machine was necessary. A quick

In my last blog post I explained the principles of Replication Services and the possibilities it offers in a BI