The September 18th Weekly Roundup is Posted!

This article is contributed. See the original author and article here.

News this week includes:

 

Microsoft Ignite preparation is in full swing, with several resources on how what to expect from several produce teams: Microsoft 365, SharePoint, OneDrive, Planner, Stream, Teams for Education, Excel, and Endpoint Manager.

 

Yammer is rolling out reactions for every conversation or reply in the new Yammer. You can now express yourself through gratitude and celebration, laughter, and sadness-just like in real life!

 

The Microsoft Learn LTI application is now available. The application enables you to seamlessly embed modules and learning paths from the Microsoft Learn Catalog.

 

@Tieme Woldman  is our Member of the Week, and a great contributor in the Access community. 

 

View the Weekly Roundup for Sept 14-18th in Sway and attached PDF document.

 

A developer’s guide to Ignite 2020

This article is contributed. See the original author and article here.

Microsoft Ignite will take place online, kicking off on the morning of September 22nd, at 8:00 AM in the Pacific Time Zone. The event programming will include live segments, digital breakout sessions, and Q&A, available across multiple time zones. Be sure to visit the Ignite home page to view the event agenda and additional details.

 

Fun news for developers will kick off on Day 1 with Julia White and her Invent with Purpose on Azure keynote and will be followed by Scott Hunter with The Future of .NET is .NET 5, followed with several additional rebroadcasts to accommodate a worldwide audience. On Day 2, Scott Hanselman and friends will keynote Are we there yet? App Development in Azure. It is a packed agenda, but don’t take my word for it –

 

Developers at home and at work are resilient and finding ways to adapt and continue to collaborate and be productive remotely, invent at speed and create amazing cloud-powered applications while having fun and helping everyone. Microsoft is unique in the industry and provides the world’s most comprehensive developer toolkit and platform to support your journey as a developer, no matter where you are.

 

The complete line up for Azure App Developer sessions is listed below:

 

Start Time (PDT)

Session name

Speaker(s)

Tuesday, 9/22: 11:15am – 11:30am

Key Segment Preview: Ride the Developer Cloud with Visual Studio +.NET, GitHub and Azure

Scott Hanselman

Tuesday, 9/22: 2:30pm-3:00pm

The Future of .NET is .NET 5 Digital Breakout

Scott Hunter

Tuesday, 9/22: 3:15pm-3:45pm

Ask the Expert: .NET Team

Scott Hunter

Tuesday, 9/23: 10:30pm-11:00pm

The Future of .NET is .NET 5 Digital Breakout

Scott Hunter

Wednesday, 9/23: 6:30am-7:00am

The Future of .NET is .NET 5 Digital Breakout

Scott Hunter

Wednesday, 9/23: 8:30am-9:00am

Are we there yet? App Development in Azure with Scott Hanselman and Friends

Scott Hanselman

Wednesday, 9/23: 1:00pm-1:30pm

Enterprise-grade Kubernetes on Azure Digital Breakout Session

Brendan Burns

Wednesday, 9/23: 1:45pm-2:15pm

Enterprise-grade Kubernetes on Azure Ask the Experts

Brendan Burns

Wednesday, 9/23: 2:30pm-3:00pm

Migrate, Modernize .NET applications on Azure Digital Breakout

Gaurav Seth, Daniel Roth

Wednesday, 9/24: 4:30pm-5:00pm

Are we there yet? App Development in Azure with Scott Hanselman and Friends

Scott Hanselman

Wednesday, 9/23: 7:30pm-8:00pm

Migrate, Modernize .NET applications on Azure Ask the Experts

Gaurav Seth, Daniel Roth

Wednesday, 9/23: 7:30-8:00pm

Ask the Experts: Visual Studio, GitHub, and Azure

Victoria Cushing

Wednesday, 9/23: 9:00pm-9:30pm

Enterprise-grade Kubernetes on Azure Digital Breakout Session

Brendan Burns

Wednesday, 9/23: 10:30pm-11:00pm

Migrate, Modernize .NET applications on Azure Digital Breakout

Gaurav Seth, Daniel Roth

Wednesday, 9/23: 11:15pm-11:45pm

Enterprise-grade Kubernetes on Azure Ask the Experts

Brendan Burns

Thursday, 9/24: 12:30am-1:00am

Are we there yet? App Development in Azure with Scott Hanselman and Friends

Scott Hanselman

Thursday, 9/24: 3:30am-4:00am

Migrate, Modernize .NET applications on Azure Ask the Experts

Gaurav Seth, Daniel Roth

Thursday, 9/24: 5:00am-5:30am

Enterprise-grade Kubernetes on Azure Digital Breakout Session

Brendan Burns

Thursday, 9/24: 6:30am-7:00am

Migrate, Modernize .NET applications on Azure Digital Breakout

Gaurav Seth, Daniel Roth

