The gaps & islands problem is a common problem in data analysis. Some examples are:
* how long are active periods that my server was running? Or, how long are the periods that the server was down?
* on average, how long are the billable periods of my consultants?
* what was the longest stretch of days without rain?

In this session, you'll be introduced to the powerful concepts of window functions in T-SQL. With a practical use case, the gaps & islands problem is explained and solved. At the end of the session, you should feel confident in using window functions in your own data analyses.

A basic understanding of T-SQL querying concepts is required to follow this session.