Zero Trust for Network & Infrastructure – Essentials Series – Episode 4

Zero Trust for Network & Infrastructure – Essentials Series – Episode 4

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

Apply Zero Trust principles and policies to your network and infrastructure with this essentials episode. It’s a high-level overview of the principles of the Zero Trust security model, spanning identity, endpoints, applications, networks, infrastructure, and data.


 


Screen Shot 2021-07-07 at 12.14.09 PM.png


 


Your network and its underlying configuration provides secure access to your resources. Infrastructure, whether on premises servers, local or cloud hosted VMs, containers, storage, or PaaS databases, all represent a critical threat vector. Jeremy Chapman, Director of Microsoft 365, walks you through how to apply the core Zero Trust tenets of verify explicitly, apply least privileged access, and assume breach for each of these layers, along with your options.


 



 





QUICK LINKS:








Link References:






Unfamiliar with Microsoft Mechanics?




 


Keep getting this insider knowledge, join us on social:










Video Transcript:



























Using Azure Maps to Create Location Based Experiences for Retail

Using Azure Maps to Create Location Based Experiences for Retail

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

Due to virus lockdowns, many businesses have had to shift their customer engagement model away from the more traditional Brick & Mortar, in person experiences and either add or expand their online shopping experience to keep their customers.  Azure Maps can help retailers realize these benefits through experiences created using features of Azure Maps such as:


 

















IoTGirl_2-1625450623721.png

Store or Locker Locator


 


Find the closest locked delivery box to avoid box theft from front door delivery and return items to locked box location rather than brick and mortar store. Further Azure Search capability could be used to suggest the locations that have the specific item the customer wants in stock and pre-purchase so it is ready for curb-side pick-up


 


IoTGirl_3-1625450642898.png

Valid Address Entry 


 


Avoid costly returned as undeliverable packages due to poorly completed addresses in web forms.  Accepting only addresses that are populated in a drop down ensures the address is recognized within Azure Maps and is “routable” for delivery option offerings.


 


IoTGirl_4-1625450666906.png

Point of Interest Advertising


 


Want to have your business found organically by folks looking for businesses in Azure Maps, Bing Maps and TomTom?  To ensure your business listing is correct on all Microsoft connected maps we have the following two suggested links:



 



 


In all cases, it is important for retail customers to know where the business is located and that is where Azure Maps pulls it all together.


As part of the Azure IoT Suite of offerings from Microsoft, Azure Maps exists to give you the ability to make your location-based scenarios a reality.  In the case of retail these are pretty well known but there is always room to innovate!


 










For example, World-wide children’s clothes retailer and Azure Maps customer, Okaïdi, has created their own “LocateShop” experience using the store locator functionality offered through the Azure Maps Web SDK. Customers easily find the “Location” option and then can type any city or country worldwide in the edit box to find the closest store or web retail site. They can then get their expectation set for a trip to the physical store to shop and pick up or follow the link to an online shopping experience if there is no retail store in their region.


 


Okaïdi has created a completely blended online and off-line shopping experience for their customers based on where they live and immediately sets the expectation o which shopping experiences they have available to them through their location finder page.


IoTGirl_5-1625451639719.png

 


While this blog focused on how Azure maps can help within your Retail solution, I also wanted to let you know that Microsoft has initiatives to help businesses succeed including:



  • https://startups.microsoft.com/ – You are doing big things. We are here to help! Accelerate growth with a customized set of offerings and resources that evolve with your startup from idea to exit.

  • https://partner.microsoft.com/ – Members of the Microsoft Partner Network have access to resources, programs, tools, and connections. Discover a community designed to help businesses grow.

  • https://www.microsoftiotinsiderlabs.com/ – Accelerate your AI and/or IOT Project with personalized help from our Microsoft technology experts.


 


To Find out more about Azure for Retail and Microsoft for Business check out these information-packed links:



 


Thank you for your interest in Azure Maps. All of the samples above are directly accessible through the links and have Github repositories for you to leverage the sample code within your solutions.  If you need any assistance or have any questions feel free to post them in our Q&A section, we are here to help!