Pre-recorded On-demand

Best Practices of Running Cloud Native Applications on Azure

Sean McKenna

Pre-recorded On-demand

Event-driven Applications with Azure Functions & Logic Apps

Derek Li

Pre-recorded On-demand

Resilient DevOps Practices with Code to Cloud automation

Gopinath Chigakkagari

Pre-recorded On-demand

Code, collaborate, and ship from anywhere: Meet the Microsoft Developer Cloud

Leslie Richardson, Vix Rian

On-demand (overflow), will be available on Tuesday, 9/22 at 8 am

Empowering Ops with VS Code

Zachary Deptawa

On-demand (overflow), will be available on Tuesday, 9/22 at 8 am

Java on Your Terms with Azure

Martijn Verburg, Edward Burns

On-demand (overflow), will be available on Tuesday, 9/22 at 8 am

Building Cloud-Native Applications with Azure

Uche Nkadi, Kate Olszewska

On-demand (overflow), will be available on Tuesday, 9/22 at 8 am

Serverless APIs with Functions and API Management

David Barkol

 

Also check out the Tech community at https://techcommunity.microsoft.com. Here you can share experiences, engage, and learn from experts, while having conversations with the community about Microsoft Ignite.

 

SWAG? Did someone say SWAG? Yes, we also have an assortment of digital swag that you can take advantage of today:

 

Microsoft Ignite lasts 48-hours and be sure to register for the event. With registration, you can access the full learning experience, including digital breakout sessions and the Connection Zone. What are you waiting for? Take a look at our official session list and add it to your session schedule to be ready for 48-hours of non-stop programming on Tuesday, September 22-24th.

Experiencing Data Access issue in Azure Portal for Many Data Types – 09/18 – Investigating

This article is contributed. See the original author and article here.

Update: Friday, 18 September 2020 20:21 UTC

We continue to investigate issues within Application Insights Live Metrics. Root cause is not fully understood at this time. Some customers continue to experience issues viewing their Live Metrics data. We are working to establish the start time for the issue, initial findings indicate that the problem began at 9/18 7:00 UTC. We currently have no estimate for resolution.

  • Work Around: None
  • Next Update: Before 09/18 23:30 UTC

-Ian


[Guest Blog] My Journey to Ethical AI

[Guest Blog] My Journey to Ethical AI

This article is contributed. See the original author and article here.

This article by Humans of IT Student Ambassador Olivia Asemota, a Computer Science undergrad student from Xavier University of Louisiana is part of our Student Ambassador Spotlight series in the lead-up to Microsoft Ignite. Olivia shares about her passion for computer science and ethics, and her future aspirations to blend the two together in her future career. 

 

oliviaa.jpg

 

My journey into the world of computer science and technology began quite differently from other people. For me, it began when I thought I broke the internet. I remember playing on my father’s computer, not really knowing what I was doing, but, nevertheless, pressing as many buttons as I could. I somehow got into the developer tools of the browser and deleted everything on the screen. I immediately froze – did I just break the browser, or worse, the entire Internet? My initial instinct was to get up, run, and never face my dad again, but a quick hit of the refresh button and everything was back to normal.

 

Though daunting, this slightly traumatic experience is what jumpstarted my fascination with technology. I didn’t know what I did, but curiosity got the best of me, and I began trying to replicate my actions in the days following. Those experiments introduced me to the world of programming and I immediately knew that I had to learn more. From there, I began to scour the internet for online courses so I could better understand what I stumbled upon. I found lessons in Python, Java, HTML, and JavaScript, and I quickly fell in love with the creativity of programming. I grew up thinking that I had to be an artist or actor in order to be creative, but coding taught me that this was not the case. I could write code to do whatever I set my young, imaginative, mind to. It was liberating and exciting. 

            IMG_1035-2.jpg

 

Once I got to college, I knew Computer Science would be my major. I already had dreams of working at top tech companies or starting my own business. I knew I wanted to use the skills and knowledge I gained to help other people in the best way I could. However, during that first year in college, I discovered a new passion that I believe will tie closely with my software engineering endeavors. I discovered a deep love for philosophy and ethics.

 

I have always been aware of the good and bad sides of technology. I love how it has shaped our world and expanded our ability to connect with people who have similar interests and beliefs as we do. We have the ability to provide aid to people on the other side of the world whether it’s through monetary or vocal support. But I think there are certain ethical standards that we need to hold ourselves to, especially as it applies to AI and how it affects the lives of people around the world. Blending tech and philosophy was truly eye-opening for me.

 

My goal in the next 10 years of my life is to become a research scientist in Artificial Intelligence and Machine Learning. I want to help build ethical technology that benefits everyone. I believe this starts with learning about different ethical theories and how they can be applied to AI and ML. There are so many positive possibilities that these technological advancements can give us, and I’m excited to see how it continues to shape our world for the better. This is where my two passions meet. I want to help create better systems for more people, and I think it’s not far out of my reach. I truly believe to begin solving these problems, we need to understand how different aspects of our society affect the way we think and thus, the way we create. Our tools and platforms are a reflection of our thoughts and feelings and maybe this is where we should begin as we move forward.

 

