Microsoft Edge for Business FAQ

Microsoft Edge for Business FAQ

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

Microsoft Edge for Business, the new, dedicated work experience currently in preview for the Microsoft Edge browser, is planned to be released with Microsoft Edge stable version 116 (scheduled for the week of August 17, 2023). All customers who sign into Edge using Microsoft Entra ID (formerly Azure Active Directory) will automatically be transitioned to Microsoft Edge for Business as part of the release.  


 


What to expect with Microsoft Edge for Business 



  • Policies, settings, and configurations previously set by an organization and its Entra ID connected users will be automatically transitioned to Edge for Business. 

  • IT maintains full control over policy and feature management and configuration with Edge for Business. 

  • The icon will be updated to include a briefcase.  

  • An optional personal browsing window, Microsoft Edge, is enabled so users with a personal profile can separate their work and personal browsing and take advantage of the full feature set of Edge for personal use. This will also enable automatic switching from the personal to work browser window when work sites are accessed. The personal browser window is lightly managed, with IT maintaining control over security, compliance, and update policies. 


 


From the beginning, Microsoft Edge was designed with the specific needs of businesses and organizations in mind, with enterprise grade security, productivity, management, and now AI, built in. Microsoft Edge for Business is the next step in the journey to deliver the best browser for business across desktop and mobile, with enhanced separation of work and personal browsing, unmanaged device support, and more coming soon.     


 


General 


Is this a new browser? 


No, this is not a new browser. This is a new, dedicated Microsoft Edge experience built for work that enables organizations to configure it to maximize productivity and security. It has the same functionality that you’re already familiar with in Microsoft Edge in addition to optional automatic switching built to help meet the evolving needs of users and businesses. Signing in with Microsoft Entra ID will automatically enable Microsoft Edge for Business.  


 


How is Edge for Business differentiated from regular Microsoft Edge? 


Microsoft Edge for Business is a dedicated work browsing experience. It’s distinguished through visual elements such as an adjusted icon and other minor visual cues.  


 


IT maintains full control over policy and feature management and configuration with Edge for Business. Meanwhile, Microsoft Edge is lightly managed, with IT maintaining control over security and compliance policies of the personal browsing window.  With users separating their work and personal browsing and content, personal data can be excluded from enterprise sync in the work browser window, giving users the privacy they want.  


 


What benefit does Microsoft Edge for Business provide? 


For IT, Microsoft Edge for Business can reduce the surface area for cyberattacks, heightening the organization’s security posture, since it offers the opportunity to streamline down to one browser for all use cases. For end users who are signed in with work and personal profiles, Edge for Business can provide a better browsing experience with automatic switching, which has security and privacy benefits.  


 


Does Microsoft Edge for Business require a separate download? 


No. Microsoft Edge for Business is automatically triggered by signing in with a Microsoft Entra ID. 


 


 


User experience 


What will the user experience be when Edge for Business becomes available? 


After Edge stable version 116 release is deployed, and the browser is restarted: 



  • The Microsoft Edge icon will be updated to the Edge for Business icon 

  • When the user launches Edge for Business, Microsoft Entra ID users will automatically be signed in 

  • A one-time banner will appear at the top of the browser after first launching Edge for Business informing the user of the change with a link to learn more  


 


What impact will the change to Edge for Business have on users? 


Users who are only signed in with Microsoft Entra ID 


After Edge stable version 116 release is deployed, and the browser is restarted, all users who sign in with Microsoft Entra ID will be transitioned to Edge for Business. Edge for Business inherits all configurations and policies previously set for Microsoft Edge, so the main difference users will see at this time is the Microsoft Edge for Business icon and a new location for their profile photo.  


 


Users who are signed in with both Microsoft Entra ID and Microsoft Account (MSA) 


Users who are also signed in with a personal profile (using their Microsoft account (MSA)) can experience automatic switching between their work browser window (Microsoft Edge for Business) and their personal browser window (Microsoft Edge).  


 