Announcing App Service Environment GA

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

We are happy to announce the GA of App Service Environment v3 (ASEv3) along with Isolated V2.  The ASEv3 was developed in response to customer feedback and has many improvements over the earlier versions while still providing an isolated single tenant web application hosting platform. As part of the Azure App Service, the ASEv3 provides a PaaS experience to host your Windows or Linux applications. You can deploy Windows or Linux applications as code and Microsoft will manage the OS your applications run in. If you want greater control over your app, you have the ability to host Linux containers as well.


 


Just like with earlier versions, the ASEv3 deploys into a subnet in one of your Azure Virtual Networks (VNets). You can choose to deploy the ASE with an internal VIP in your VNet or with an external VIP that faces the internet. Apps that are deployed into an ASEv3 can access resources within the same VNet without any additional configuration. The inbound and outbound traffic to your apps can be controlled completely with Network Security Groups (NSGs) or any supported type of routes.


 


Pricing


Applications are hosted in App Service plans which are created in an App Service Environment. The App Service plan is essentially a provisioning profile for an application host. As you scale your App Service plan out, you create more application hosts with all of the apps in that App Service plan on each host. Pricing for ASEv3 is centered on the App Service plan Isolated v2 pricing with some variation based on deployment type. This is an improvement over the App Service Environment v2, which carried a stamp fee in addition to the App Service plan rate. While there is no stamp fee, there is a minimum charge for your ASEv3 based on the deployment type. These are minimum charges though and are not additive. Beyond selecting if you want an internal or external VIP, an ASEv3 can be deployed in one of three ways:



  • Default ASEv3: If ASE is empty there is a charge as if you had one ASP with one instance of Windows I1v2. This is not an additive charge but only applies if the ASEv3 is totally empty. If the ASEv3 has one or more instances, you just pay for your Isolated v2 App Service plans.

  • Availability Zone ASEv3: An AZ ASEv3 requires a minimum 9 Windows I1v2 instance charge. This is not an added charge but only applies if you have fewer than 9 total App Service plan instances. All App Service plans in an AZ ASEv3 have a minimum instance count of three. This ensures that customer workloads are zone redundant and are spread across each availability zone.

  • Dedicated host ASEv3:  With the dedicated host option, you pay for two dedicated hosts with a small percentage of the Isolated V2 per core charge as you scale. The dedicated host deployment does not support availability zone based deployments.


The App Service plan size options in ASEv3 are: 2 core 8 GB RAM, 4 core 16 GB RAM, 8 core 32 GB RAM. The larger sizes handle larger applications but also allows for holding more apps within a single App Service plan. Availability zone support is only available in select regions where all of the App Service dependencies are deployed zone redundant. Reserved instance pricing is available for Isolated v2 App Service plans. With reserved instance pricing you have 1 year and 3 year options that substantially reduce costs.


 


Networking differences between multi-tenant and ASEv3


In the multi-tenant App Service, there are a number of networking features that enable apps to be exposed on a private address or access resources within a VNet. Those features need to be enabled on at an app by app basis. If you want to enforce network access control on your app, then you need to configure that on each app that this is desired upon. In ASEv3 you do not need to enable anything on your apps for them to be in your VNet. All apps that are in Isolated v2 plans are already in your VNet. 


 


With ASEv3 you can enforce your network access external to the application. Unlike the earlier versions of the App Service Environment (ASE), with ASEv3 there are no networking dependencies in your VNet. While it was possible to control application traffic with earlier versions of the ASE, you always needed to allow for the dependency traffic. With ASEv3 you can completely control your VNet making it far easier to manage.


 


If you have used earlier versions of the ASE, you will find that scaling is improved. While it isn’t as fast as in the multi-tenant service, it is substantially faster than earlier versions. Scaling now will only block other scale operations of the same OS and App Service plan size combination. You can simultaneously scale a Windows small I1v2 and a Linux medium I1v2 for example. There is also no need to manage the front end scaling as with earlier ASE versions. In ASEv3, the front ends that handle inbound HTTP/HTTPS are automatically scaled without any customer adjustment required.


 


