Friday Five: Power BI Icon Library, Azure SQL, More!

Friday Five: Power BI Icon Library, Azure SQL, More!

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

5003880.jpg

C# 9.0: Target-typed expression

Miguel Bernard is a Developer Technologies MVP from Canada. With more than 10 years of experience with Microsoft Technologies, Miguel has developed many specializations, including C#, F#, Azure, and DevOps practices. Miguel enjoys sharing his knowledge through his blog and by presenting at user groups and conferences. Miguel is very involved in the Montréal MSDEVMTL user group, where he is a co-organizer, and is passionate about teaching, developers’ communities, and everything related to .Net. For more on Miguel, check out his Twitter @miguelbernard88

marc.jpg

Power BI icon library for Diagrams.net (draw.io)

Marc Lelijveld is a Data Platform MVP, Power BI enthusiast, and public speaker who is passionate about anything which transforms data into action. Currently employed as a Data & AI consultant in The Netherlands, Marc is often sharing his thoughts, experience, and best-practices about Microsoft Data Platform with others. For more on Marc, check out his blog.

simon.jpg

Riemers Game Development tutorial revival

Simon Jackson is a Windows Development MVP from the UK who is passionate about teaching all types of developers the wilds of game development and helping others to achieve their dreams. Regardless of the engine or framework, Simon is always out there breaking down difficult topics in to easy to understand posts and information. Check out his Twitter @SimonDarksideJ

pio.jpg

Migrating SQL Server On Premise to Azure SQL

Pio Balistoy is a Filipino Microsoft MVP for Data Platform based in Singapore. He has been working with databases for more than 17 years and has administered all versions of SQL, from SQL Server 6.5 to Azure SQL. For the last 10 years, Pio has been with Pythian Services as a Lead Data Platform Consultant, helping businesses transform using data, analytics and cloud. He actively leads the Data Platform communities both in Singapore and Philippines. For more, check out Pio’s Twitter @Pioisms

martine.jpg

Azure Custom Vision: analyze multiple objects simultaneously using Tensorflow

Alibek Jakupov an AI MVP. After having finished the IITU International Information Technologies University in Kazakhstan, he won the French Government Scholarship in 2016 and started his studies at the EISTI Graduate School in Computer Science and Mathematics Engineering in France. In 2017, he joined Expertime as a software engineer intern. The work implemented during this internship has provided the foundation to the brand new project called What Do They Think. He is a regular contributor to stackoverflow and his personal blog where he shares his experiences of performing data science on Azure. Check him out on Twitter @Ajakupov1

 

Windows 10 accessibility features empower everyone

Windows 10 accessibility features empower everyone

Microsoft puts people first by offering a wide range of Windows 10 accessibility features for users of many different abilities. Known internally as the Windows Accessibility team, the Input for Everyone team draws back a curtain for you to peek behind the scenes. Learn how Windows engineers are building accessibility features for all of us. This is the first article in a series focusing on accessibility and assistive technologies built into Windows 10. Our next installment will be a deep dive into the topic of Vision related features.

Power BI Visualization for Azure Synapse SQL Pool Dynamic Management Views

Power BI Visualization for Azure Synapse SQL Pool Dynamic Management Views

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

Azure Synapse Analytics SQL Pools have what is called the Dynamic Management Views(DMVs) that provide insights into the internals of Azure Synapse SQL Pools. This helps to better understand the performance bottlenecks, tune distribution and understand overall performance of the database. But it is not trivial to having a quick start even for experienced DBAs. It also adds complexity as things like request ID, session id etc needs to figured out manually. Also sometimes a more intuitive way of finding performance bottlenecks is needed in a high scale deployment. This article talks how Power BI Desktop can be used to create visual dashboards across these DMVs.DMV relationship.png


 


Power BI Desktop can be used to visualize the DMVs and create a more intuitive visualization and get insights inside SQL Pools. Here is a snapshot of a sample dashboard that is created on top of DMVs. 


PBIDMVSnapshot.png


 


 


The Power BI Template is available in this github repo if you would like to take a look at it. The github repo also provides instructions on how to configure the template and create the visualization. 


Hope you find this useful. 


 


 


 

AzUpdate: Azure PowerShell 5, Microsoft & Intel's confidential computing partnership and more

AzUpdate: Azure PowerShell 5, Microsoft & Intel's confidential computing partnership and more

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

Quick thank you to all who have been bringing news items to our team’s attention.  News covered this week includes Microsoft announces Azure PowerShell 5.0, Microsoft and Intel commit to delivering next generation confidential computing, Microsoft introduces a new Defender vulnerable devices report, Azure Cloud for Healthcare is now generally available and new training resources for Microsoft Teams admins and IT Pros on MS Learn.


 


 


Microsoft Announces Azure PowerShell 5.0


Microsoft introduced a plethora of fundamental changes to Azure PowerShell in version 5.0 including:



  • Updated authentication – authentication to Azure now via the Microsoft Authentication Library (MSAL) module.

  • Az.KeyVault security update – plain text property SecretValueText from the cmdlets that operate on KeyVault secrets. Your scripts will now need to use SecretValue (a SecureString) instead.

  • Improved support for ACR (Azure Container Registry) and AKS (Azure Kubernetes Service)

  • New default behaviors for Az.KeyVault and Az.Functions


Further details can be found here: Azure PowerShell 5.0 update


 