With the Edge stable version 116 release: 



  • Switching from the personal browser window to the work browser window will be on by default with the option to turn off by the user 

  • Switching from the work browser window to the personal browser window will be off by default with the option to turn on by the user. Switching from the work browser window to the personal browser window will be default on in future versions of Edge for Business.  

  • To turn on/off automatic switching, visit Edge settings and toggle on/off “Automatic profile switching”. 


 


Work-related sites, such as Microsoft 365 apps and services and sites requiring work login, automatically open in the work browser window. A growing set of popular sites open in the personal browser window once enabled by the user in Edge settings. Users can designate additional sites for work or personal use in settings. (Note: user site designation cannot be overwritten by IT administrators at this time.) 


 


What happens to favorites, passwords, etc.? 


Passwords, favorites, and data currently associated with the user’s work profile will be maintained in Edge for Business. Passwords, favorites, and data are not shared between the work browser window and the personal browser window.  


 


What impact will this cause to my default browser settings? 


There is no impact to users’ default browser settings.  


 


Will users see both the Edge and Edge for Business icons on the taskbar? 


Users that are only signed in with Entra ID will see the Edge for Business icon and not the Edge icon. 


 


Are there materials I can share with my end users to prepare them? 


Yes! A downloadable email draft is available and is linked at the bottom of this post.  


 


 


IT management and controls 


Will all policies and configurations previously set by IT be applied to Edge for Business? 


Yes, all policies and configurations currently in place will be inherited by Edge for Business.  


 


What controls will IT admins have? 


IT maintains control over the security and compliance posture of both Microsoft Edge and Microsoft Edge for Business. Edge is lightly managed, with users able to access all features, while in Edge for Business, IT can control which features are available to users. 


 


IT admins can disable the personal browser window so that their users can only access Edge for Business. Please note that in this case, users will not be able to use Microsoft account based personal profiles and will not experience automatic switching between work and personal browsing.  


 


What policies will be enabled in the personal browser window? 


The Microsoft Edge personal browser window is lightly managed, with all security, compliance, and Edge update policies applied, without the additional overhead of managing another browser. To learn more, please visit this site. 


 


How does my organization turn off the personal browser window? 


To turn off the personal browser window, please follow the steps listed in this document. 


 


Does Edge for Business support unmanaged devices? 


Yes, Edge for Business includes support for unmanaged devices, currently available in preview. Please use these steps to access this preview.  


 


Is Edge for Business available on mobile? 


Yes. Edge for Business on mobile is built with enterprise grade security, productivity, management, and now AI, built in. An updated icon, automatic switching, and management via Edge management service in the Microsoft 365 admin center will be available for Edge for Business on mobile the future. 


 


Can anyone with a Microsoft Entra ID (formerly known as Azure Active Directory) can get Microsoft Edge for Business? 


Microsoft Edge for Business will be the standard experience for all users with a Microsoft Entra ID.  


 


Will my sites and apps that work in Microsoft Edge work in Microsoft Edge for Business? 


Yes, sites and apps that currently work in Microsoft Edge will work in Microsoft Edge for Business.  


 


Are there any functional changes to the Entra ID profile? 


No. There are not any functional changes to the Entra ID profile. 


 


 


Automatic Switching 


How do I switch between the Microsoft Edge for Business browser window and the Microsoft Edge browser window? 


With the Edge stable version 116 release, URLs entered into the personal browser window that are for work-related sites, such as Microsoft 365 apps and services and sites requiring work login, will automatically open in the work browser window. 


 


Do I need to enable automatic switching? 


With this release, switching from the personal browser window to the work browser window will be on by default with the option to turn off by the user. Switching from the work browser window to the personal browser window will be off by default with the option to turn on by the user. This will be enabled by default in a future release. To turn on/off automatic switching, visit Edge settings and toggle on/off “Automatic profile switching”. 


 


Are the work and personal browser window connected? 


The work browser window (Microsoft Edge for Business) and personal browser window (Microsoft Edge) will have their own separate caches and storage locations, so information stays separate. This feature does not create any link between the user’s Microsoft Entra ID account and their MSA account, and the organization settings related to linking work and personal accounts are unaffected. There are no functional changes to the Entra ID profile. 


 


How does a user customize the work and personal URL list?  


