Some highlights of the Summer 2017 refreshes for Azure Data Lake Analytics and U-SQL: GZip on OUTPUT, Catalog Views, DiagnosticStream in .NET user code, Major updates to Cognitive Libraries, Tool support to create your EXTRACT statement

We have been very busy over the summer and released several refreshes whose release notes I finally found time to publish on our Azure Data Lake blog. Instead of providing a detailed list, which you can find on the Azure Data Lake blog post which in turn will take you to the detailed release notes…

0

Some highlights of the March and April 2017 U-SQL refreshs: PIVOT/UNPIVOT, Sharing across ADLA accounts, U-SQL Packages, fast file sets, new default numbers of HASH DISTRIBUTION buckets, easier C# integration with CROSS APPLY

The last two Azure Data Lake refreshs in March and April brought a lot of interesting new capabilities in U-SQL. You can find the details by following the two links to our Azure Data Lake blog posts above which in turn will take you to the detailed release notes on our Azure Data Lake GitHub…

0

February Azure Data Lake Refresh will complete deprecation for old “PARTITION BY BUCKET” and credential DDL syntax in U-SQL

In the upcoming February refresh, we will be turning some deprecation warnings into errors. Please make sure that you and your customers are aware of the changes and are updating your scripts if necessary. Note that none of these changes should affect jobs that are running already created tables or external data source queries. But…

0

How do I combine overlapping ranges using U-SQL? Introducing U-SQL Reducer UDOs

The problem statement A few weeks ago, a customer on stackoverflow asked for a solution for the following problem: Given a log file that contains time ranges in the form (begin, end) for a user-name, I would like to merge overlapping ranges for each user. At the time I promised to provide a solution using…

0

I am back on my MSDN blog talking about Big Data, Azure Data Lake and U-SQL

Hi all It has been several years since I last blogged on my MSDN blog. Partially because I have been working on things I could not really blog about, partially because the many changes to the blogging infrastructure lost my log-in account connection. Now I got it back, as – as some of you probably…

0

Update on SQL PASS 2007 Presentations

I am giving 3 presentations at SQL PASS 2007 in Denver: Wednesday, September 19th, 9:45am to 11am, room 709:DBA-317-M The Next Release of Microsoft SQL Server: Beyond Relational(co-presenting with Kevin Farlee) Main focus will be the new features in the areas of unstructured and semistructured data management in SQL Server 2008. Wednesday, September 19th, 1:30pm…

1

SQL Server 2008 June CTP has been annouced at TechEd 2007

At today’s TechEd 2007 in Orlando, we have annouced SQL Server 2008’s, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! See here for the official scoop and register here! What does this bring for…

0