I don’t have all of the answers. I believe this problem challenges us to reevaluate our connection with our environment and other people. But I do not think hope is lost. We just need to be bold and to take the right risks, and I’m optimistic that our society and way of living can be much better than ever before.

 

#HumansofIT

#StudentAmbassadors

Sysmon v12.0, Process Monitor v3.60, Procdump v10.0 and ARM64 ports

This article is contributed. See the original author and article here.

Sysmon v12.0

In addition to several bug fixes, this major update to Sysmon adds support for capturing clipboard operations to help incident responders retrieve attacker RDP file and command drops, including originating remote machine IP addresses.
 

Process Monitor v3.60

This update to Process Monitor, a utility that logs process file, network and registry activity, adds support for multiple filter item selection, as well as decoding for new file system control operations and error status codes.
 

Procdump v10.0

This release of Procdump, a flexible tool for manual and trigger-based process dump generation, adds support for dump cancellation and CoreCLR processes.
 

ARM64 ports

In addition, several tools have been newly ported to and are now available for ARM64. These include: AdInsight v1.2, AutoLogon v3.1, Autoruns v13.98, ClockRes v2.1, DebugView v4.9, DiskExt v1.2, FindLinks v1.1, Handle v4.22, Hex2Dec v1.1, Junction v1.07, PendMoves v1.02, PipeList v1.02, Procdump v10.0, Process Explorer v16.32, RegDelNull v1.11, RU v1.2, Sigcheck v2.8, Streams v1.6, Sync v2.2, VMMap v3.26, WhoIs v1.21 and ZoomIt v4.52. Download all ARM64 tools in a single download with the Sysinternals Suite for ARM64.
Geospatial joins are now supported by Azure Data Explorer

Geospatial joins are now supported by Azure Data Explorer

This article is contributed. See the original author and article here.

This blog post covers a new geo function and the basics of geospatial joins.

 

geo_polygon_to_s2cells

geo_polygon_to_s2cells takes a polygon or multipolygon and a S2 cell level as input and creates an array of all token strings which cover it. Be aware that covering a large-area polygon with small-area cells can lead to a huge amount of covering cells. As a result, the query might return null.

 

KQL-Query:

 

let polygon = dynamic({"type":"Polygon","coordinates":[[[0,0],[0,50],[100,50],[0,0]]]});
print s2_cell_token_count = array_length(geo_polygon_to_s2cells(polygon, 5));

 

 Result:

s2_cell_token_count
286

 

Geospatial joins

This query pattern is oftentimes used in various mobility solutions (geospatial telemetry and static reference data), geospatial risk analysis and agriculture optimization using weather data. It is based on the three-dimensional S2 geometry and the functions geo_polygon_to_s2cells and geo_point_in_polygon. By use of this functionality a geospatial join consists of a coarse-grained join using the S2 cell coverage and the exact validation using the geo_point_in_polygon function.

 

The four main steps:

  1. Converting polygons to S2 cells of level k,
  2. Converting points to the same S2 cells level k,
  3. Joining on S2 cells,
  4. Filtering by geo_point_in_polygon().

 

The following picture explains the flow of the entire KQL query. First you need to choose the right S2 cell level. It should not be too big and not too small (it is not recommended to use more than 10.000 cells, 65535 are possible in theory). Second you are creating the S2 cell tokens for the static dataset. Next you are joining the polygons with the timeseries based on the tokens. This provides you with a dataset which might still has some false positives (S2 cell overlap) and that is why you need to end the statement with a check if the actual point is in the polygon.

geospatialJoin.png

 

This is a concrete example of a geospatial join based on the StormEvents and US_States table located on the help cluster. It calculates the damage in $ by state.

 

KQL-Query:

 

let join_level = 4; 
US_States 
| project State = features.properties.NAME, polygon = features.geometry 
| extend covering = geo_polygon_to_s2cells(polygon, join_level) 
| mv-expand covering to typeof(string) 
| join kind = inner hint.strategy = broadcast 
( 
  StormEvents 
  | project BeginLon, BeginLat , DamageProperty 
  | extend covering = geo_point_to_s2cell(BeginLon, BeginLat, join_level) 
) on covering 
| where geo_point_in_polygon(BeginLon, BeginLat, polygon) 
| summarize CountOfEvents=count(), DamageInDollar=sum(DamageProperty) by tostring(State) 
| top 3 by DamageInDollar desc

 

Result:

State CountOfEvents DamageInDollar

Kansas

2298

533352500

Texas

3889

488525500

Ohio

852

371630500