To designate sites to open automatically in the work and personal browser windows, go to edge://settings/profiles/multiProfileSettings and select “Choose preferred browser for sites” to turn off or select a preferred profile for the applicable site. 


 


Is there a group policy to customize the work and personal URL list?  


Not at this time. 


 


Is there a group policy to turn on/off automatic switching? 


At this time, only users will be able to turn switching between work and personal browser windows on and off. 


 


For organizations that do not want automatic switching or personal profile usage, there is a group policy to turn off multiple profiles 


 


Is there a group policy to add sites to the site list? 


Not at this time. 


 


When the user switches between work and personal browser windows, are they logged out of sites and apps? 


No, switching between the work and personal browser windows will not log the user out of sites and apps.   


 


How do I adjust which browser window a site is opened in? 


There are two ways to change which browser window is used to open a website: 



  • Click the Switching icon, pictured below, to switch back to the preferred browser window. This action makes the browser remember your choice for that URL. 


RickTurner_0-1691190441444.png


 


 



  • Go to edge://settings/profiles/multiProfileSettings and select “Choose preferred browser for sites” to turn off or select a preferred profile for the applicable site. 

20 Tips for Successfully Delivering Your Virtual Event with Microsoft Teams

20 Tips for Successfully Delivering Your Virtual Event with Microsoft Teams

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

SarahGilbert_0-1690994738924.png


 


The Microsoft 365 Commercial Support Team resolves customer support cases and provides support to help you be successful and realize the full potential and value of your purchase. Our support services extend across the entire lifecycle and include pre-sales, onboarding and deployment, usage and management, accounts and billing, and break-fix support. We also spend a considerable amount of time working to improve the supportability of Microsoft 365 services to reduce the number of issues you experience as well as minimize the effort and time it takes to resolve your issues if they do occur. 


 


Today, we’re excited to share more about some of our supportability work with Microsoft Teams Live Events. 


 


Microsoft Teams Live Events and the full capabilities of Microsoft 365 make it easy for you to deliver small, medium, or large-scale virtual events to connect with employees and customers.  For the past few years, a small team within our Microsoft 365 Commercial Support organization has been helping customers prepare for, set up, and run webinars, events, and large virtual meetings as part of the Microsoft 365 Live Event Assistance Program. The team has helped deliver thousands of virtual events and engages regularly with a wide range of customers, including some of the largest enterprises. 


 


Today, I’m excited to welcome three members of our support team who work on this program to share some of their guidance, insights, and best practices for delivering successful virtual meetings using Microsoft Teams. 


 


Brian: Welcome Susheel, Saurabh, and Sylvie! Tell us a little bit about your roles and what you’ve been working on. 


 


Susheel: I am a Microsoft live events assistance engineer, and, in my role, I help customers globally make their events successful. I support them from the initial stage through to the last minute.  


 


Saurabh: I am a Microsoft virtual events assistance engineer, and, in my role, I can help you get more familiar with setting up and running an event, webinar, or large meeting and be available during the event to help if any questions or issues come up. 


 


Sylvie: I am a Support Planner, and I focus on Microsoft Teams. In my role, I get to design and enable end to end support experiences for our customers.  


 


Brian: Ok, so there are a few different meeting types with Microsoft Teams… how do you know which one is best suited to your needs? 


 


Susheel: You’re right and it really depends on the meeting size and desired capabilities. Here’s a table we use to help guide our customers in the selection. Note that this table may change as new Teams features are released. 


 


 
































































































Option 



Teams Meeting 



Webinars 



Live events



Registration feature



Not available  



Included – Can be customized  



Not available  



Attendee count 



1,000  


(If View only mode is enabled then up to 10,000 (1001-10000) users with view only permissions) 



Fully interactive audience (can talk, answer polls, etc) – up to 1,000 users.  



20,000 users in view only mode, with capabilities for Q&A  



Max Participation 



10,000  



1,000  



20,000 (Special request 100k)  



Attendee microphone 



Microphone can be disabled (which prevents attendees from enabling their microphone)  



Microphone can be disabled (which prevents attendees from enabling their microphone)  



Disabled for attendees  



Attendee camera 



All cameras can be disabled, or individual cameras can be enabled/disabled  