The ASEv3 is available in most commercial regions now and will soon be in all commercial regions. To learn more about the App Service Environment v3, read:


Azure SQL News Update: July 2021

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

Today and every Wednesday Data Exposed goes live at 9AM PT on LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming events and things to look out for. We’ve included an iCal file, so you can add a reminder to tune in live to your calendar. If you missed the episode, you can find them all at https://aka.ms/AzureSQLYT.


 


You can read this blog to get all the updates and references mentioned in the show. Here’s the July  2021 update:


 


Product updates


Let’s start with what was announced and who came on the show.


 


The biggest launch we had this month was the announcement of the general availability of Azure Arc, including the General Availability of Azure Arc-enabled SQL Managed Instance (coming on July 30th). If you want to watch the launch event for Azure Arc, you can register here to view it on-demand. On Data Exposed Live last week, we had a special post-launch episode about how all this relates to SQL Server and Azure SQL. We brought on several members of the product group, and you can watch the session on-demand here.


 


Additionally, we made two public preview announcements, the first applies to Azure SQL Database and Azure SQL Managed Instance. This announcement was the support to use AAD-only authentication for SQL Database and Managed Instance to disable SQL authentication.


 


Last, but certainly not least, we announced the preview for using Azure SQL Database Hyperscale with named replicas to massively scale out read workloads and easily implement near-real time analytical solutions. We had the lead program manager of these capabilities, Davide Mauri, on the show to tell us more about it. In addition to the main blog post linked above, you can also find the announcement blog and security guidance for Named Replicas. I also referenced a Microsoft Mechanics episode, that you can find here.


 


Something that is relatively new that we got to dive into on the show is the Database Compare Utility. Mitch van Huuksloot came on and told us all about it. You can download the zip file that contains user guides, license information, notices, and a binary folder with a configuration file and spreadsheet input.


 


We also had our friend from Azure Data Factory, Wee Hyong Tok, on to talk about some of the latest updates in Azure Data Factory. One big announcement was the new and refreshing data factory home page, resulting in a more accessible and modern experience.


 


Videos


We continued to release new and exciting Azure SQL episodes this month. Here is the list, or you can just see the playlist we created with all the episodes!



  • Mara-Florina Steiu: Track and Record Data Changes with Change Data Capture (CDC) in Azure SQL

  • Jason Anderson: Azure SQL Database Ledger​ – The power of blockchain with the simplicity of SQL

  • Rajesh Setlem: Migrating to SQL: Get Started w/ Azure SQL Readiness Assessments & Migrations from ADS (Ep. 6)

  • [MVP Edition] with Monica Rathbun: Performance Tuning on Azure SQLDB and Readable Secondaries


 


We’ve also had some great Data Exposed Live sessions. Subscribe to our YouTube channel to see them all and get notified when we stream. Here are some of the recent live streams.



  • Deep Dive: Azure Cloud Experience for Data Workloads Anywhere

  • Something Old, Something New: Not really artificial, not really intelligence (Ethics and AI with Buck Woody)

  • Azure SQL Security series: Data Protection (Ep. 3)


 


Blogs


As always, our team is busy writing blogs to share with you all. Blogs contain announcements, tips and tricks, deep dives, and more. Here’s the list I have of SQL-related topics you might want to check out.



 


Special Segment: SQL in a Minute with Cheryl Adams


Cheryl and Mark Ghanayem came on to do a segment on documentation focused on the new Azure Database Migration Guides which you can find at https://aka.ms/datamigration. The highlighted one new guide recently released which dives into how to migrate MySQL on-premises to Azure.


 


Special Guest: Hasura


Adron Hall from Hasura came to talk about some new updates and connectors for their GraphQL product that integrates with SQL Server and Azure SQL. To learn more, check out their documentation.


 


Upcoming events


As always, there are a lot of events coming up this month. Here are a few to put on your calendar and register for from the Azure Data team:


July 14: DELL Webinar
–              Microsoft SQL Server is evolving… Is your company keeping pace?, Bob Ward

