New webinar series: Monthly threat insights

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

We’re happy to announce a new monthly webinar series called “monthly threat insights”. On the third Wednesday of each month, the Microsoft Defender Threat Intelligence team will dive deep into a selected emerging threat as seen in the threat analytics library available in Microsoft 365 Defender. Using the threat analytics report authored by Microsoft security researchers and analysts, we’ll examine the different facets of the threat: its history, behavior, and detection details, as well as a detailed MITRE ATT&CK framework mapping of attack techniques and recommended mitigations. We will also look at KQL queries you can use in advanced hunting to investigate the threat on your own.


 


If you use one of the Microsoft Defender products, you will also have access to the full report in the threat analytics page of Microsoft 365 Defender. In this page, you can access the report, see alerts associated with this threat, and determine if you have applicable protections in place.


 


Be sure to register using this link, and join us every third Wednesday for these timely and insightful webinars.


 


This Wednesday June 16th at 9AM PST is our first episode; we hope to see you there! 


 


If you can’t join us, we will record these webinars and share them on https://aka.ms/securitywebinars

Microsoft Teams certified accessory tour | Modern Headsets, Speaker, Webcam & Surface Headphones 2+

Microsoft Teams certified accessory tour | Modern Headsets, Speaker, Webcam & Surface Headphones 2+

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

Take a look at the latest Microsoft hardware innovations in support of remote and hybrid work at home and in the office. Engineering leader, Branden Powell, joins Jeremy Chapman to show how the new Microsoft and Surface accessories deliver the best experience on Microsoft Teams.


 


Screen Shot 2021-06-15 at 1.09.10 PM.png


 


All our accessories are made with premium materials, so they look great and are built to last. They’re compact and lightweight to optimize your space, no matter where you’re working from. We’ve prioritized all-day comfort and mobility, and everything is certified for use with Microsoft Teams to give you a great online meeting experience. The convergence of hardware plus software helps minimize meeting fatigue, so you can stay fresh and in the flow of your work.


 



 


The latest round of accessories is available today: Surface Headphones 2+ for Business, Modern USB, Modern Wireless Headsets, Modern USB-C Speaker, and the new Modern Webcam.


 





QUICK LINKS:











Link References:





Unfamiliar with Microsoft Mechanics?




 


Keep getting this insider knowledge, join us on social:


































































Lesson Learned #175: Connecting to Private EndPoint of Azure SQL Database from Managed Instance

Lesson Learned #175: Connecting to Private EndPoint of Azure SQL Database from Managed Instance

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

Today, I worked on a very interesting case when our customer wants to connect to the Private EndPoint/Link of Azure SQL Database from Azure SQL Managed Instance. In this article, I would like to share with an example how to do it. 


 


Basically, once you have created the Private Endpoint on the VNET/SUBNET of your Azure SQL Managed Instance. The most important thing is to resolve the IP. We have two options:


 



  • Adding in your DNS server the resolution for your Azure SQL Database Private EndPoint IP.

    • For example, servername.database.windows.net points to 10.1.2.5. If you have already deployed you Azure SQL Managed Instance before creating this Private Endpoint in order to update the DNS resolution of your Azure SQL Manage Instance nodes, I would like to suggest to scale up/down your Azure SQL Managed Instance in order to refresh the DNS servers.



  • Connecting using the IP address of your Private Endpoint.

    • In the Linked Server definition, type a name (for example, MyLinkedServerWithPrivateEndpoint), choose any provider in the data source type the Private Endpoint IP that you have, for example, 10.1.2.5 and finally, in the catalog type the name of your database. 

    • For login credentials, you need to specify:


      • UserName: myloginname@servername (without adding .database.windows.net)

      • Password: Type the password of this login.






 


LinkedServer.png



LinkedServer2.png



In this situation, everytime that you run a query, for example, SELECT * FROM MyLinkedServerWithPrivateEndpoint.DatabaseName.SchemaName.TableName you are going to directly to the Private Endpoint. This applies for Azure SQL Database and Azure Synapse. 


 


Enjoy!


 

What’s New in Excel for the web

What’s New in Excel for the web

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

Delivering rich, delightful experiences to our customers continues to be a top priority for our Excel team. A few weeks ago, we shared how to easily format your data with color and style, and more. Today, we bring you a set of new features and improvements to help you better analyze your data, specifically:



  • Text to columns

  • PivotTable improvements

  • Sort improvements

  • Interactive charts

  • Additional keyboard shortcuts


 


Text to columns


You can now split text into columns using delimiters.  For example, with a few clicks, you can convert “Hello World” in one cell to “Hello” and “World” across two adjacent cells. 


 


You can also select multiple delimiters including tab, semicolon, comma, space, and custom [delimiter] at the same time.  For example, “Hello, how are you?” in one cell would split into “Hello”, “”, “how”, “are”, and “you?” across 5 cells if you selected both comma and space as delimiters.


 


Text to columnsText to columns


 


PivotTable improvements


Analyze your data with the new and improved PivotTable experience in Excel for the web including:



  • Create a PivotTable quickly with Recommended PivotTables 

  • Change the settings and look-and-feel of your PivotTable the way you want it via the new PivotTable ribbon including PivotTable Styles and new PivotTable Settings task pane

  • Copy, refresh, and show or hide PivotTable task panes with one click using the new PivotTable right click menu


 



 


 


Sort improvements


Sorting is fundamental in data analysis.  Sorting can be more than numerical or alphabetical ordering though.  In Excel for the web, you can now sort by Cell Color, Font Color, and Conditional Formatting Icon, in addition to Cell Values.  Furthermore, you can sort by more than one column.


 