All cameras can be disabled, or individual cameras can be enabled/disabled  



Disabled for attendees  



Audience participation 



Interaction level can be customized by the organizer  



Interaction level can be customized by the organizer  



Limited interaction  



Join by phone (attendee) 



Yes  



Yes  



Yes  



Breakout rooms 



Can be done for only 300 attendees  



Can be done for only 300 attendees  



Not available  



Recording 



Available in Meeting Chat/ OneDrive  



Available in Meeting Chat/ OneDrive  



Stored in Azure Media Services(valid for 180 days)  



Interaction with Attendees 



Meeting Chat & Raise Hand  



Meeting Chat & Raise Hand  



Moderated Q&A  



Multiple people on Screen 



Spotlight Feature  



Spotlight Feature  



Using encoders  



MS Polls 



Yes  



Yes  



No  



Live Captions 



No  



No  



Yes  



Attendance Report 



Yes  



Yes  



Yes  



 


 


Brian: Wow, this is great. So, you’ve helped customers prepare for and deliver thousands of online events, what’s the typical event size and format? 


 


Saurabh: I am glad you asked, I have worked with customers where the size has been anything between 1k – 100k, and for simple live events the Teams Quick start events would be the first choice and for the customized events, we go for Teams encoder-based events.  These are both part of the Live Events option in the table above. 


 


Brian: What are some of the tips and tricks you’d recommend for putting on a successful event? 


 


Susheel: There’s great information to help with planning your event in: Guidance for delivering virtual events – Microsoft Adoption. 


And here are a few things that have helped our customers and are considered good practices for any meeting that you run: 


 


[1] Whenever presenters are sharing content or audio, they need to make sure their Microsoft Teams status is set to Do not disturb to avoid unwanted notifications and notification sounds from popping up and getting delivered to attendees. 


 


[2] If you are presenting or producing an event, make sure that you close out of all your unused background applications to avoid the utilization of laptop memory/processor internet load. 


 


[3] For the highest audio quality, we recommend that on-camera presenters avoid using Bluetooth audio devices as this can cause delays in audio and video sync. We suggest using hard-wired headsets and equipment. 


 


[4] One of the ways to test that the tech is ready for a live event is to create a short welcome video with audio and check with a test attendee account to ensure that audio and video are working fine. 


 


[5] Make sure to test the internet connection for presenters and producers. The bandwidth requirements can be reviewed here – Prepare your organization’s network for Teams – Microsoft Teams | Microsoft Learn 


 


SarahGilbert_1-1690997504681.png


 


 


[6] If you are running a live event from home or a remote place, make sure that no other streaming services are being used in that location at the same time (for example – Netflix, YouTube). 


 


[7] If possible, we recommend using a hardwired internet connection instead of a wireless connection to ensure high quality signal strength. 


 


[8] Make sure none of your producers or presenters are forwarding the meeting links that they receive in the mailbox (email) from the event’s organizer. This is because the role of each event member needs to be defined and forwarding links may cause permissions issues. It’s best to share the list of producers and presenters with the event organizer so the organizer can accurately define everyone’s role. 


 


[9] For audio/video content, include the system audio whenever you have a video or PowerPoint with embedded audio in it.  Details can be found in: Share sound from your computer in a Teams meeting or live event – Microsoft Support 


 


SarahGilbert_2-1690997504682.png


 


 


[10] If you forget to include system audio while you’re already presenting, you can still navigate to the top center of the screenshare (Active Screenshare) and look for the below pop-up: 


SarahGilbert_3-1690997504683.png


 


 


When including system audio, make sure no other audio programs are being played in the background. Otherwise, the audio system will include that as well.   


 


[11] Once the live event starts, the producer should mute everyone and each presenter should un-mute themselves before they start speaking. This will help to minimize disruptions during the meeting. 


 


[12] Avoid touching the END button during the live event. If you restart the live event, all the live event resources (recording, attendance report, Questions & Answers report) will be replaced with new ones.   


 


[13] If you are in pre-live mode and encounter any technical issues, you can click the RESTART button to refresh the services on the backend (allow a couple minutes for this to happen) and then rejoin the event. 


 


SarahGilbert_4-1690997504684.png


 


 


