create table testTable
(
day_nbr integer not null primary key clustered,
value integer not null check (value > 0)
);
insert into testTable
values (10, 7), (20, 15), (30, 3), (40, 9), (50, 17), (60, 25), (70, 10);

select *,
       runningTotal = (select sum(value)
                         from testTable
                        where day_nbr <= t.day_nbr),
       runningAverage = (select avg(value)
                           from testTable
                          where day_nbr <= t.day_nbr)
  from testTable t;

select *
  from testTable t
       cross apply (select sum(value) as runningTotal,
                           avg(value) as runningAverage
                      from testTable
                     where day_nbr <= t.day_nbr)d;

select *, sum(value) over(order by day_nbr rows between unbounded preceding and current row) as runningTotal,
          avg(value) over(order by day_nbr rows between unbounded preceding and current row) as runningAverage
from testTable

Error-Message Guidelines
Summary: Design effective error messages by ensuring they are highly visible, provide constructive communication, and respect user effort.
 

Here’s a summary of what’s new in this preview release:

• Output caching improvements
• Dynamic authentication requests with msal.js
• Improved diagnostics for authentication in Blazor WebAssembly
• WebAssembly multithreading (experimental)  

Here’s a summary of what’s new in this preview release:

• JWT authentication improvements & automatic authentication configuration
• Minimal API’s parameter binding support for argument list simplification 

ng-conf 2017 Summary - Day 2 (Fair Day)
Angular v4 has been released. Read about Fair Day from ng-conf 2017 (April 6) Day 2. 

I watched a lot of talks and read a lot of articles relevant to Angular performance, and this post is the summary of my findings.