July 28:
EightKB SQL Server Internals Conference
–              Inside SQL Waits, Latches, and Spinlocks, Bob Ward
–              Deep Dive: SQL Server on Azure Virtual Machine Storage, Pam Lahoud


 


July 28: Database Professionals Virtual Meetup Group
–              Notebooks 101 for SQL People, Julie Koesmarno & Barbara Valdez


 


In addition to these upcoming events, here’s the schedule for Data Exposed Live:
July 14: Azure SQL Virtual Machines Reimagined: Measuring Performance & Monitoring Health (Ep.3)
July 21:
Ask the Experts with Bob Ward and Buck Woody
July 28:
Azure Data Studio Power Hour


Plus find new, on-demand Data Exposed episodes released every Thursday, 9AM PT at aka.ms/DataExposedyt


 


Featured Microsoft Learn Module


Learn with us! This month I highlighted the module: Architect modern applications using Azure SQL Database. In this module, you’ll break down a scenario for an application and build a multi-service solution based on the microservices approach. You’ll learn how to use modern database capabilities, like those found in the Azure SQL Database, to build a foundation for applications. You’ll also learn how to use GitHub Actions for CI/CD of databases.


 


Anna’s Pick of the Month


I know blockchain capabilities in Azure SQL Database technically launched in May, however, on Data Exposed we did a short episode and a deep dive. The more I learn about this technology and the scenarios it unlocks, the more I’m excited and impressed by it. Check out the videos for yourself and tell me I’m wrong!


 


Until next time…


That’s it for now! Be sure to check back next month for the latest updates, and tune into Data Exposed Live every Wednesday at 9AM PST on LearnTV. We also release new episodes on Thursdays at 9AM PST and new #MVPTuesday episodes on the last Tuesday of every month at 9AM PST at aka.ms/DataExposedyt.


 


Having trouble keeping up? Be sure to follow us on twitter to get the latest updates on everything, @AzureSQL. You can also download the iCal link with a recurring invite!


 


We hope to see you next time, on Data Exposed :)


–Anna and Marisa

Salesforce brings sales and service data into Microsoft Teams to support a hybrid workforce

Salesforce brings sales and service data into Microsoft Teams to support a hybrid workforce

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

At Build, we shared how a new class of collaboration apps is needed to support the global structural changes for hybrid work. These apps provide a single collaborative layer to support synchronous and asynchronous working styles. We call this new class of applications collaborative apps.



The Salesforce app in Microsoft Teams is now Generally Available. Now, sales and service teams using Salesforce Sales Cloud or Service Cloud can bring account data and records into their Teams workspace for better collaboration. Sales and service reps no longer need to switch between windows to find key data; it’s all in one workspace so teams can stay aligned and work efficiently.



The integration supports the type of collaboration teams need in their current hybrid customer engagements. Sales teams need to have the most recent and relevant context about accounts as they interact with their teams and customers to provide a seamless buying experience. For service teams, it can create better coordination and faster response times to open cases, increasing customer satisfaction and reducing the support load on the team.


Teams Salesforce (1).png


 


The Salesforce integration allows customers to access their Salesforce records in Teams channels, chat conversations, and meetings. This helps increase internal alignment and save time by no longer having to switch between applications.


Teams Salesforce (2).png


 


With the Teams Integration, Salesforce users can:



  • Pin records to Teams channel tabs and chats to make them easy to find

  • Edit records directly within Teams.

  • Post important conversation moments on the Salesforce Chatter feed of records pinned on Teams channel and chat tabs.

  • Mention Salesforce records (opportunities, accounts, cases, contacts, and leads) in Teams channels and chats to facilitate collaboration.

  • Preview more details about records mentioned in Teams channels and chats.


The integration has received a high volume of interest while in pilot and we’re excited to see a collaborative app meeting our joint customers where they work.


 


To get started:
Add the Salesforce App to your Teams tenant from the Teams Admin Center. The Salesforce integration with Microsoft Teams is available to Microsoft customers licensed with Teams, and Salesforce customers with Sales and Service licenses in Enterprise, or higher editions, orgs.