Tag Archives: microsoft
how to count data from a specific variable reporting services and management studio stored procedure
Hi I’m kind of new with management studio and reporting services, sorry for this newbies question in advance.
I’m trying to count a variable’s value each time its value changes. The flow is the following:
1st you pick a “from” date and a “to” date. From (i.e 1/5/2024) to (i.e 5/5/2024) on a report on reporting services.
2nd management studio runs a stored procedure that runs a few lines of code that brings into the report the values of every day of this variable till the “to” date. The output of all of this is a table with the variables’ values of every single day. I managed to do this with a “while from date <= to date” and addind a day in every iteration. In the end I put a select to bring the table’s values into reporting services.
Instead of this table I need this variable’s sum of values and not a column of values describing every day’s results. Can you help me out here? I’m getting
ROW 1 = 10
ROW 2 = 2
ROW 3 = 5
But I’d need it to say just 17! and not every single value.
set @IterDate=@FromDate
while @IterDate<=@ToDate
begin
INSERT into #MyTable exec My_Stored_Procedure @IterDate
set @IterDate=DATEADD(dd,1,@IterDate)
end
————————– Output ————————
select * from #MyTable
The idea would be to get only a cell’s result and not a column of results. Can you imagine something I can put in my second stored procedure to give me a final result instead of this column of values?
Thank you in advance!
Hi I’m kind of new with management studio and reporting services, sorry for this newbies question in advance. I’m trying to count a variable’s value each time its value changes. The flow is the following:1st you pick a “from” date and a “to” date. From (i.e 1/5/2024) to (i.e 5/5/2024) on a report on reporting services.2nd management studio runs a stored procedure that runs a few lines of code that brings into the report the values of every day of this variable till the “to” date. The output of all of this is a table with the variables’ values of every single day. I managed to do this with a “while from date <= to date” and addind a day in every iteration. In the end I put a select to bring the table’s values into reporting services. Instead of this table I need this variable’s sum of values and not a column of values describing every day’s results. Can you help me out here? I’m getting ROW 1 = 10ROW 2 = 2ROW 3 = 5 But I’d need it to say just 17! and not every single value. set @IterDate=@FromDatewhile @IterDate<=@ToDatebeginINSERT into #MyTable exec My_Stored_Procedure @IterDateset @IterDate=DATEADD(dd,1,@IterDate)end————————– Output ————————select * from #MyTable The idea would be to get only a cell’s result and not a column of results. Can you imagine something I can put in my second stored procedure to give me a final result instead of this column of values? Thank you in advance! Read More
Win 11 doesn’t let me start the computer.
I have five-year-old Dell desktop. Since windows 11 installed itself, I have been having trouble getting it to wake from hibernation. Today it won’t wake at all. The monitor power button light pulses, but the screen stays black. The CPU power light is on. I can restart the computer by unplugging it, but Windows still won’t start. No combination of keys seems to get me into the windows, safety mode or the bios. This is scary
I have five-year-old Dell desktop. Since windows 11 installed itself, I have been having trouble getting it to wake from hibernation. Today it won’t wake at all. The monitor power button light pulses, but the screen stays black. The CPU power light is on. I can restart the computer by unplugging it, but Windows still won’t start. No combination of keys seems to get me into the windows, safety mode or the bios. This is scary Read More
Microsoft Virtualization Migration Options
Happy July everyone! Brandon Wilson here today to talk to you a bit about virtualization migration options, and the recent change in landscape for it…
First, let me say that this is not intended to be a deep-dive into technical aspects of the migration process, but rather a high level of how we can assist you, and what products you may want to migrate to, and why… (I will hold the door open for potential more in-depth technical articles). So, let’s get started!
What we are seeing in the field, is a change in landscape that is bringing Hyper-V, Azure Stack HCI, Azure virtual machines, System Center Virtual Machine Manager (SCVMM), Windows Admin Center, and Azure Arc front and center for customers. As a result of using competitor virtualization products for an extended amount of time, many companies tend to lack expertise within their current staff and can use a little help to hit the ground running (and even get longer term assistance). Even with similar skillsets in play, migrating to a new product can be an entirely different experience. While many of the underlying concepts of the virtualization platforms are very similar, there is a difference in terminology in addition to knowledge gaps that can confuse the process.
I have the tremendous opportunity (or privilege rather) to lead a field team tackling these efforts, working alongside the PG and our support teams to help ensure customer success in these areas. Since I have this conversation many times a day, I wanted to give a rundown of the options, and when/why you might want to consider them. If you’ve had this conversation with me, one of my team, or one of our awesome Program Managers “in person” already, then you have an idea of what I will be covering in this blog (and there are certainly many of you). If you have not yet had this conversation, please reach out to your CSAM(s) and ask them to contact me, and we will get things rolling for you!
Let’s talk about Azure Arc first, as it can help you understand how to better futureproof your on-premises environment. Azure Arc provides you with the ability to manage servers and services outside of Azure, to include Windows and Linux, Kubernetes clusters, Azure data services, SQL Server, and virtual machines/hosts (to include VMWare). Azure Arc provides a hook into VMWare (vSphere), SCVMM, Azure Stack HCI, and Hyper-V hosts (Windows Servers) and virtual machines from Azure.
Additionally, if you are planning to manage your Hyper-V datacenter using SCVMM after migrating, Azure Arc enabled SCVMM allows you to manage your VMs in a self-service fashion and secure, govern, monitor and patch your machines using Azure management services. In addition, you can build your own automation and self-service VM management pipelines using the Azure APIs, SDKs, Terraform and Bicep templates provided via Arc-enabled SCVMM.
All of these hooks, in turn allow you to prepare your environment for the future state, both from an infrastructure AND security perspective (MDE, Sentinel, RBAC…honestly there’s some serious advantages).
Image source: Governance, security, and compliance baseline for Azure Arc-enabled servers – Cloud Adoption Framework | Microsoft Learn
From a cost perspective, the main/core control plane features necessary are FREE. While some components to involve a cost, for the purposes of this article, I am really only concerned with the following:
It’s also important to note that some upcoming features in Windows Server 2025 will require Azure Arc, such as hotpatching.
Bonus link: What’s New in Windows Server v.Next (Windows Server 2025): What’s New in Windows Server v.Next (microsoft.com)
Now, our options!…
Hyper-V (Windows Server)
What is it?
A built-in feature in Windows Server versions that needs little introduction…
Provides a method for Windows Server to provide virtualization for virtual machines
When combined with the power of the System Center suite (SCVMM, SCOM, SCORCH), Hyper-V offers a rich feature set comparable to competitor virtualization products
Provides a method of future proofing your environment via Azure Arc, and optionally, migration to Azure virtual machines, SaaS, or PaaS services.
Reasons to migrate to Hyper-V on Windows Server:
Hyper-V on Windows Server may make sense if:
You have recently purchased hardware or have invested a lot into your on-premises infrastructure that you cannot write off at the moment.
You are using a SAN for your storage (Azure Stack HCI will not be an option)
Your storage and compute needs grow independently
Unable to modernize currently, whether thats due to hardware investments, political landscapes, regulatory compliance, application development, or any other current blocker
You need an OS with long-term support (up to 10 years)
You have large cluster requirements (17+ nodes)
Isolated environment/unable to connect to Azure
Reference links:
Hyper-V on Windows Server | Microsoft Learn (PDF download: windows-server virtualization | Microsoft Learn)
Windows Server 2022 Licensing & Pricing | Microsoft
Hyper-V Technology Overview | Microsoft Learn
System requirements for Hyper-V on Windows Server | Microsoft Learn
Supported Windows guest operating systems for Hyper-V on Windows Server and Azure Stack HCI | Microsoft Learn
Supported Linux and FreeBSD virtual machines for Hyper-V on Windows Server and Windows | Microsoft Learn
Supported CentOS and Red Hat Enterprise Linux virtual machines on Hyper-V | Microsoft Learn
Supported Debian virtual machines on Hyper-V | Microsoft Learn
Supported Oracle Linux virtual machines on Hyper-V | Microsoft Learn
Supported SUSE Linux Enterprise Server (SLES) virtual machines on Hyper-V | Microsoft Learn
Supported Ubuntu virtual machines on Hyper-V | Microsoft Learn
Supported FreeBSD virtual machines on Hyper-V | Microsoft Learn
AVS (Azure VMWare Solution)
NOTE: Microsoft has partnered with Broadcom for license portability (see: Microsoft and Broadcom to support license portability for VMware Cloud Foundation on Azure VMware Solution | Microsoft Azure Blog)
What is it?
Azure VMWare Solution (AVS) offers a “private cloud” hosted in an Azure datacenter that makes use of a dedicated bare-metal Azure infrastructure to host your VMWare infrastructure.
Allows for up to 16 hosts per cluster, with VMWare features including vCenter, vSphere, vSAN, and NSX
Microsoft offers VBD (Value Based Deliverables) for these efforts to help you understand and land your migration from on-premises VMWare to Azure VMWare Solution
Reasons to migrate to AVS:
Requires less upskilling than is potentially necessary for a transition to SCVMM and Hyper-V, Azure Stack, or potentially even Azure VMs
Locks you into pricing that is not impacted by other licensing cost inflation for up to 5 years (via Azure reservations). NOTE: AVS reservations are NOT subject to the newer Azure reservations exchange policies!
AVS can be purchased with VMWare Cloud Foundation (VCF) subscriptions included (no purchase through 3rd parties necessary)
Offers BYOL (bring your own licensing) coverage
Lift and shift from on-premises to Azure VMWare Solution, helping to potentially lower costs in key areas. Ask your account team about the Migration Factory (it can have some great incentives!).
DR (disaster recovery), whether side by side with efforts to migrate to other Microsoft products, or for your current on-premises solutions
Even if you are primarily moving to Hyper-V, Azure Stack, or even Azure virtual machines, if you will continue to have a VMWare footprint post-migration, it could make sense to evaluate AVS as a potential replacement for your on-premises VMWare infrastructure, and capitalize on reuse of any additional hardware you may have left afterwards.
Reference links:
Azure VMware Solution Documentation Hub – Azure VMware Solution | Microsoft Learn (PDF download: azure azure-vmware | Microsoft Learn)
Reserved instances of Azure VMware Solution – Azure VMware Solution | Microsoft Learn
Azure Stack HCI
What is it?
NOTE: You must currently have, or to lease/purchase HCI compatible hardware (https://aka.ms/azurestackhcicatalog)
A software defined approach, to include hypervisor, software defined storage, virtualized networking, and provides a hybrid approach (requires Azure subscription)
Dual supportability from Microsoft and hardware manufacturers (the same can be said for Hyper-V as well)
Hypervisor based on the potentially familiar Hyper-V compute resources
Allows for various usages, to include virtualization of Windows and Linux virtual machines, Azure Virtual Desktop (AVD), Azure Kubernetes Services (AKS)
Reasons to migrate to Azure Stack HCI:
If you already own HCI compatible hardware
If you own a mix of HCI compatible hardware and non-compatible hardware, it may make the most sense to mix and match your migration options.
Azure services include monitoring, backup, site recovery, and more
Accessible through Azure portal, ARM, Bicep, Azure CLI, and other tools
Arc enabled by default, allowing you to modernize and prepare for the future of your infrastructure
Reference links:
Azure Stack HCI documentation | Microsoft Learn (PDF download: azure-stack hci | Microsoft Learn)
Azure Stack HCI solution overview – Azure Stack HCI | Microsoft Learn
Pricing – Azure Stack HCI | Microsoft Azure
Azure Stack HCI – Hyperconverged Infrastructure | Microsoft Azure
Compare Azure Stack HCI to Windows Server – Azure Stack HCI | Microsoft Learn
Azure Stack HCI FAQ | Microsoft Learn
Azure Virtual Machines, SaaS, and PaaS
What is it?
Modern infrastructure that allows you to select from selectable sizing of virtual machines that allow for the specifications you need
Allows for a potential of serverless solutions to take the everyday maintenance tasks off your plate, and offload them to Microsoft, allowing your team to focus on more important tasks
Provides you a direct move to a future state, allowing for the flexibility that Azure can offer, whether that be performance monitoring, configuration management, and ongoing development of applications
Reasons to migrate to Azure Virtual Machines:
Ability to save on costs via reservations over numerous resources
Ability to save on costs via savings plans for compute resources
Ability to utilize your current licenses for Azure Hybrid Benefits (AHB)
Ability to use Azure policy for governance
Ability to use Azure Advisor to get recommendations based on the well-architected framework to optimize your infrastructure holistically
Take advantage of burstable and spot virtual machines where possible to maximize your savings potential for those workloads that don’t need a constant high resource virtual machine
Provides access to multiple offerings from Microsoft, to include assessments, landing zones, workshops, and more…
Reference links:
Virtual machines in Azure – Azure Virtual Machines | Microsoft Learn (PDF download: azure virtual-machines | Microsoft Learn)
Virtual machine sizes overview – Azure Virtual Machines | Microsoft Learn
Overview of Azure Dedicated Hosts for virtual machines – Azure Virtual Machines | Microsoft Learn
Use Azure Spot Virtual Machines – Azure Virtual Machines | Microsoft Learn
B family VM size series – Azure Virtual Machines | Microsoft Learn
B Series CPU Credit Model – Azure Virtual Machines | Microsoft Learn
Get started with the Cloud Adoption Framework – Cloud Adoption Framework | Microsoft Learn
How to use the Azure Well-Architected Framework documentation – Microsoft Azure Well-Architected Framework | Microsoft Learn
Azure Serverless | Microsoft Azure
Overview – Azure App Service | Microsoft Learn
Now let’s talk about management options…
System Center Virtual Machine Manager (SCVMM) + System Center suite
An equivalent to 3rd party virtualization management methods. This includes being able to include Hyper-V, Azure Stack HCI, and even VMWare infrastructures to simplify management
Provides a method to simplify migration to Hyper-V or Azure Stack
Requires System Center licensing, with SCVMM having cores per server charge.
Can be Arc enabled to get self-serve VM management capabilities and unlock Azure management services.
Azure Arc enabled SCVMM allows to build automation and self-service pipelines using Python, Java, JavaScript, Go and .NET SDKs, Terraform and Bicep templates, Azure REST APIs, Azure CLI, and Azure PowerShell.
Reference links:
System Center—Licensing & Pricing | Microsoft
Virtual Machine Manager documentation | Microsoft Learn (PDF download: system-center vmm-sc-vmm-2022 | Microsoft Learn)
Azure Arc-enabled System Center Virtual Machine Manager | Microsoft Learn
Azure Arc (I talked about this a bit above, so won’t go into this much)
An integrated method of management for Hyper-V, Azure Stack HCI, Azure virtual machines
Provides for extended functionality all areas of the well-architected framework and cloud adoption framework
Allows you to manage on-premises servers and extend functionality into the cloud
Reference links:
Azure Arc | Microsoft Learn (PDF download: azure azure-arc | Microsoft Learn)
Azure Arc overview – Azure Arc | Microsoft Learn
Azure Arc-enabled System Center Virtual Machine Manager | Microsoft Learn
Azure Arc-enabled servers | Microsoft Learn
Pricing – Azure Arc | Microsoft Azure
Governance, security, and compliance baseline for Azure Arc-enabled servers – Cloud Adoption Framework | Microsoft Learn
Windows Admin Center
No additional costs (included with Windows Server license)
Allows you to manage on-premises servers and extend functionality into the cloud
Can be installed on a workstation (Windows 11), or on a server to allow it to act as a gateway for management from any workstation
Reference links:
Windows Admin Center Overview | Microsoft Learn (PDF download: windows-server manage windows-admin-center | Microsoft Learn)
What is Windows Admin Center | Microsoft Learn
Azure Portal, PowerShell, Azure CLI, etc
When it comes to management of Azure virtual machines, you have multiple options, to include the portal, PowerShell, Azure CLI, and any other interface that allows you to manage Azure resources!
How can we assist, and what to prepare for…
NOTE: We are currently only able to provide assistance with Unified or Premier customers. Please reach out to your CSAM (Customer Success Account Manager) and ask them to reach out to me directly for more information, and to get my team engaged to assist!
Let’s briefly cover how we can assist…
Within our CSA Global Delivery organization (which offers assistance with both Azure and on-premises technologies), we can offer virtualization migration assistance by:
Determining the initial needs and scope, and begin the efforts alongside you in order to better determine the efforts that may be needed to complete the project
Review of your existing virtualization environment and identification of the migration options that would work best for your infrastructure
Assistance with any proof of concept/pilot for Hyper-V, Azure Stack HCI, AVS, Azure virtual machines, System Center Virtual Machine Manager (SCVMM), Azure Arc, or Windows Admin Center
Assistance with the design/architecture for planning your pilot and future infrastructure
Assistance with the rollout of required components (ex: SCVMM, Hyper-V, and Azure Arc)
Provide guidance and knowledge transfer along the way while handholding your efforts.
We don’t do the migration for you (ie; “hands on keyboard”), we help you along in the process, providing you with knowledge transfer, helping to ensure best practices are being implemented, etc.
Due to the significant potential differences from customer to customer, along with the time it would take to develop individual architecture documentation, we do not provide individual runbooks or custom architecture documentation. We will, however, provide guidance for your own development of this documentation, in addition to helping you deploy your pilot, and get through your migration.
Provide dedicated resources (ie; Enhanced Designated Engineering package) both for assistance during your migration efforts, but also afterwards to assist you with your new infrastructure proactively.
Pricing, because given the situation our customers are in, cost matters….
In most cases, we work off your existing Unified (or Premier) contract hours and credits, and we will typically start with a bundle of hours to get the ball rolling. Depending on your needs, the assistance needed may grow beyond the initial hours (it typically does).
We can also work with any partners you may have helping you in the migration process!
Contributors: Brandon Wilson (POD Lead (Sr CSA) – Azure Infrastructure/Platforms/Virtualization), Elden Christensen (Principal Group PM Manager), Dan Cuomo (Principal PM Lead), Jeff Woolsey (Principal PM Manager), Karthik K R (Product Manager), and Pradeep Gandluru (Principal Group SW Engineering Manager).
Microsoft Tech Community – Latest Blogs –Read More
Summarize list into group with total values
I made a monthly statement report and require the list of items to be categorized with the total values. What is a suitable formula/table format that can be used to categorized them?
I made a monthly statement report and require the list of items to be categorized with the total values. What is a suitable formula/table format that can be used to categorized them? Read More
Intune can’t work on Huawei Phone recently
Hi,
I am using a Huawei Phone with Harmony OS, since this week the Intune can’t pass the ‘Device Registration’ step. It worked well before, is there any change on Intune recently? Thanks!
Hi, I am using a Huawei Phone with Harmony OS, since this week the Intune can’t pass the ‘Device Registration’ step. It worked well before, is there any change on Intune recently? Thanks! Read More
Unable to change Folder Content Type to Document Set or Vise Versa
Hoping I can get some assistance.
Issue: I have a SharePoint library that uses document sets. This library is sync’d to a few staff members local computers so they can manage files. Staff have been creating new folders in the local explorer. This is fine, however they folders are created as the content type “Folder” instead of the document set content type. We used to be able to go into the SharePoint library on the browser and change the content type from folder from the information pane, now we can only do it using rest api. Does anyone know when this feature will be available or if there is a setting I need to turn on to make it work?
Hoping I can get some assistance.Issue: I have a SharePoint library that uses document sets. This library is sync’d to a few staff members local computers so they can manage files. Staff have been creating new folders in the local explorer. This is fine, however they folders are created as the content type “Folder” instead of the document set content type. We used to be able to go into the SharePoint library on the browser and change the content type from folder from the information pane, now we can only do it using rest api. Does anyone know when this feature will be available or if there is a setting I need to turn on to make it work? Read More
One person is not receiving phone calls from the Auto attendant
Hello
Please i need your help on this issue.
One of my user is not able to receives calls that comes from the auto attendant.
She can receives direct calls but when it comes from the auto attendant she is not receiving the phone calls on her Teams Desktop App.
Hello Please i need your help on this issue.One of my user is not able to receives calls that comes from the auto attendant. She can receives direct calls but when it comes from the auto attendant she is not receiving the phone calls on her Teams Desktop App. Read More
Can’t record teams meetings scheduled through bookings
Can’t record teams meetings scheduled through bookings
Can’t record teams meetings scheduled through bookings Read More
Best practices for giving Copilot M365 large files (PDF, Excel and Word)
Hello everyone,
I want to know if there are any best practices for delivering good summaries for large files while working with Copilot. I have tried to do summaries from PDFs with Copilot in Word and it gives me the message “file is too large for Copilot to process”, it takes only the first part of the file.
When I tried this type of case in Excel files that have a lot of information and the message is about the same. “This table is too big to analyze trends”.
The question is, how can I work with large files or, are there any best practices for dividing files so I can use Copilot prompts with them?
Thanks!
Hello everyone,I want to know if there are any best practices for delivering good summaries for large files while working with Copilot. I have tried to do summaries from PDFs with Copilot in Word and it gives me the message “file is too large for Copilot to process”, it takes only the first part of the file.When I tried this type of case in Excel files that have a lot of information and the message is about the same. “This table is too big to analyze trends”.The question is, how can I work with large files or, are there any best practices for dividing files so I can use Copilot prompts with them?Thanks! Read More
Another Issue with previous row/column references
This is a (simpler, I believe) variant of referring to PREVIOUS rows/columns issue but I still can’t get my head around it:
Given this:
I want to insert in B2 a dynamic function which will show in each cell (B2:E2) the Row 1 value of the current column minus (or plus or whatever) the Row 2 value in the immediately preceding column, resulting, in this case, in
10 15 15 25
Using the bleeding edge version of 365.
This is a (simpler, I believe) variant of referring to PREVIOUS rows/columns issue but I still can’t get my head around it:Given this:I want to insert in B2 a dynamic function which will show in each cell (B2:E2) the Row 1 value of the current column minus (or plus or whatever) the Row 2 value in the immediately preceding column, resulting, in this case, in 10 15 15 25 Using the bleeding edge version of 365. Read More
Sneaky Windows 10 update:
I have a windows 10 pro laptop and received a notice for an update required to go from 22H2 to 23H2 which I thought was a new version of Windows 10. When the update finished they had installed windows 11 without my permission. I think this is a terrible practice as I was not ready nor did I want to upgrade at this time. I have Windows 11 on other Pc’s and really don’t like it and prefer windows 10 as it avoids the windows 11 constant bombardment of advertising and useless apps and constant invasion of privacy that has gotten so much worse with Windows 11. So anyone with Windows 10 be careful of this deceptive practice or you will be tricked like me. Very dissappointing experience.
I have a windows 10 pro laptop and received a notice for an update required to go from 22H2 to 23H2 which I thought was a new version of Windows 10. When the update finished they had installed windows 11 without my permission. I think this is a terrible practice as I was not ready nor did I want to upgrade at this time. I have Windows 11 on other Pc’s and really don’t like it and prefer windows 10 as it avoids the windows 11 constant bombardment of advertising and useless apps and constant invasion of privacy that has gotten so much worse with Windows 11. So anyone with Windows 10 be careful of this deceptive practice or you will be tricked like me. Very dissappointing experience. Read More
Bing Web Master data not updated for 4 days
I run a site and have been tracking its searches traffic on Bing Webmaster Tools, where it shows clicks and impressions. However, the data stopped updating and has been stuck for last 4 days with no updates related to my site’s performance on Bing. My site is iotools.cloud and it helps people with various online front end tools. Does anyone have the same issue or found any updates from Bing?
I run a site and have been tracking its searches traffic on Bing Webmaster Tools, where it shows clicks and impressions. However, the data stopped updating and has been stuck for last 4 days with no updates related to my site’s performance on Bing. My site is iotools.cloud and it helps people with various online front end tools. Does anyone have the same issue or found any updates from Bing? Read More
Calculating which % of users fill out different data points
Hi,
I have a list of users for my company platform and I’m trying to use the data to create stats but I’m not very familiar with excel. For example, I’m trying to understand what percentage of users have actually made a post on the platform. How do I do this?
Example of data:
Hi, I have a list of users for my company platform and I’m trying to use the data to create stats but I’m not very familiar with excel. For example, I’m trying to understand what percentage of users have actually made a post on the platform. How do I do this? Example of data: Read More
What URLs are allowed when a device is in isolation?
I have a customer who’s asking what URLs are allowed when a device has been set to “Isolated”. I know there’s full isolation (where the only thing allowed is the Defender ATP service) and selective isolation (for Windows devices which allows Outlook, Teams and Skype for Business).
Per “Take response actions on a device in Microsoft Defender for Endpoint – Microsoft Defender for Endpoint“, when isolating a device, “only certain processes and destinations are allowed.”
So:
#1-is there a more detailed list of what’s allowed?
#2-is it configurable?
Thanks!
I have a customer who’s asking what URLs are allowed when a device has been set to “Isolated”. I know there’s full isolation (where the only thing allowed is the Defender ATP service) and selective isolation (for Windows devices which allows Outlook, Teams and Skype for Business).
Per “Take response actions on a device in Microsoft Defender for Endpoint – Microsoft Defender for Endpoint”, when isolating a device, “only certain processes and destinations are allowed.”
So:
#1-is there a more detailed list of what’s allowed?
#2-is it configurable?
Thanks! Read More
Am i going to be automatically upgraded to office 2024
I currently subscribe to Microsoft Office, and I currently have the latest version
(Version 2407 Build 16.0.17830.20016) 64-bit
I don’t know if this is already office 2024 or not. If it’s not, will I automatically recieve the new Office 2024, or will I have to purchase it again? There isn’t any infomation currently on the internet to answer my question.
I currently subscribe to Microsoft Office, and I currently have the latest version(Version 2407 Build 16.0.17830.20016) 64-bit I don’t know if this is already office 2024 or not. If it’s not, will I automatically recieve the new Office 2024, or will I have to purchase it again? There isn’t any infomation currently on the internet to answer my question. Read More
Microsoft at TechCon365 – Washington, D.C. (August 12-16, 2024)
“This was by far the most robust, wide ranging, and useful collection of content I’ve ever had delivered through a conference. Next time I attend, I’ll definitely be bringing my colleagues!”
– Previous TechCon365 attendee (Note to future attendees: Bring your colleagues. :))
What: TechCon365 – D.C.
Register today |Use the MSCMTY discount code to save $200 USD off registration.
Content: 1 Microsoft keynote + 1 AMA || 140 overall sessions – 52 Microsoft-led sessions (review all Microsoft-led sessions) | 25 full-day workshops
Microsoft is sending over 30+ product makers to present and engage.
Review all sessions + agenda view, workshops, and their full speaker lineup.
When & where: August 12-16, 2024
In-person: Washington, D.C. – Walter E. Washington Convention Center
Twitter & hashtag: @TechCon365 | #TechCon365
Cost: $850 – $2,775 (Learn more about ticket pricing options) – Use our MSCMTY code to get a $200.00 USD discount.
At TechCon365 – D.C., a Microsoft 365 Conference & Power Platform Conference, the subject matter is divided into tracks and each session is designated for beginner, intermediate, advanced or expert.
Explore the latest in Microsoft 365 and AI innovations.
Amp up your expertise with Power Platform insights.
Network with top industry leaders and IT pros.
Acquire actionable knowledge to elevate your career.
With 2 optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops presented by Microsoft 365, SharePoint, Power Platform, Microsoft Teams, Viva, Azure, Copilot & AI’s top experts! Whether you are new to Microsoft 365, Power Platform and SharePoint or an experienced power user, admin or developer, TechCon365 has content designed to fit your experience level and area of interest.
See how the Microsoft 365, SharePoint Power Platform, Azure, and AI ecosystem is growing and evolving by speaking with technical experts from the local Microsoft field and diverse channels within the Microsoft Partner Network – all in our exhibit hall (25 sponsors).
Microsoft keynotes, sessions, and workshops: Copilot/AI, SharePoint, OneDrive, Teams, Viva, Power Platform, D&I, and related technology
Microsoft keynote, Ask Microsoft Anything (AMA), and inspiring Diversity & Inclusion meetup
Hear from Microsoft leadership revealing the latest innovations shaping the flexible, innovative, and secure business environments of the future. Plus, a unique opportunity to ask your questions. [all times listed in EDT]
Microsoft 365 keynote: “Thriving in the era of AI”
Presenter: Karuana Gatimu, Principal PM Manager – Microsoft 365 Community and Adoption Group, Microsoft
Date/Time: Wednesday, August 14th, 8:30am – 9:40am EDT
Location: Ballroom A
Panelists: Karuana Gatimu, Bob Ward, Pat Mahoney, Naomi Moneypenny, and Kristi Kelly
Date/time: Wednesday, August 14th, 1:10pm – 2:20pm EDT
Location: Ballroom B
“Women in Tech and Allies Meetup”
Panelists: Karuana Gatimu, Kristi Kelly, Tiffany Lee, Naomi Moneypenny, and Rima Reyes
Date/time: Thursday, August 15th, 4:20pm – 5:30pm
Location: Room 207A
Register today | Note: Use the MSCMTY discount code to save $200 USD off registration.
Take the opportunity to select the sessions best suited for your role and interests. All breakouts bring product updates, demos, customer stories, best practices, and insights into product and solution strategy – including guidance on the future.
And find us in the Community Zone – A place to connect with Microsoft MVPs, MCM, Microsoft Regional Directors, and user group leaders via Ask the Experts tables and in the Community Lounge when you can pick up some laptop stickers and learn more about community programs in the Exhibit Hall.
TechCon365 | Microsoft-led breakout sessions and workshops
It is crucial to ensure your organization is technically ready for the full potential of Copilot for Microsoft 365. The sessions below focus on technical readiness and ensuring you have the latest guidance. Our experts will share best practices and provide guidance on how to leverage AI and to maximize the benefits of Microsoft 365, Power Platform, and Microsoft Fabric throughout your organization. Note: All breakout sessions are 70 minutes.
Copilot and AI
“The Art of Prompt Engineering in M365 Copilot” with Michelle Gilbert
“Technical Readiness for Copilot for Microsoft 365” with Ben Summers
“The AI Enabled Agency” with Kevin Tupper
“Empowering US Federal Agencies with Microsoft Copilot: A Roadmap to AI Democratization” with Steve Winward and Jay Leask
“Citizens Services and Generative AI – A new way to engage!” with Dave Bailey and Daniel Cox
“Protect at the speed and scale of AI with Microsoft Copilot for Security” with Rick Engle
“Securing the Future: AI-Enhanced Cybersecurity in Federal Agencies” with Brian Trich
“Copilot Extensibility: Updates from Microsoft Build” with Bob German
“Getting Started Making Copilots with Assistants, Graph, and AI Search” with Fabian Williams and Doug Ware
“Learning Hack: Building Smarter Skilling with Copilot” with Tom Resing and Paul Stubbs
“Bring your business data into Microsoft Copilot with Plugins and Connectors” with Bob German
WORKSHOP | “Building Generative AI Applications: GPTs, Copilots, and Chatbots” with Doug Ware and Fabian Williams
Microsoft 365
“Delivering User Satisfaction and Adoption Practices for Microsoft 365” with Karuana Gatimu
“How Microsoft Federal Supports the US Government” with Jason Payne and Karuana Gatimu
“The Future of Your Intranet: Beautiful, flexible and AI ready powered by SharePoint” with Katelyn Helms
“Unlock SharePoint Premium content services by connecting Azure Pay-as-you-go billing” with Tom Resing
“Teams Emergency Operations Center – Modernizing communications in critical incidents” with Tiffany Lee and Josh Leporati
“What’s New for Microsoft 365 Admins” with Josh Leporati
“Top 10 best practices every admin should be doing in Microsoft 365” with Michelle Gilbert
“Managing Change in a Microsoft World! Office 365 Governance and Change Management” with Michelle Gilbert
“Mastering Microsoft Lists” Tiffany Lee and Josh Leporati
“New Planner: Unifying Task Management in Microsoft Teams” with Alexander Lahuerta
“Building Multi-tenant apps for Microsoft 365” with Bob German and Julie Turner
“Introduction to the Microsoft Graph” with Fabian Williams
“Unlock Third Party or Line of Business Data using Graph Connectors and Copilot “ with Fabian Williams
WORKSHOP | “Ultimate guide to administering M365 and Teams” with Michelle Gilbert
Microsoft Viva
“What’s new and next for Microsoft Viva” with Kristi Kelly
“Getting started with Viva Amplify” with Naomi Moneypenny
“AI in Viva Engage for communications and knowledge management” with Kristi Kelly
Power Platform
“Power Platform and Dynamics 365 in the Federal Government” with Brendon Colburn
“Better Together: Azure + Power Platform in the Federal Government” with Jamie Willis-Rose, Chris Boretos, and Ruth Delaney
“Securing and governing the Power Platform at scale” with Ken Aguillard
“Have you met your new Trainer? – AI as a learning tool in the Power Platform” with Craig Harris
“To Build or Buy: Case Management in Dynamics 365 or Power Apps” with Jamie Willis-Rose
“Modernizing Paper Form Processing with Power Platform and AI” with Jamie Willis-Rose and Sunny Eltepu
“Build enterprise web sites with Power Pages” with Meera Mahabala
“Dataverse Virtual Tables – Build a Custom Provider” with Jim Novak
Microsoft Fabric and Power BI
“Threads of Innovation: A Comprehensive Overview of Microsoft Fabric” with Pat Mahoney
“Unify your data with OneLake and Microsoft Fabric” with Matt Basile
“Ingest, Transform, and Act in Real-Time with Microsoft Fabric” with Tzvia Gitlin Troyna
“Connect to your M365 Data with Microsoft Fabric and Microsoft Graph Data Connect” with John White and Jason Himmelstein
“Getting Started with SQL, AI, and Microsoft Fabric” with Bob Ward
“Deep Dive on Power BI, Teams and SharePoint” with John White and Jason Himmelstein
“Healthcare Virtual Data Tables” with Jim Novak
“Power BI Analytics at Scale with Microsoft Fabric” with John White and Jason Himmelstein
“There’s No Time Like the Present – Real Time Reporting with Power BI” with John White and Jason Himmelstein
“Protect and Manage Your Enterprise Data Effectively at Scale for safeguarding AI-enabled application” with Mihaela Blenda
“Security and Compliance in Microsoft Fabric” with Rick Xu
WORKSHOP | “Everything You Wanted to Know About Power BI… but were afraid to ask!” with John White and Jason Himmelstein
Register today | Note: Use the MSCMTY discount code to save $200 USD off registration.
Get the most out of TechCon365: Our top five tips while attending
Introduce yourself | Unique perspectives await, including yours.
Attend as much as you can | Laptops down, eyes open – depth learning, tips, and tricks abound.
Share what you know |Your knowledge saves time – pay it forward.
Ask questions, share feedback | Your issues and ideas Inform us and influence the roadmap.
Hydrate and dress for steps | Keep the brain healthy and mind active.
BONUS | Update your LinkedIn profile and photo | Best reflect your professional experience and growing technical aptitude.
Learn more
Visit TechCon365.com/DC and follow the action on X/Twitter: @TechCon365, @Microsoft365, @MSFTCopilot, @SharePoint, @OneDrive, @MicrosoftTeams, @MSPowerPlat, @MicrosoftFabric, @MSPowerBI, @Microsoft365Dev, and @MSFTAdoption.
I hope you will join us in D.C. for what will be a fantastic week “near the capitol”! We’re looking forward to the action alongside the community, MVPs, and Microsoft product members from Copilot, Teams, Office, SharePoint, OneDrive, Loop, Viva, Power Platform, Lists, Planner, and more.
Remember, use the discount code MSCMTY discount code to save $200 USD off your conference registration. Register today!
Last, a glimpse of the TechCon365 event experience:
Cheers,
Karuana Gatimu and Heather Cook
Microsoft Tech Community – Latest Blogs –Read More
Save Costs with Basic SKU Application Gateway for more features and less fixed costs
Hi All!
If you are one of the customers looking to save Costs with Application Gateway for better features than v1 SKU with limited applications as backend pools, here is a post for you!
The Azure Application Gateway Basic SKU is an excellent choice for customers who have applications with lower traffic and do not necessitate high Service Level Agreements (SLAs). This feature is currently in public preview. It’s a cost-effective solution that still provides core application-level load balancing features, such as URL-based, host-based, and multi-site routing, as well as cookie-based affinity. This SKU supports a variety of flexible backends, including Azure Kubernetes Service (AKS), Virtual Machine Scale Sets (VMSS), App Services, and on-premises deployments. With built-in high availability and support for HTTP2/HTTPS and WebSocket protocols, the Basic SKU ensures reliable application delivery without the need for advanced traffic management features. For small to medium-sized enterprises or developers seeking a balance between functionality and cost, the Azure Application Gateway Basic SKU presents a compelling option.
Let’s delve into the details of the Azure Application Gateway Basic SKU. This SKU is designed for applications with lower traffic and SLA requirements, and it doesn’t require advanced traffic management features.
Here are the key points:
Advantages of Basic SKU:
Basic SKU Features:
High Availability: The Basic SKU includes built-in high availability.
Protocol Support: It supports HTTP2/HTTPS and WebSocket protocols.
Load Balancing: Core application-level load balancing features include URL-based, host-based, and multi-site routing, along with cookie-based affinity.
Key Vault integration capabilities
Header Rewrite
Comparison with Standard V2 SKU:
Performance: The Basic SKU is suitable for smaller workloads with a restriction of the number of backend pools supported upto 5 and also supports zone redundancy, while the Standard V2 SKU offers higher performance, autoscaling, zone redundancy, private application gateway, private link, mTLS and static VIPs.
Autoscaling: The Standard V2 SKU allows autoscaling based on changing traffic patterns, whereas the Basic SKU doesn’t offer autoscaling.
Static VIP: Basic SKU exclusively supports static VIPs, ensuring the VIP associated with the application gateway remains unchanged throughout its lifecycle.
URL Rewrite: Only Standard V2 SKU allows you to add, remove, or update an URL.
Security: When there is a need to use Web Application Firewall, it is better to choose WAF V2 SKU over Basic SKU as Basic SKU Application Gateway doesn’t support Web Application Firewall yet.
When to Use Basic SKU:
Lower Traffic Workloads: Choose the Basic SKU for applications with lower traffic.
Cost Savings: If advanced features aren’t necessary, Basic SKU provides cost savings.
Zone Redundancy: If you need zone redundancy only for limited number of applications served as backends, choose the Basic SKU but if you need zone redundancy along with autoscaling, consider Standard V2 SKU.
Limitations of Basic SKU:
Now let’s explore the limitations of the Azure Application Gateway Basic SKU:
Limited Performance:
The Basic SKU is designed for smaller workloads and has lower performance compared to the Standard V2 SKU. If your application requires high throughput or autoscaling, consider the Standard V2 SKU instead.
No Autoscaling:
Unlike the Standard V2 SKU, the Basic SKU does not support autoscaling based on changing traffic patterns. You’ll need to manually adjust capacity if traffic increases.
Fewer Advanced Features:
The Basic SKU lacks some advanced features available in Standard V2, such as URL rewrite capabilities, private application gateway, private link, Web Application Firewall and mTLS (Mutual TLS Authentication).
Remember to choose the SKU that aligns with your application’s requirements and budget.
Differences between feature support with Basic SKU and Standard V2 SKU Application Gateway
The following table displays a comparison between Basic and Standard_v2.
Feature
Capabilities
Basic SKU (preview)
Standard v2 SKU
Reliability
SLA
99.9
99.95
Functionality – basic
HTTP/HTTP2/HTTPS
Websocket
Public/Private IP
Cookie Affinity
Path-based affinity
Wildcard
Multisite
KeyVault
AKS (via AGIC)
Zone
Header rewrite
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
Functionality – advanced
URL rewrite
mTLS
Private Link
Private-only1
TCP/TLS Proxy
✓
✓
✓
✓
✓
Scale
Max. connections per second
Number of listeners
Number of backend pools
Number of backend servers per pool
Number of rules
2001
5
5
5
5
625001
100
100
1200
400
Capacity Unit
Connections per second per compute unit
Throughput
Persistent new connections
10
2.22 Mbps
2500
50
2.22 Mbps
2500
1Estimated based on using an RSA 2048-bit key TLS certificate.
Here is the source from where I got the differences between Basic SKU and Standard V2 SKU Application Gateway Capabilities.
Additional information/resources:
If you want to try Basic SKU in your lower environments for testing while it is in public preview, please use this article to proceed with the steps to register for the Basic SKU feature in public preview. While preview features are not something we recommend customers to use in production environment, consider production-ready Standard V2 SKU Application Gateway for production workloads. For more information on when the Basic SKU Application Gateway feature will be generally available (GA), stay tuned to Azure Updates.
Savings with fixed costs on Application Gateway Basic SKU:
[I have a Basic SKU Application Gateway with a single backend which is an app service in the East US region with zone redundancy enabled.]
Standard SKU Comparison on Pricing:
[ I have a Standard SKU Application Gateway with a single backend which is an app service in the East US region with zone redundancy enabled.]
For more information on Pricing details and calculations, please check Application Gateway Pricing | Microsoft Azure.
How to register for preview feature Basic SKU Application Gateway using Azure CLI:
https://learn.microsoft.com/en-us/azure/application-gateway/overview-v2#register-for-the-preview
I hope you found this information useful.
Happy reading!
FastTrack for Azure: Move to Azure efficiently with customized guidance from Azure engineering. FastTrack for Azure – Benefits, and FAQ | Microsoft Azure
Microsoft Tech Community – Latest Blogs –Read More
Zelle AI42 Probleme
Hallo Leute in der Zelle AI42 steht ,,#Bezug!,, dadurch kann ich keine Rechnungen mehr machen. Wenn ich die Zelle versuche, zu ändern, kommt immer ,,die Zelle ist schreibgeschützt. Könnt ihr ihr mir bitte helfen?
Hallo Leute in der Zelle AI42 steht ,,#Bezug!,, dadurch kann ich keine Rechnungen mehr machen. Wenn ich die Zelle versuche, zu ändern, kommt immer ,,die Zelle ist schreibgeschützt. Könnt ihr ihr mir bitte helfen? Read More
How to delete rows that have a 0 in every column but not rows that have 1 column thats not 0
I have an excel sheet with 8000+ rows of data, there is 18 columns.
each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in that sample (column).
i want to delete the rows where each column is a zero (essentially no samples have that bacteria). Is there an easy way to do this? Because doing it by hand for 8000+ rows is taking a long time
thank you!
I have an excel sheet with 8000+ rows of data, there is 18 columns. each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in that sample (column). i want to delete the rows where each column is a zero (essentially no samples have that bacteria). Is there an easy way to do this? Because doing it by hand for 8000+ rows is taking a long time thank you! Read More
Force automatic log outs on Entra Shared Device (iPhone)
I feel really dumb but can’t find how to force Microsoft 365 apps on an Entra Shared Device mode to automatically log out after a certain time?
We have Inventory devices that are used by multiple people and I want them to be logged out automatically after 5 minutes of inactivity, and by « inactivity », I mean 5 minutes of not using a 365 app
I feel really dumb but can’t find how to force Microsoft 365 apps on an Entra Shared Device mode to automatically log out after a certain time? We have Inventory devices that are used by multiple people and I want them to be logged out automatically after 5 minutes of inactivity, and by « inactivity », I mean 5 minutes of not using a 365 app Read More