[14] All of the producers and presenters need to join the live event using the Microsoft Teams desktop application for Windows or MAC, not the web version or on a mobile device.   


 


[15] If a producer or presenter joins the live event on a mobile device, they will get redirected to the attendee link because joining as a producer or presenter on a mobile device is not supported.  Presenter roles are now supported on select IPad devices. Find more information in: Get started with Microsoft Teams live events – Microsoft Support 


 


[16] Producer and presenter roles and views are not currently supported for Linux, including Chromebooks. 


 


[17] Ensure attendees have installed the latest versions of Microsoft Teams and web browsers for highest quality results. 


 


[18] Make sure Microsoft Teams is the only meeting application running during the live event. Close out of other meeting applications (Zoom, WebEx, etc.) to avoid echo issues and resources conflicts during the event. 


 


[19] If you plan to use an encoder during your event, we recommend using the full paid versions and not the trial or free versions to ensure highest stability and support from the encoder provider. More on producing events with an encoder can be found in: Produce a Teams Live Event using Teams Encoder – Microsoft Support  And you can find the list of compatible encoders in: Encoder setup for streaming in Microsoft Teams – Microsoft Teams | Microsoft Learn 


 


[20] Details on IP, URL usage and considerations for VPN environments for live events and encoder usage can be found in:  Special considerations for Stream and live events in VPN environments – Microsoft 365 Enterprise | Microsoft Learn 


 


Brian: Great list and super helpful – thank you for sharing! The Microsoft 365 Live Events Assistance Program seems like a valuable resource, can you tell us a bit more about it? 


 


Sylvie: The Live Events Assistance Program is a unique support program. It is designed to assist customers in preparation for their large event. If you need assistance with setting up and running an event, webinar or large meeting, the team can help you configure and set up your event. They can also be available during the event if you have any questions. Check out the Microsoft 365 Live Event Assistance Program for more information. 


 


Brian: Thank you Susheel, Saurabh, and Sylvie for sharing all these great insights and information! 


 



 


SarahGilbert_5-1690997504685.png


Susheel Dogra is a Support Engineer in the CSS Modern Work Support Team focused on supporting live events using Microsoft Teams and Microsoft 365. 


 


20Tips-7.png


Saurabh D. Singh is a Support Engineer in the CSS Modern Work Support Team focused on supporting live events using Microsoft Teams and Microsoft 365. 


 


20Tips-8.png


Sylvie Bousquet-Kadackal  is a Senior Support Planner in the CSS Modern Work Supportability Team working on end-to-end support experience design for Microsoft Teams releases and programs. 


 


20Tips-9.png


Brian Stoner  is a Director in the CSS Modern Work Supportability Team where he leads a team of technical and business program managers. 


 


The CSS Modern Work Supportability Team delivers innovative self-help solutions and diagnostics, in-service enhancements, and support programs to help customers get maximum value from their Microsoft 365 commercial subscriptions and create an easy-to-use, connected support experience. 

Microsoft Learn: Updates to our training and certification portfolio

Microsoft Learn: Updates to our training and certification portfolio

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

As an IT pro, you know that staying ahead of the curve in today’s rapidly changing tech environment is critical. Your skills are key to your success—and the success of your team. Microsoft Learn has the tools, resources, and opportunities to help you build those skills and get the most value from Microsoft products and services. To keep pace with in-demand job roles and skills and to help ensure a close alignment with current workplace needs, we regularly review our training and certification portfolio. In today’s blog post, check out the latest updates.


 


Changing the name of the updated Microsoft Certified: Information Protection Administrator Associate certification and its associated exam


Security teams understand that compliance tools and features are essential for addressing the regional and industry-specific requirements that govern the collection and use of data. In a recent job-task analysis of the Microsoft Certified: Information Protection Administrator Associate certification and its associated Exam SC-400: Microsoft Information Protection Administrator, we recognized the need to expand this certification and exam to include compliance features. This resulted in the addition of two new functional groups (“Monitor and investigate data and activities by using Microsoft Purview” and “Manage insider and privacy risk in Microsoft 365”), which we’ve documented in the study guide for Exam SC-400. The updated exam that includes questions to support these groups was released on June 1, 2023.


 