Microsoft and Intel via Azure commit to delivering next generation confidential computing


Microsoft recently announced that Azure will be an early adopter of Intel’s 3rd generation Xeon® Platform which includes full memory encryption and accelerated cryptographic performance for confidential computing with Intel Software Guard Extensions (SGX). 


 


Microsoft Azure Attestation (MAA) further improves this security posture by enabling customers to remotely attest to the authenticity of the SGX enclave at the hardware level, ensures the latest security patches are installed, and the confirms the integrity of the code running within the enclave.


 


Further details surrounding this security partnership can be found here: Security Partner Azure Confidential Computing


 


Microsoft releases a new threat and vulnerability management report


Microsoft’s newest Defender report, now in public preview, shares details on:




  • Device vulnerability severity levels (e.g. all the devices with critical vulnerabilities)




  • Device exploit availability (e.g. all the devices with vulnerabilities that have verified exploits)




  • Device vulnerability age (e.g. devices with vulnerabilities that were published over 90 days ago)




  • Vulnerable devices by operating system




  • Vulnerable devices by Windows 10 version




Further details can be found here: Vulnerable devices report – threat and vulnerability management


 


Microsoft Cloud for Healthcare is now generally available


Microsoft Cloud for Healthcare offering is aimed at healthcare organizations to make it easier for them to focus on delivering better experiences, insights, and care. Healthcare organizations can quickly access a portfolio of new tailored capabilities offered via Microsoft Azure, Microsoft 365, Microsoft Dynamics 365, Microsoft Power Platform, and Microsoft’s ecosystem of partner healthcare solutions to create trusted, end-to-end cloud-based solutions. Healthcare organizations can engage in more proactive ways with patients and give caregivers tools to improve workflow efficiency and streamline interactions.


 


Read the following blog post for more information on general availability: Microsoft Cloud for Healthcare is transforming the healthcare journey


 


MS Learn Module of the Week


Microsoft_Learn_Banner.png


New training resources for Microsoft Teams admins and IT Pros


At Microsoft Ignite last month, Microsoft introduced several new Microsoft Teams role-based learning paths, learning modules, and interactive product experiences that are available at MS Learn.  These resources were created to help you get ready to deploy and manage Microsoft Teams in your organization and deliver the experiences that meet the needs of your users, we have created new Teams training courses and interactive product how-to guides designed to quickly ramp up your Teams admin knowledge base.


 


If you’re looking to start your learning journey or just want to browse the new Teams learning content, check out the new MS Learn landing page for Microsoft Teams.


 


As you know, our team appreciates your feedback and input on the Microsoft services news we share. Let us know in the comments below if there are any news items you would like to see covered in next week show. Az Update streams live every Friday so be sure to catch the next episode and join us in the live chat.

Sketch your AWS architecture using Visio for the web

Sketch your AWS architecture using Visio for the web

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

Last month, we released updated Azure shapes in Visio for the web. Today, we are excited to announce the release of infrastructure shapes from another major cloud provider: Amazon Web Services (AWS). Included in this release are more than 400 shapes to visualize the design, deployment, and topology of IT solutions built on AWS.


Using AWS diagrams, you can redesign existing infrastructure diagrams or conceptualize your application architecture. You can also visualize the current state of your cloud environment and plan for the future. In addition, having documentation with accurate diagrams helps you tackle infrastructure issues faster.


With Visio for the web, you can now build AWS diagrams for various topologies and service interactions, using familiar icons to represent those services and resources. You can also use connectors to depict relationships between ports and container shapes or AWS groups to visualize virtual private clouds (VPC), public or private subnets, availability zones, and more. For example, you can create an AWS diagram for deploying AWS Lambda functions for implementing webhooks to enable event-driven integration between Git services and AWS on the AWS cloud. This example diagram, shown below, depicts AWS services like AWS Key Management Service and AWS Lambda which are represented by standard icons or symbols, while the AWS cloud is represented using a container.


Git to S3 Webhooks.png


AWS diagram for Git to S3 webhooks


You can share diagrams like these with key stakeholders so that everyone is on the same page regarding execution.


We’ve added 27 AWS shape sets in all to Visio for the web, including AWS analytics, AWS application Integration, AWS AR&VR, AWS Cost Management, AWS Blockchain, AWS Business Application, AWS Compute, AWS Customer Enablement, AWS Customer Engagement, AWS Database, AWS Developer tools, AWS End user computing, AWS Game tech, AWS General, AWS containers, AWS IoT, AWS Machine Learning, AWS Management & Governance, AWS Media Services, AWS Migration & Transfer, AWS Mobile, AWS Networking & Content Delivery, AWS Quantum Technologies, AWS Robotics, AWS Satellite, AWS Security, Identity & Compliance, and AWS Storage.


AWS Thumbnails_1.png


To help you get started easily, we’ve provided a few starter diagrams using various AWS services. Go to the Visio web app homepage and select your preferred diagram template to quickly start visualizing your AWS infrastructure. Our support page provides even more details on how to create your AWS diagrams.


 


AWS gif.gif


 


For questions about AWS templates in Visio for the web, as well as other features, please email us at tellvisio@microsoft.com. You can submit your ideas for improving the Visio web app through our UserVoice site. We also hope you’ll keep visiting the Visio Tech Community and follow us on Twitter to stay current on the latest Visio releases.