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