Since the original titles don’t include the concept of compliance, we’re updating the certification name to the Microsoft Certified: Information Protection and Compliance Administrator Associate certification and the exam name to Exam SC-400: Administering Information Protection and Compliance in Microsoft 365. These changes are effective August 22, 2023.


 


 


If you’re preparing for Exam SC-400, you’ll be interested to know that on June 2, 2023, we added two new learning paths to help you get ready to earn certification:



 


The corresponding four-day instructor-led training, Course SC-400, was also updated on June 2, 2023, to support the new functional groups.


 


How might these updates impact you?


The following question and answer set can help you determine how this news impacts your learning journey:


 


Q. I’ve already earned the Microsoft Certified: Information Protection Administrator Associate certification. What happens now?


A.If you’ve already earned the Microsoft Certified: Information Protection Administrator Associate certification, the name will automatically update to Microsoft Certified: Information Protection and Compliance Administrator Associate on August 22, 2023, on the transcript in your profile on Microsoft Learn.


 


Retiring the Microsoft 365 Certified: Messaging Administrator Associate certification and its corresponding exam


Learners and organizations have shared their feedback that this certification should better align to current needs and the evolving business landscape. To focus on developing the right experience, we’ll retire the Microsoft 365 Certified: Messaging Administrator Associate certification and its associated Exam MS-203: Microsoft 365 Messaging, at the end of December 2023. And we’ll invest in building new exams, certifications, and training to meet the needs of today’s workplace.


 


Updates to Microsoft 365 Certified: Messaging Administrator Associate certification.Updates to Microsoft 365 Certified: Messaging Administrator Associate certification.


 


How might these updates impact you?


The following questions and answers can help you determine how this news impacts your learning journey:


 


Q. I’ve been preparing for Exam MS-203: Microsoft 365 Messaging. What are my options?


A. If you’ve been preparing for Exam MS-203, be sure to pass it before the end of December 2023. If you pass Exam MS-203 before the end of December 2023, you’ll earn the Microsoft Certified: Messaging Administrator Associate certification, and it will be active for one year.


 


Q. I’ve already earned the Microsoft 365 Certified: Messaging Administrator Associate certification. What happens now?


A. If you’ve already earned the Microsoft 365 Certified: Messaging Administrator Associate certification, it will stay on the transcript in your profile on Microsoft Learn.


 


Q. What about renewal for the Microsoft 365 Certified: Messaging Administrator Associate certification?


A. Learners with an active Microsoft 365 Certified: Messaging Administrator Associate certification can renew it for one year (one final time) up to six months after its retirement at the end of December 2023. The renewal window closes at the end of June 2024.


 

Azure SQL News Update – August 2023

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

Today Data Exposed went live at 9AM PT for a special Ask Me Anything and news update. If you missed the episode, you can find them all at https://aka.ms/AzureSQLYT. This month we’ll recap all the updates from May through July. This was a fun and informative episode, and we had great guests (and fun) with the product group and our MVP community.


 


By the way, if you want to see a summary of all the updates in 2022, check out the blog https://aka.ms/NewsUpdate2022. If you want a summary of all the updates in 2023’s first quarter, https://aka.ms/newsupdate2023q1, or from April.


 


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


In May, we released a short episode on all the updates at Microsoft Build. It’s a great one to see what landed and some awesome demos from the team. Many of the updates in this blog for Azure SQL Database started at Microsoft Build.


 


So let’s start with Azure SQL Database. We released Elastic Pools for Hyperscale as public preview at Microsoft Build. On the show, we talked more about what Elastic Pools for Hyperscale means and how to get started. Serverless for Hyperscale (preview) also now supports zone redundancy.


 


XML compression became Generally Available (GA) in SQL DB and SQL MI, which provides a method to compress off-row XML data for both XML columns and indexes, improving capacity requirements.


 


In the security space, Always Encrypted with Intel SGX enclaves in Azure SQL Database with up to 40 vCores was released in public preview on the DC-series hardware. Yes, a lot to unpack there, but basically we’re enabling you to take advantage of more cores and Always Encrypted together, more details here.


 


