Michael Rys

Exploring Big Data and Data Lakes with U-SQL

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...

Author: MRys Date: 10/05/2017

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...

Author: MRys Date: 04/27/2017

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...

Author: MRys Date: 01/24/2017

How to deal with files containing rows with different column counts in U-SQL: Introducing a Flexible Schema Extractor

If your input data is not rectangular in nature, but contains rows with different column counts, the...

Author: MRys Date: 08/15/2016

Some highlights of the August 1st U-SQL refresh: Skipping header rows, Database Level ACLs, improved Extractor framework

We just released some big updates on U-SQL and Azure Data Lake. Check out the U-SQL release notes...

Author: MRys Date: 08/03/2016

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...

Author: MRys Date: 06/08/2016

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...

Author: MRys Date: 06/07/2016

Update on SQL PASS 2007 Presentations

I am giving 3 presentations at SQL PASS 2007 in Denver: Wednesday, September 19th, 9:45am to 11am,...

Author: mrys Date: 09/19/2007

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,...

Author: mrys Date: 06/04/2007

What do you want to see regarding XML support in the next version of SQL Server?

Now that we have shipped SQL Server 2005, I would really like to hear from you what you want us to...

Author: mrys Date: 11/26/2005

Watch out Europe - Here I come...

Tomorrow I will be on my way to Europe for the SQL Server Launch Events in Zurich and Lausanne...

Author: mrys Date: 11/26/2005

SQL Server 2005, MySpace.com and Quiznos: What do they have in common?

Now that we have shipped SQL Server 2005, I am happy to see that people are interested in using it....

Author: mrys Date: 11/16/2005

International SQL Server Survey: Win a portable music player!

The Windows Server System team is doing a Learning and Help survey and need more SQL Server specific...

Author: mrys Date: 11/14/2005

XQuery 1.0 and XSLT 2.0 are now in Candidate Recommendation

Finally, after 6 years of hard work, the W3C has released the Candidate Recommendation specs for...

Author: mrys Date: 11/03/2005

PDC 2005 Videos and Slides and demos are now online

The PDC 2005 videos are now online (via...

Author: mrys Date: 10/27/2005

The light at the end of the tunnel is bright sunshine!

We have RTM'ed today! Today, we have released SQL Server 2005 and VisualStudio 2005 and the .Net...

Author: mrys Date: 10/27/2005

Welcome Jinghao Liu to the Blogosphere

It is my pleasure to introduce you all to Jinghao's weblog. He is our test lead and so far seems to...

Author: mrys Date: 10/14/2005

First Wars, then Tsunamis, Famines and Hurricanes, and now Earthquakes

The last year has been tough on many. Many people have been and are getting killed in wars and...

Author: mrys Date: 10/10/2005

While we are less than a month away from the official launch week of SQL Server 2005, I am still...

Author: mrys Date: 10/10/2005

Changes to the default encoding handling of XML when passing XML from the client to the server.

In SQL Server 2005 versions up to the June CTP, the XML parser on the server-side defaulted to...

Author: mrys Date: 10/10/2005

Why are you searching for "sp_xml_preparedocument Failed load msxmlsql"?

Since we got "upgraded" from .Text to Community server, we are not getting good referrer log...

Author: mrys Date: 10/06/2005

Presentations at SQLPASS 2005 (Grapevine, Tx)

As many others in the SQL Server community, I have travelled to Grapevine, Texas to attend and...

Author: mrys Date: 09/28/2005

The innards of our XQuery implementation

Our VLDB 2005 paper on the innards of our XQuery implementation is now available online. Shankar...

Author: mrys Date: 09/22/2005

The PDC F5 Network Interview is now online

The friendly folks of the F5 Networks Dev Central team interviewed me at PDC 2005. The 5 minute...

Author: mrys Date: 09/22/2005

New XQuery and XSLT Working Drafts: We are making progress!

The XML Query and XSL Working Groups have released the following Working Drafts of XML Query 1.0,...

Author: mrys Date: 09/16/2005

Something for my German speaking audience: Mein Interview mit Martin Szugat

Waehrend TechEd 2005 in Amsterdam hatte ich das Vergnuegen, mich mit Martin Szugat zu unterhalten....

Author: mrys Date: 09/16/2005

News from the PDC 2005: XQuery, LINQ and friends, SQL Server 2005 September CTP

First, we have released the September SQL Server 2005 CTP for download. This is the last CTP before...

Author: mrys Date: 09/14/2005

PDC 2005 XQuery Deep Dive talk outline

Here is the high-level outline of the talk I am planning on presenting. Note that there is lots of...

Author: mrys Date: 09/07/2005

"An invalid character was found" errors when upgrading sp_xml_preparedocument from SQL Server 2000 SP3 to SP4 or SQL Server 2005

Recently, I received several customer reports, that sp_xml_preparedocument started rasing the...

Author: mrys Date: 09/06/2005

Hurricane Katrina: How to help

I am deeply saddened by the suffering of the people in New Orleans and surroundings, South Alabama...

Author: mrys Date: 09/03/2005

Channel 9 and Ken North Videos

I am back from vacation (no shark encounter :-)). I had a good time and have much more photos and...

