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

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 (Switzerland) and Athens (Greece). In Switzerland I will be presenting a specially made presentation on “What’s new in SQL Server 2005” that will be more technical than the general launch presentation that I am giving in Athens. In…

0

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. Today, I ask you the following riddle: What does SQL Server 2005, MySpace.com and Quiznos have in common? Well, here is the answer: Here is a link to Rick Penwell’s blog on the MySpace next…

4

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 feedback. If you live outside of the United States or Canada, we want to know more about your experience with SQL Server! How did you initially learn to use SQL? What are your preferences for learning new…

1

SQL Server 2005 and Visual Studio 2005 Launches

Today is the big launch. Steve B. is giving the launch keynote in San Francisco. I am currently sitting in a meeting room at a competitor’s place where I am at for a W3C XQuery meeting watching the live webcast during our lunch break :-). I already provided a list of many (but not all) of…

0

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 XQuery 1.0, XPath 2.0 and XSLT 2.0. Does this mean that the recommendations are done? No, not yet. But it means that we reached an important milestone. Now everyone is officially invited to implement the specs, run the test suite,…

2