For developers, we released things for Azure SQL Database, but many of those updates apply to SQL Server as well. These developer focused updates include Azure Functions SQL Bindings GA, go-sqlcmd GA, Data API Builder public preview, new JSON type and JSON aggregates preview.


 


On the tooling and experiences front, since our last episode we released updates to Azure Data Studio.! In May, we added support for GitHub Copilot in Azure Data Studio, GA-ed the SQL Database Projects extension, and improved connectivity (release blog here). In July, we added more connection improvements, Object Explorer functionality, addressed your feedback and more (release notes here). Go-sqlcmd, a tool you should probably go try out now, added more enhancements to connectivity, querying, and setting up your environment.


 


For Migrations, we released a new SQL Migration journey planning experience and offline migrations to Azure SQL Database in Azure Data Studio. We also have been releasing several things in the migrating from Oracle space – Database Migration Assessment for Oracle extension GA in Azure Data Studio, Database Migration Service Pack for Oracle in preview, Database Schema Conversion Toolkit for Oracle GA in Azure Data Studio, and the Data Migration for Oracle extension preview in Azure Data Studio. So the summary is if you are trying to migrate from Oracle to Azure SQL, we got your back and are here to help, just get the extensions in Azure Data Studio!


 


For Azure SQL Managed Instance, one big announcement was the public preview of blockchain capabilities with Ledger in Azure SQL Managed Instance. This is available in Azure SQL Database and so it’s exciting to see that parity land in Azure SQL Managed Instance. We also recently added updates to SSDT including support for Ledger. Additionally, the team added some great options including all subscription types in large Azure regions are available for SQL MI, license-free Geo-DR through passive standby replica (GA), higher CPU vCores available for Premium Hardware on BC tier, and export capability for Data Virtualization in SQL MI (GA).


 