Sort improvementsSort improvements


 


Interactive charts


You can now directly select and interact with chart elements when formatting a chart. Double-clicking a chart element launches the format task pane while single-clicking a chart element navigates you to its corresponding formatting options. In addition, non-data chart elements can now be removed from the chart using the delete/backspace keys. You will also be able to see a preview of your selection as you hover your mouse cursor over different chart elements.


 


Interactive chartsInteractive charts


 


Additional keyboard shortcuts


Many users have asked for additional well-known and commonly used keyboard shortcuts in Excel for the web, and we’re thrilled to bring you:



  • End-arrows – move to the last cell in the row or column

  • Ctrl-End – move to the last cell that contains data or formatting.

  • Ctrl-Shit-End – extend the selection to the last used cell


Also coming soon are



  • PgUp/PgDn – move screen up/down

  • Alt-PgUp – move screen left

  • Alt-PgDn – move screen right

  • Alt-Shift-PgUp – extend selection left one screen

  • Alt+Shift+PgDn – extend selection right one screen


 


Find the full list of keyboard shortcuts via Help > Keyboard Shortcuts.


 


Keyboard shortcutsKeyboard shortcuts


 


These are just some of the latest improvements, many more are coming soon!


 


Your feedback helps shape the future of Excel for the web. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.


 


Want to know more about Excel for the web?  See What’s new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.


 


Thank you!


 


 

Inclusive Learning 365: Designed to Work for Everyone

Inclusive Learning 365: Designed to Work for Everyone

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

Today’s guest post was written by Chris Bugaj, Karen Janowski, Mike Marotta and Beth Poss – Assistive Technology experts, and co-authors of the new book, Inclusive 365


 


Designing experiences that reach all learners is a fundamental need for every educator to engage in. However, adopting an inclusive mindset is necessary before one can design educational experiences that meet every individual’s need. Within an inclusive mindset is the belief that inclusion is feasible, that all learners can achieve their potential, and that we must offer strategies that are flexible, accessible to all and intentionally designed. Inclusive educational experiences rarely happen by accident. Designing for inclusivity acknowledges learner variability and focuses on strengths that promote engagement, success, and autonomy.


 


Ubiquitous integration of educational technology helps create barrier free learning spaces where everyone has access to the tools to succeed and where use of technology supports does not mark any one learner as less accomplished.


 


As we discuss in our forthcoming book, Inclusive Learning 365, technology can be used to design experiences that are flexible which removes obstacles to independence. In the spirit of building inclusive learning experiences, Microsoft is paving the way toward ensuring ubiquitous access to inclusive technology for all. They have developed a multitude of features which promote accessibility and inclusion which are built into existing tools such as Office 365 and Windows. They have partnered with educational institutions and other technology providers to ensure these tools are widely available to the masses. Providing familiar tools with a variety of customizable features removes obstacles to content access. These tools offer flexibility and choice so that users can identify the features which work best for them, depending on the task and their own unique learning needs.


NEW orig upate color with calendarv3.jpg


Changing the visual presentation of text, adding audio supports, translation of both voice recordings with text to speech and playback in multiple languages, are just some of the features built into Microsoft’s Learning Tools. Additionally, they have made one of their flagship accessibility tools, Immersive Reader, available to third party developers extending its reach. Immersive Reader makes text accessible for those who are learning to decode by helping them understand what they are reading. An example of that partnership with other developers is how Wakelet and Immersive Reader interact. For a recent immigrant from Israel, whose primary language was Hebrew, this partnership opened the curriculum for him in a way that wasn’t possible previously. The educator curated grade level content using Wakelet. The learner used the embedded Immersive Reader feature to translate the articles from English to Hebrew and then listened to them in his primary language. He independently accessed grade level content. Eventually, this feature was no longer needed as he gained English language skills. But it made a tremendous difference early in the school year.


 


Sometimes, accessibility is as simple as spell check—a tool that most of us do not even think about, as it is seamlessly integrated into almost every digital writing tool used. For one nine-year-old learner, however, spell check has made the difference between feeling hesitant as a student and becoming a confident learner with a newfound love for writing. Knowing that she had difficulty with spelling, she would get hung up on how to spell a word, lose her train of thought and get frustrated, often changing a well thought out and effective word she was writing to a less sophisticated and less interesting word that she knew how to spell. Asking the adults around her to help her spell was typically met with the direction “Try to find it in the dictionary”, not a helpful strategy when you might not be sure of the second letter in the word! When one educator explicitly modeled the simple strategy of clicking on the familiar red squiggly underlined word and using the suggestions to help her correct her misspelling, she found a solution to her writing challenges. When educators instead gave her the prompt of “Do your best and see what suggestions spell check gives you.” she took agency of her own learning. When she realized that even when she was doing handwritten work or filling in a printed worksheet, she could open a Word document and type in the word she was struggling with to copy correctly, she felt successful and proud of her work. A simple, often underrated function of a tool helped change the mindset of one young learner, who now sees herself as capable.


 


If the principal responsibility of an educator is to support the learners they are meant to serve, then every educator should explore both common-place and newer technologies designed with inclusivity and accessibility in mind. Learners, just like this nine-year-old, can be invited to evaluate the features for themselves, develop their own awareness for what’s available, and craft their own technology toolkit for life-long learning.


 


Join the four of us for a free webinar (June 17th @ 1pm PST) led by Mike Tholfsen, as we discuss Inclusive Learning 365.


Chris Bugaj, Karen Janowski, Mike Marotta and Beth Poss