Author: mrys Date: 08/28/2005

Get your scuba gear for PDC 05 and get ready to dive into XQuery

Get your scuba gear for PDC 05 and get ready to dive into XQuery, because I will be presenting a...

Author: mrys Date: 08/28/2005

Interviewed by Tim Anderson

Tim interviewed me as part of the earlier mentioned wireside chats, and has now published the...

Author: mrys Date: 07/21/2005

XQuery1.0/XPath 2.0 needs your help!

As I mentioned earlier, XQuery 1.0/XPath 2.0 has still one last call issue that that can benefit...

Author: mrys Date: 07/13/2005

The SQL Server XML weblogs are blooming and other "news"

While I have been a bit quiet over the last couple of weeks mainly due to presenting at two...

Author: mrys Date: 07/13/2005

Now is the time to provide feedback on XSLT/XPath/XQuery in .Net!

After long arguments and petitions, Nithya is collecting feedback on what the XML Team should focus...

Author: mrys Date: 06/09/2005

June CTP of SQL Server 2005 has been released: What's noteworthy in the XML area

As Paul Flessner publicly announced at his TechEd 2005 keynote, the world-wide RTM launch date has...

Author: mrys Date: 06/07/2005

TechEd 2005 Tidbits

This posting is aggregating my TechEd 2005 weblog postings. I will update it over the duration of...

Author: mrys Date: 06/06/2005

Recursion and FOR XML

Kent just published an example on how to get recursive XML structures (think employee-manager). The...

Author: mrys Date: 05/11/2005

SQL Server 2000 SP4 RTM released

Finally, all SP4 bugs are fixed and all tests are passing: We have achieved lift off for SQL Server...

Author: mrys Date: 05/06/2005

Do XML Schema collections enable data tampering?

A recent weblog entry by Jim Fawcett that recaps Jon's recap of our wireside chat contains the...

Author: mrys Date: 05/05/2005

More speaking events: TechEd Europe and SQLPASS 2005

Here is an update on two more events where I will be speaking and where I hope to meet some of you:...

Author: mrys Date: 05/03/2005

Material for my MSDN WebCast "Making the Most of XQuery with SQL Server 2005"

You will be able to get the WebCast recording and copies of the slides from the MSDN website...

Author: mrys Date: 04/27/2005

Wireside chats

Last week, I had three one-on-one “wireside“ chats with Tim Anderson, Jon Udell, and Peter Coffee....

Author: mrys Date: 04/26/2005

Do you see "Failed to load Msxmlsql.dll" when using the April CTP with OpenXML?

As part of our improvements on OpenXML, we have changed the MSXML component from 2.6 to 3.0 (running...

Author: mrys Date: 04/23/2005

On "native" XML support in databases

A couple of months ago, I provided feedback on an article on XML support in DB2 written by Philip...

Author: mrys Date: 04/21/2005

How to use base64 encoding in SQL Server 2005

Kirk Allen Evans gives an example how to generate a base64 encoded WordML binData element. Just for...

Author: mrys Date: 04/19/2005

The new WITH XMLNAMESPACES clause

FOR XML in SQL Server 2000 puts the burden of generating and maintaining XML namespaces completely...

Author: mrys Date: 04/19/2005

April CTP has been released: What are the changes in the XML area

As many of you probably already have heard, we have publicly released the April Community Tech...

Author: mrys Date: 04/19/2005

Next>