SQL Server on Azure Virtual Machines is powered by the SQL IaaS Agent extension, which enables you to get a lot of benefits for managing your SQL Server Azure VMs with ease. Pam Lahoud came on and told us about the preview of Microsoft Azure Boost (https://aka.ms/AzureBoost). Microsoft Azure Boost is the infrastructure technology behind the improved I/O performance on Ebdsv5 (#DoubleSprinklesVMs). There are many different components that improve overall price-performance, but one of the key aspects for SQL Server customers is that Azure Boost enables Azure current customers to achieve an industry leading remote storage throughput and IOPS performance of 10 GBps and 400K IOPS with our memory optimized E112ibsv5 VM using NVMe-enabled Premium SSD v2 or Ultra Disk options.


 


For Hybrid, we released several things related to deployment of Azure Arc including: at scale deployment of Best Practices Assessments using Azure policy,  simplified deployment of Arc SQL Server extension for software assurance (SA) customers, easily subscribe to Extended Security updates. On the management side, we added basic license management of SQL Servers and host properties, connecting SQL Servers to Arc at scale with flexible host configuration, support for Microsoft update to patch Arc-enabled SQL Server for critical patches, improved control of built-in automated backups and retention periods, as well as support for Azure Purview for Arc-enabled SQL Servers.


 


Last but certainly not least, we got an update on SQL Server on Linux and containers, which we don’t talk about enough on the show. We got some guidance for deploying on Kubernetes, and the assessment API (which you’ve heard about in the SQL VM and Hybrid space) is integrated with Red Hat Insights. Also, the Ansible SQL Server system role developer version and fully supported “microsoft.sql.server” part of RHEL 8 appstream is now available. SQL Server cross-platform availability groups, which include heterogeneous replicas with complete high-availability and disaster recovery support, is available with DH2i DxEnterprise. And the Azure Marketplace image for SQL Server 2022 for all distributions is available including RHEL 8 HA, Ubuntu Pro, SLES 15, plus RHEL 9 and Ubuntu 22.04 are coming soon.


 


Videos


We continued to release new and exciting episodes. Here is the list of what we released since the last News Update, or you can just see the playlist we created with all the episodes!



  • Query Store: How It Started…How It’s Going

  • [MVP Edition]: Making the Most of Clustered Columnstore Indexes in SQL Server 2022 & Azure SQL

  • [SQL Insider Series]: Microsoft Fabric (Analytics in the Era of AI)

  • Overview of Azure SQL trigger for Azure Functions

  • How to achieve data virtualization on Mainframes

  • SQL Integration with Microsoft Fabric

  • [MVP Edition]: Quickly creating containers with the new, open-source SQLCMD

  • How do you use JSON data in Azure SQL Database & SQL Server 2022

  • Calling a REST service from Azure SQL DB

  • New benefits of Azure Arc Enabled SQL Server

  • Build 2023: What’s new in Azure SQL

  • [MVP Edition] Easy APIs with Azure SQL Database

  • Ledger in Azure Managed Instance

  • What’s new in SQL Server Data Tools (SSDT)


We’ve also had some great Data Exposed Live sessions this year. Subscribe to our YouTube channel to see them all and get notified when we stream.


 


Events
If you are looking to attend some in-person and virtual events this month, the Azure Data team has you covered. We’ll be at the following events and are looking forward to seeing you there!



Multiple Dates: Data Saturdays and SQL Saturdays: Multiple events from around the globe from the Community and from RedGate
Multiple DatesMicrosoft, Partner, and Community-led Events: Events from around the world, presented by Microsoft, Microsoft Partners, and Community groups


September 11-13: SQL Koferenze: SQL Server Workshop, Keynotes, Multiple Sessions on Data, Fabric, and AI


September 8: Data: Scotland: Free event with multiple Sessions 


September 27: Future Driven Summit: Data & AI, Azure DevOps, DataOps, Power BI, integration and automation, and cloud infrastructure


November 12-17: Live! 360: Microsoft Fabric Workshop, Keynotes, Multiple Sessions on Data, Fabric, and AI
November 14-17: PASS Summit: SQL Server Workshop, Keynotes, Multiple Sessions on Data, Fabric, and AI


Special highlight on PASS Data Community Summit! Steve Jones came on the show to tell us all about what’s happening at PASS Data Community Summit, including 150+ industry leading sessions from 130+ speakers, networking opportunities, on-demand sessions, and staying ahead with cutting-edge trends. There will be learning opportunities for professionals at all stages of their careers. You can register now at www.passdatacommunitysummit.com with code DATAEXPLIVE150 to claim $150 off a 3-day pass. You know that Data Exposed will be there live and in person, so we’d love to see you there!


 


Blogs to follow


There are a lot of blogs that I follow to stay up to date. If you want more details than I give here, I recommend checking out:



 


Until next time…


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


 


Having trouble keeping up? Be sure to follow us on X to get the latest updates on everything, @AzureSQL.


 


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


–Anna and Marisa

SharePoint support for labels configured for user-defined permissions

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

Rolling out in preview, there’s now limited support for labels configured for user-defined permissions. This encryption configuration refers to the setting Let users assign permissions when they apply the label and the checkbox In Word, PowerPoint, and Excel, prompt users to specify permissions is selected:




  • When a document is labeled with user-defined permissions and uploaded to SharePoint or OneDrive, these services can now process the document so that it can be opened and edited in Office for the web, the label name is displayed in the Sensitivity column, and the encrypted file is returned in search results for the label ID.




  • Labels with this configuration are now displayed in Office for the web. However, currently, users can’t apply these labels in Office for the web and if these labels are selected, users see a message instructing them to apply the label using a desktop app.




  • The contents currently can’t be inspected for search, data loss prevention, or eDiscovery.




To support AutoSave and co-authoring for these encrypted files using a desktop app, you must have enabled co-authoring for files encrypted with sensitivity labels and for your Microsoft 365 Apps for enterprise:



  • Windows: Minimum version of 16.0.16327 from Current Channel (Preview), or minimal version of 16.0.16414 from the Beta Channel

  • macOS: Minimum version of 16.51 from Current Channel (Preview) or from the Beta Channel



Note: If you use earlier versions and co-authoring is enabled for your tenant, AutoSave and co-authoring will be temporarily disabled for documents after users apply a sensitivity label that’s configured with user-defined permissions, or users change the permissions. After they close the document and wait 10 minutes, these features are available again.

Demo 


 


Thanks for reading!