Month: October 2024
Advanced Alerting Strategies for Azure Monitoring
Keeping an eye on your Azure environment is key to making sure everything runs smoothly. While Azure Service Health gives you the basics for tracking incidents and maintenance, there’s a lot more you can do to stay ahead. To really build a smart, robust notification strategy, you’ll need to move beyond the default alerts and use more advanced tools to cover all your bases.
In this post, we’ll dive into how you can set up customized alerts for different scenarios like security recommendations, service retirements, and product updates. We’ll also show you how to integrate these alerts into the platforms your team already uses, like Microsoft Teams, Slack, or PagerDuty. No matter the size of your team or your cloud setup, these strategies will help you stay proactive and minimize risks in your Azure environment.
Why Expand Beyond Azure Service Health Alerts?
Azure Service Health alerts are excellent for monitoring the availability of core Azure services and receiving updates on ongoing incidents. However, what if you need to receive notifications on security misconfigurations, new service recommendations, or upcoming product retirements? This is where Azure’s ecosystem of monitoring and alerting tools comes into play.
Organizations, especially those running complex Azure environments, often require notifications that cover:
Optimization Recommendations (e.g., cost, security, and performance)
Security Advisories and compliance gaps
Product-Specific Notices (e.g., updates for operating systems)
Feature Deprecations and End-of-Life (EOL) announcements
To tackle these diverse needs, Azure offers a suite of tools, including Azure Advisor, Resource Health, Microsoft Defender for Cloud, and more. Let’s break down how to use each of these tools to set up comprehensive alerts for your environment.
Advanced Notification Strategies with Azure
Here’s how you can leverage Azure’s built-in tools to expand your notification coverage:
1. Azure Advisor Recommendations
Azure Advisor provides proactive recommendations for optimizing cost, performance, security, and reliability. It analyzes your resources and offers guidance to optimize your cloud usage. You can configure alerts to receive these recommendations as soon as they are generated.
Real-World Scenario:
A tech startup uses Azure Advisor to receive cost optimization recommendations and avoid unexpected expenses. By configuring alerts for these recommendations, they ensure that their finance team is informed of potential savings opportunities.
Steps to Set Up Azure Advisor Alerts:
Navigate to Azure Advisor in the Azure Portal.
Select Alerts and create a new alert rule using Azure Monitor.
Filter for the recommendation type (e.g., Security or Cost Optimization).
Link to an Action Group with your distribution list.
For more details, visit the Azure Advisor Overview.
For more precise alerting, consider Azure Monitor’s Dynamic Thresholds feature, which uses machine learning to automatically adjust alert thresholds based on historical patterns in your data. This helps reduce false positives and ensures your alerts are more context-aware, especially in fluctuating environments. Learn more about configuring Dynamic Thresholds here.
2. Azure Service Health for Critical Announcements
Service Health provides alerts for planned maintenance, incidents, and health advisories, making it ideal for tracking changes that may require immediate action.
Real-World Scenario:
A healthcare provider uses Service Health alerts to track planned maintenance events for critical workloads, ensuring they can plan around maintenance windows and avoid service disruptions.
Steps to Configure Health Advisory Alerts:
Go to Azure Service Health.
Create an Activity Log Alert for the Health Advisory category.
Link to an Action Group targeting your distribution list.
Check out a real example of Service Health Advisory Alerts for Retirement Notices to see how it works in practice.
Did you know that certain alert types, such as Activity Log Alerts, Service Health Alerts, and Resource Health Alerts, are free of charge? By leveraging these where possible, you can save on monitoring costs. Additionally, reducing the frequency of log-based alerts or narrowing the scope of metric alerts can significantly cut down expenses. Learn more about cost optimization in Azure Monitor.
3. Azure Resource Health for Resource-Level Monitoring
Resource Health provides insights into the health of individual Azure resources such as VMs, databases, and storage accounts. Use this tool to track localized outages, planned maintenance events, and performance degradation.
Real-World Scenario:
An e-commerce company monitors Resource Health for its production VMs to receive alerts on resource-level failures. When an issue is detected, they are able to reroute traffic to unaffected regions.
Steps to Set Up Resource Health Alerts:
Navigate to Azure Resource Health.
Create alerts based on Resource Health statuses (e.g., Unavailable or Under Maintenance).
Link alerts to your distribution list for targeted notifications.
4. Service Retirement Workbook (Public Preview)
Azure’s new Service Retirement Workbook provides a centralized view of upcoming service retirements and deprecations, helping you track affected resources and plan migrations accordingly.
Real-World Scenario:
A financial services firm uses the Service Retirement Workbook to track SQL Server feature retirements, ensuring that their compliance team is informed of any potential risks and can plan upgrades well in advance.
How to Use the Service Retirement Workbook:
Access the Service Retirement Workbook.
Review upcoming service retirements and their impact on your resources.
Create custom alerts through Azure Monitor to track changes.
For more information on how to identify deprecated services in your subscriptions, check this helpful guide on Identifying Deprecated Azure Services.
5. Microsoft Defender for Cloud for Security Advisories
Microsoft Defender for Cloud offers security alerts, compliance insights, and recommendations to help you secure your environment. You can receive alerts on misconfigurations, vulnerabilities, and compliance issues, routed directly to your team.
Real-World Scenario:
A SaaS company uses Defender for Cloud to monitor security misconfigurations across its Azure environment, ensuring that the DevOps team is notified whenever new vulnerabilities are detected.
Setting up Security Alerts in Defender for Cloud:
Go to Defender for Cloud.
Configure alerts for specific security recommendations.
Link your distribution list to receive email notifications.
For those looking to centralize and correlate security alerts, Azure Monitor can forward alerts to Azure Sentinel, a cloud-native SIEM solution. Sentinel helps security teams perform deeper investigations across multiple services and respond to potential threats more effectively. Learn more about how Azure Sentinel can enhance your security monitoring here.
Best Practices for Managing Alerts
To make the most of these tools, consider the following best practices:
Use Tags for Resource Filtering: Apply tags like Environment=Production or Department=Finance to resources, and use these tags to filter which resources should trigger alerts.
Leverage RBAC for Alert Management: Assign roles appropriately to avoid unauthorized changes to alert rules.
Test Alerts Regularly: Run periodic tests to ensure alerts are functioning as expected and reaching the right recipients.
Avoid Alert Fatigue: Use dynamic thresholds and severity-based filtering to reduce noise and focus on high-impact events.
Alert fatigue can easily overwhelm teams, leading to critical notifications being overlooked. Azure Monitor’s Alert Processing Rules can help streamline notifications, suppressing unnecessary alerts during maintenance or scheduled downtime and prioritizing high-impact events. For more information, check out the Alert Processing Rules documentation.
Integrate Alerts with Collaboration Tools
Connect your Azure alerts to Microsoft Teams, Slack, or PagerDuty to streamline incident management and ensure that your team can respond quickly to critical issues. Check here about using webhooks for that: Azure Monitor action groups – Azure Monitor
Example:
By integrating Azure Monitor Alerts with Teams, an operations team receives real-time notifications directly in their Teams channels, enabling faster incident response.
Adding Automation for Faster Response
Consider using Azure Automation or Logic Apps to create auto-remediation workflows. For example, if a VM goes down, a Logic App can automatically restart it, minimizing downtime without human intervention.
References:
Customize alert notifications by using Logic Apps – Azure Monitor | Microsoft Learn
Runbook execution in Azure Automation | Microsoft Learn
Quick Reference Table for Alert Tools
Tool
Use Case
Type of Alerts
Azure Advisor
Cost, Security, and Performance Optimization
Recommendations
Azure Service Health
Service Incidents and Planned Maintenance
Health Advisories, Incidents, Maintenance
Azure Resource Health
Resource-Specific Outages and Degradations
Resource Unavailable, Under Maintenance
Service Retirement Workbook
Service Deprecations and EOL Announcements
Service Retirements, Feature Deprecations
Microsoft Defender for Cloud
Security Alerts and Compliance Recommendations
High Severity Security Alerts, Compliance Gaps
Common Pitfalls and How to Avoid Them
While setting up alerts and notifications is straightforward, there are a few common pitfalls that organizations run into. Here’s how to address them:
Alert Storming: When multiple resources trigger alerts simultaneously due to a cascading failure. To avoid this, consider using Suppression Rules in Azure Monitor.
Incorrect Action Group Configurations: Misconfigured Action Groups can result in missing alerts. Always test your Action Groups before going live.
High Volume of Low-Severity Alerts: Receiving too many low-severity alerts can cause alert fatigue. Use **Dynamic Thresholds** to focus on high-impact issues.
Summary
With a combination of Azure Advisor, Service Health, Resource Health, the Service Retirement Workbook, and Microsoft Defender for Cloud, you can achieve a comprehensive alerting strategy that keeps your team informed and proactive. By integrating these tools with your collaboration platforms and automating responses, you’ll minimize risks and ensure smooth cloud operations.
Microsoft Tech Community – Latest Blogs –Read More
Flagged emails don’t show up in To Do in Mac computer.
I’ve logged in to Outlook and To Do with the same email address on my Mac. Unfortunately, the flagged emails on my Outlook don’t show up in To Do under flagged email section (please see below).
I have tried logging out and back in. I have updated my office apps.
I’ve logged in to Outlook and To Do with the same email address on my Mac. Unfortunately, the flagged emails on my Outlook don’t show up in To Do under flagged email section (please see below). I have tried logging out and back in. I have updated my office apps. Read More
New Webinar: Unlock AI positive impact with Trustworthy AI
The Azure AI Partner Council is hosting a one-hour conversation on Trustworthy AI. The webinar is on October 17th from 8:00-9:00 am PST. Microsoft’s subject matter experts will explore the latest developments in trustworthy AI with a focus on security, safety, and privacy.
Topics to explore:
Trustworthy AI narrative & announcement overview
AACS feature updates/CTAs & demo of Groundedness rewriting
Evaluation feature updates/CTAs & demo of indirect prompt injection attacks evals
Confidential computing for Whisper model demo/CTAs
Live Q&A
Register Here for Unlock AI Positive impact with Trustworthy AI on October 17th at 8:00AM PST.
The Azure AI Partner Council is hosting a one-hour conversation on Trustworthy AI. The webinar is on October 17th from 8:00-9:00 am PST. Microsoft’s subject matter experts will explore the latest developments in trustworthy AI with a focus on security, safety, and privacy.
Topics to explore:
Trustworthy AI narrative & announcement overview
AACS feature updates/CTAs & demo of Groundedness rewriting
Evaluation feature updates/CTAs & demo of indirect prompt injection attacks evals
Confidential computing for Whisper model demo/CTAs
Live Q&A
Register Here for Unlock AI Positive impact with Trustworthy AI on October 17th at 8:00AM PST.
Read More
Problem viewing appointments in Bookings app
We have been utilizing Microsoft Bookings for the past couple years to schedule all parent teacher conferences at our K12 district. We have had minor issues in the past using Bookings, but recently, all our administrators are unable to view any appointments from within the app. All appointments display “Busy”, and we are unable to view or edit any appointments. This behavior is displayed in the Bookings web application, the Bookings application from within Outlook, and the Bookings application from within Teams.
However, we are able to view all appointments and details from within the Virtual Appointments application from within Teams. This does not include appointment details though, or any custom questions asked from the Bookings service. Our building secretaries need to have the ability to reschedule appointments, and view all appointment details, and that is not achievable from the Virtual Appointments app.
Has anybody seen this issue, and is there a resolution to this behavior?
We have been utilizing Microsoft Bookings for the past couple years to schedule all parent teacher conferences at our K12 district. We have had minor issues in the past using Bookings, but recently, all our administrators are unable to view any appointments from within the app. All appointments display “Busy”, and we are unable to view or edit any appointments. This behavior is displayed in the Bookings web application, the Bookings application from within Outlook, and the Bookings application from within Teams. However, we are able to view all appointments and details from within the Virtual Appointments application from within Teams. This does not include appointment details though, or any custom questions asked from the Bookings service. Our building secretaries need to have the ability to reschedule appointments, and view all appointment details, and that is not achievable from the Virtual Appointments app. Has anybody seen this issue, and is there a resolution to this behavior? Read More
Announcing Windows Server Preview Build 26304
Announcing Windows Server Preview Build 26304
Hello Windows Server Insiders!
Today we are pleased to release a new build of the next Windows Server Long-Term Servicing Channel (LTSC) Preview that contains both the Desktop Experience and Server Core installation options for Datacenter and Standard editions, Annual Channel for Container Host and Azure Edition (for VM evaluation only). Branding has been updated for the upcoming release, Windows Server 2025, in this preview – when reporting issues please refer to Windows Server 2025 preview. If you signed up for Server Flighting, you should receive this new build automatically.
What’s New
[NEW] Windows Defender Application Control for Business (WDAC)
Windows Defender Application Control (WDAC) for business is a software-based security layer that reduces attack surface by enforcing an explicit list of software that is allowed to run. For Windows Server 2025, we have provided Microsoft defined ‘default policy’ which can be applied to the server via PowerShell cmdlets, powered by our ‘Security configuration platform called ‘OSconfig’.
To learn more, please review Windows Defender Application Control for Business (WDAC) – Microsoft Community Hub.
Windows Server 2025 Security Baseline Preview
Beginning with build 26296, we are pleased to announce the availability of the Windows Server 2025 Security Baseline Preview. You can enable security right from the start by applying the recommended security posture for your device or VM role through application of a tailored security baseline, with over 350 preconfigured Windows security settings that help you apply and enforce granular security settings that support best practices recommended by Microsoft and Industry standards. We have organized the Windows Server 2025 Security Baseline content into three categories based on server role:
Domain Controller (DC)
Member Server
Workgroup Member
Note: You should preview the security baseline only on test systems. While there is a ‘Remove’ command, not all configurations can be reversed.
To learn more, please review Announcing Windows Server 2025 Security Baseline Preview – Microsoft Community Hub.
Windows Server Flighting is here!!
If you signed up for Server Flighting, you should receive this new build automatically later today.
For more information, see Welcome to Windows Insider flighting on Windows Server – Microsoft Community Hub
The new Feedback Hub app is now available for Server Desktop users! The app should automatically update with the latest version, but if it does not, simply Check for updates in the app’s settings tab.
Known Issues
Download Windows Server Insider Preview (microsoft.com)
Flighting: The label for this flight may incorrectly reference Windows 11. However, when selected, the package installed is the Windows Server update. Please ignore the label and proceed with installing your flight. This issue will be addressed in a future release.
WinPE – Powershell Scripts: Applying the WinPE-Powershell optional component does not properly install Powershell in WinPE. As a result, Powershell cmdlets will fail. Customers who are dependent on Powershell in WinPE should not use this build.
If you are validating upgrades from Windows Server 2019 or 2022, we do not recommend that you use this build as intermittent upgrade failures have been identified for this build.
This build has an issue where archiving eventlogs with “wevetutil al” command causes the Windows Event Log service to crash, and the archive operation to fail. The service must be restarted by executing “Start-Service EventLog” from an administrative command line prompt.
If you have Secure Launch/DRTM code path enabled, we do not recommend that you install this build.
Available Downloads
Downloads to certain countries may not be available. See Microsoft suspends new sales in Russia – Microsoft On the Issues.
Windows Server Long-Term Servicing Channel Preview in ISO format in 18 languages, and in VHDX format in English only.
Windows Server Datacenter Azure Edition Preview in ISO and VHDX format, English only.
Microsoft Server Languages and Optional Features Preview
Keys: Keys are valid for preview builds only
Server Standard: MFY9F-XBN2F-TYFMP-CCV49-RMYVH
Datacenter: 2KNJJ-33Y9H-2GXGX-KMQWH-G6H67
Azure Edition does not accept a key
Symbols: Available on the public symbol server – see Using the Microsoft Symbol Server.
Expiration: This Windows Server Preview will expire September 15, 2025.
How to Download
Registered Insiders may navigate directly to the Windows Server Insider Preview download page. If you have not yet registered as an Insider, see GETTING STARTED WITH SERVER on the Windows Insiders for Business portal.
We value your feedback!
The most important part of the release cycle is to hear what’s working and what needs to be improved, so your feedback is extremely valued. Beginning with Insider build 26063, please use the new Feedback Hub app for Windows Server if you are running a Desktop version of Server. If you are using a Core edition, or if you are unable to use the Feedback Hub app, you can use your registered Windows 10 or Windows 11 Insider device and use the Feedback Hub application. In the app, choose the Windows Server category and then the appropriate subcategory for your feedback. In the title of the Feedback, please indicate the build number you are providing feedback on as shown below to ensure that your issue is attributed to the right version:
[Server #####] Title of my feedback
See Give Feedback on Windows Server via Feedback Hub for specifics. The Windows Server Insiders space on the Microsoft Tech Communities supports preview builds of the next version of Windows Server. Use the forum to collaborate, share and learn from experts. For versions that have been released to general availability in market, try the Windows Server for IT Pro forum or contact Support for Business.
Diagnostic and Usage Information
Microsoft collects this information over the internet to help keep Windows secure and up to date, troubleshoot problems, and make product improvements. Microsoft server operating systems can be configured to turn diagnostic data off, send Required diagnostic data, or send Optional diagnostic data. During previews, Microsoft asks that you change the default setting to Optional to provide the best automatic feedback and help us improve the final product.
Administrators can change the level of information collection through Settings. For details, see http://aka.ms/winserverdata. Also see the Microsoft Privacy Statement.
Terms of Use
This is pre-release software – it is provided for use “as-is” and is not supported in production environments. Users are responsible for installing any updates that may be made available from Windows Update. All pre-release software made available to you via the Windows Server Insider program is governed by the Insider Terms of Use.
Announcing Windows Server Preview Build 26304
Hello Windows Server Insiders!
Today we are pleased to release a new build of the next Windows Server Long-Term Servicing Channel (LTSC) Preview that contains both the Desktop Experience and Server Core installation options for Datacenter and Standard editions, Annual Channel for Container Host and Azure Edition (for VM evaluation only). Branding has been updated for the upcoming release, Windows Server 2025, in this preview – when reporting issues please refer to Windows Server 2025 preview. If you signed up for Server Flighting, you should receive this new build automatically.
What’s New
[NEW] Windows Defender Application Control for Business (WDAC)
Windows Defender Application Control (WDAC) for business is a software-based security layer that reduces attack surface by enforcing an explicit list of software that is allowed to run. For Windows Server 2025, we have provided Microsoft defined ‘default policy’ which can be applied to the server via PowerShell cmdlets, powered by our ‘Security configuration platform called ‘OSconfig’.
To learn more, please review Windows Defender Application Control for Business (WDAC) – Microsoft Community Hub.
Windows Server 2025 Security Baseline Preview
Beginning with build 26296, we are pleased to announce the availability of the Windows Server 2025 Security Baseline Preview. You can enable security right from the start by applying the recommended security posture for your device or VM role through application of a tailored security baseline, with over 350 preconfigured Windows security settings that help you apply and enforce granular security settings that support best practices recommended by Microsoft and Industry standards. We have organized the Windows Server 2025 Security Baseline content into three categories based on server role:
Domain Controller (DC)
Member Server
Workgroup Member
Note: You should preview the security baseline only on test systems. While there is a ‘Remove’ command, not all configurations can be reversed.
To learn more, please review Announcing Windows Server 2025 Security Baseline Preview – Microsoft Community Hub.
Windows Server Flighting is here!!
If you signed up for Server Flighting, you should receive this new build automatically later today.
For more information, see Welcome to Windows Insider flighting on Windows Server – Microsoft Community Hub
The new Feedback Hub app is now available for Server Desktop users! The app should automatically update with the latest version, but if it does not, simply Check for updates in the app’s settings tab.
Known Issues
Download Windows Server Insider Preview (microsoft.com)
Flighting: The label for this flight may incorrectly reference Windows 11. However, when selected, the package installed is the Windows Server update. Please ignore the label and proceed with installing your flight. This issue will be addressed in a future release.
WinPE – Powershell Scripts: Applying the WinPE-Powershell optional component does not properly install Powershell in WinPE. As a result, Powershell cmdlets will fail. Customers who are dependent on Powershell in WinPE should not use this build.
If you are validating upgrades from Windows Server 2019 or 2022, we do not recommend that you use this build as intermittent upgrade failures have been identified for this build.
This build has an issue where archiving eventlogs with “wevetutil al” command causes the Windows Event Log service to crash, and the archive operation to fail. The service must be restarted by executing “Start-Service EventLog” from an administrative command line prompt.
If you have Secure Launch/DRTM code path enabled, we do not recommend that you install this build.
Available Downloads
Downloads to certain countries may not be available. See Microsoft suspends new sales in Russia – Microsoft On the Issues.
Windows Server Long-Term Servicing Channel Preview in ISO format in 18 languages, and in VHDX format in English only.
Windows Server Datacenter Azure Edition Preview in ISO and VHDX format, English only.
Microsoft Server Languages and Optional Features Preview
Keys: Keys are valid for preview builds only
Server Standard: MFY9F-XBN2F-TYFMP-CCV49-RMYVH
Datacenter: 2KNJJ-33Y9H-2GXGX-KMQWH-G6H67
Azure Edition does not accept a key
Symbols: Available on the public symbol server – see Using the Microsoft Symbol Server.
Expiration: This Windows Server Preview will expire September 15, 2025.
How to Download
Registered Insiders may navigate directly to the Windows Server Insider Preview download page. If you have not yet registered as an Insider, see GETTING STARTED WITH SERVER on the Windows Insiders for Business portal.
We value your feedback!
The most important part of the release cycle is to hear what’s working and what needs to be improved, so your feedback is extremely valued. Beginning with Insider build 26063, please use the new Feedback Hub app for Windows Server if you are running a Desktop version of Server. If you are using a Core edition, or if you are unable to use the Feedback Hub app, you can use your registered Windows 10 or Windows 11 Insider device and use the Feedback Hub application. In the app, choose the Windows Server category and then the appropriate subcategory for your feedback. In the title of the Feedback, please indicate the build number you are providing feedback on as shown below to ensure that your issue is attributed to the right version:
[Server #####] Title of my feedback
See Give Feedback on Windows Server via Feedback Hub for specifics. The Windows Server Insiders space on the Microsoft Tech Communities supports preview builds of the next version of Windows Server. Use the forum to collaborate, share and learn from experts. For versions that have been released to general availability in market, try the Windows Server for IT Pro forum or contact Support for Business.
Diagnostic and Usage Information
Microsoft collects this information over the internet to help keep Windows secure and up to date, troubleshoot problems, and make product improvements. Microsoft server operating systems can be configured to turn diagnostic data off, send Required diagnostic data, or send Optional diagnostic data. During previews, Microsoft asks that you change the default setting to Optional to provide the best automatic feedback and help us improve the final product.
Administrators can change the level of information collection through Settings. For details, see http://aka.ms/winserverdata. Also see the Microsoft Privacy Statement.
Terms of Use
This is pre-release software – it is provided for use “as-is” and is not supported in production environments. Users are responsible for installing any updates that may be made available from Windows Update. All pre-release software made available to you via the Windows Server Insider program is governed by the Insider Terms of Use. Read More
Dynamic Pivot in SQL Query without DECLARE
I have a custom/dynamic SQL to PIVOT column values. As number of Columns are not fixed it could increase or decrease we cannot have normal PIVOT .Instead we need to identify columns dynamically and prepare a dynamic SQL as well.COLUMN_NAME and COLUMN_VALUE needs to be PIVOTED number of rows in these 02 columns may increase decrease on each day run.Posting dummy data as main data cannot be posted.This query works great on database but since our Reporting Tool like Tableau etc. cannot support advance SQL like dynamic or DECLARE keywordsHence is there a way to do the same thing without DECLARE like getting Columns list (comma separated) in CTE with STRING_AGG or somethingKindly help me writing PIVOT which pivots columns dynamically without DECLARE
USE [DBOOO];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [SA0067].[UNPIVOT] (
[RECORD_ID] int NULL,
[METRIC_NAME] varchar(255) NULL,
[NAME] varchar(255) NULL,
[COLUMN_Name] nvarchar(4000) NULL,
[COLUMN_VALUE] nvarchar(255) NULL)
)
;
GO
—-INSERT statement
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (1,’ABC’,’AJ’,’ID’,1);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (2,’ABC’,’AK’,’ID’,6);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (3,’XYZ’,’RJ’,’ID’,4);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (4,’XYZ’,’JK’,’ID’,5);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (5,’XYZ’,’JJJ’,’ID’,11);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (6,’REC’,’MJ’,’ID’,42;
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (7,’REC’,’SG’,’ID’,33);
— DYNAMIC SQL thats needs to be re-written
DECLARE @COLUMNNAMES NVARCHAR(MAX)=”
DECLARE @SQL NVARCHAR(MAX)=”
;WITH COL_NM
AS
(SELECT DISTINCT ‘[‘+COLUMN_NAME+’],’ AS CN FROM DBOOO.[SA0067].[UNPIVOT])
SELECT @COLUMNNAMES +=CN FROM COL_NM
SET @COLUMNNAMES =LEFT(@COLUMNNAMES,LEN(@COLUMNNAMES)-1)
SET @SQL =’SELECT * FROM (
SELECT RECORD_ID,METRIC_NAME,NAME,COLUMN_Name,COLUMN_Value
FROm DBOOO.[SA0067].[UNPIVOT]
) t
PIVOT
( MAX(COLUMN_Value)
FOR COLUMN_Name IN (‘+@COLUMNNAMES+’)
) AS PT’
EXECUTE sp_executesql @SQL
I have a custom/dynamic SQL to PIVOT column values. As number of Columns are not fixed it could increase or decrease we cannot have normal PIVOT .Instead we need to identify columns dynamically and prepare a dynamic SQL as well.COLUMN_NAME and COLUMN_VALUE needs to be PIVOTED number of rows in these 02 columns may increase decrease on each day run.Posting dummy data as main data cannot be posted.This query works great on database but since our Reporting Tool like Tableau etc. cannot support advance SQL like dynamic or DECLARE keywordsHence is there a way to do the same thing without DECLARE like getting Columns list (comma separated) in CTE with STRING_AGG or somethingKindly help me writing PIVOT which pivots columns dynamically without DECLARE USE [DBOOO];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [SA0067].[UNPIVOT] (
[RECORD_ID] int NULL,
[METRIC_NAME] varchar(255) NULL,
[NAME] varchar(255) NULL,
[COLUMN_Name] nvarchar(4000) NULL,
[COLUMN_VALUE] nvarchar(255) NULL)
)
;
GO
—-INSERT statement
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (1,’ABC’,’AJ’,’ID’,1);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (2,’ABC’,’AK’,’ID’,6);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (3,’XYZ’,’RJ’,’ID’,4);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (4,’XYZ’,’JK’,’ID’,5);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (5,’XYZ’,’JJJ’,’ID’,11);
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (6,’REC’,’MJ’,’ID’,42;
INSERT INTO [SA0067].[UNPIVOT] ([RECORD_ID],[METRIC_NAME],[NAME],[COLUMN_Name],[COLUMN_VALUE] ) VALUES (7,’REC’,’SG’,’ID’,33);
— DYNAMIC SQL thats needs to be re-written
DECLARE @COLUMNNAMES NVARCHAR(MAX)=”
DECLARE @SQL NVARCHAR(MAX)=”
;WITH COL_NM
AS
(SELECT DISTINCT ‘[‘+COLUMN_NAME+’],’ AS CN FROM DBOOO.[SA0067].[UNPIVOT])
SELECT @COLUMNNAMES +=CN FROM COL_NM
SET @COLUMNNAMES =LEFT(@COLUMNNAMES,LEN(@COLUMNNAMES)-1)
SET @SQL =’SELECT * FROM (
SELECT RECORD_ID,METRIC_NAME,NAME,COLUMN_Name,COLUMN_Value
FROm DBOOO.[SA0067].[UNPIVOT]
) t
PIVOT
( MAX(COLUMN_Value)
FOR COLUMN_Name IN (‘+@COLUMNNAMES+’)
) AS PT’
EXECUTE sp_executesql @SQL Read More
Understanding Data Ingestion for Log Analytics and Sentinel Workspace
I’m trying to understand how data ingestion works for both Log Analytics and Microsoft Sentinel. Every time we notice a spike in data ingestion costs for Log Analytics, we see a similar increase in Sentinel costs as well. It seems like data is being ingested into both workspaces, potentially doubling the ingestion and driving up our costs.
Can someone explain if this is expected behavior, or if there’s a way to optimize and avoid duplicate data ingestion between Log Analytics and Sentinel?
I’m trying to understand how data ingestion works for both Log Analytics and Microsoft Sentinel. Every time we notice a spike in data ingestion costs for Log Analytics, we see a similar increase in Sentinel costs as well. It seems like data is being ingested into both workspaces, potentially doubling the ingestion and driving up our costs.Can someone explain if this is expected behavior, or if there’s a way to optimize and avoid duplicate data ingestion between Log Analytics and Sentinel? Read More
Can’t recover my account.
Hi, I lost access to my email and tried to recover my hotmail account earlier this year. Is there anyone who can help me to fix that? I’ve tried to recover my email where you need information to prove that i own it, but I never sent any emails from that account so I have nothing from that type of information to prove that I own it. Everytime i try to recover it, it just says i didn’t give enough proof that I own it. I have connected my email to other platforms like discord, EA etc, and now i have lost all access to those connected to that email. I don’t have any idea what to do and would appreciate if someone here could help me with this problem, thanks.
Hi, I lost access to my email and tried to recover my hotmail account earlier this year. Is there anyone who can help me to fix that? I’ve tried to recover my email where you need information to prove that i own it, but I never sent any emails from that account so I have nothing from that type of information to prove that I own it. Everytime i try to recover it, it just says i didn’t give enough proof that I own it. I have connected my email to other platforms like discord, EA etc, and now i have lost all access to those connected to that email. I don’t have any idea what to do and would appreciate if someone here could help me with this problem, thanks. Read More
Phishing resistant MFA options for Entra ID Guest users
What are the phishing resistant MFA options for Entra ID B2B guest users who authenticate from an IDP that is not configured for inbound cross tenant trust? From our testing, there does not appear to be any way to use fido2/passwordless/certificate-based authentication with the guest account on the resource tenant. The following links appear to indicate that this is not supported.
Microsoft Entra passwordless sign-in – Microsoft Entra ID | Microsoft Learn
When we enable MFA requirements in conditional access policy for Guest users, the only option that seems to work is MS Authenticator which the user can enroll for on our tenant. Would switching the account from a B2B guest to an internal Guest allow something like CBA to function or is the only real option to enable cross tenant trust and force the user to enable MFA on the account in their home IDP?
What are the phishing resistant MFA options for Entra ID B2B guest users who authenticate from an IDP that is not configured for inbound cross tenant trust? From our testing, there does not appear to be any way to use fido2/passwordless/certificate-based authentication with the guest account on the resource tenant. The following links appear to indicate that this is not supported. Overview of custom authentication strengths and advanced options for FIDO2 security keys and certificate-based authentication in Microsoft Entra ID – Microsoft Entra ID | Microsoft Learn Microsoft Entra passwordless sign-in – Microsoft Entra ID | Microsoft Learn When we enable MFA requirements in conditional access policy for Guest users, the only option that seems to work is MS Authenticator which the user can enroll for on our tenant. Would switching the account from a B2B guest to an internal Guest allow something like CBA to function or is the only real option to enable cross tenant trust and force the user to enable MFA on the account in their home IDP? Read More
Understanding Data Ingestion for Log Analytics and Sentinel Workspace
I’m trying to understand how data ingestion works for both Log Analytics and Microsoft Sentinel. Every time we notice a spike in data ingestion costs for Log Analytics, we see a similar increase in Sentinel costs as well. It seems like data is being ingested into both workspaces, potentially doubling the ingestion and driving up our costs.
Can someone explain if this is expected behavior, or if there’s a way to optimize and avoid duplicate data ingestion between Log Analytics and Sentinel?
I’m trying to understand how data ingestion works for both Log Analytics and Microsoft Sentinel. Every time we notice a spike in data ingestion costs for Log Analytics, we see a similar increase in Sentinel costs as well. It seems like data is being ingested into both workspaces, potentially doubling the ingestion and driving up our costs.Can someone explain if this is expected behavior, or if there’s a way to optimize and avoid duplicate data ingestion between Log Analytics and Sentinel? Read More
Copilot for Work – Search in OneNote
If I use Copilot for Work at ask something it would be nice if it would use the informations in OneNote to find the right answer. As far as I know Copilot do not look in my OneNote Notebooks when I ask something. (Just if I directly use Copilot in OneNote, but not when I use Copilot for Work via Browser or M365 App or Teams)
If I use Copilot for Work at ask something it would be nice if it would use the informations in OneNote to find the right answer. As far as I know Copilot do not look in my OneNote Notebooks when I ask something. (Just if I directly use Copilot in OneNote, but not when I use Copilot for Work via Browser or M365 App or Teams) Read More
Copilot in Outlook should be able to make new entries in the calender/ Make Appointments with other
It would be a good feature if Copilot could make new entries in the calender.
Or if I can ask copilot when Person A, B and C have time together and create the calender entrie.
Actually Copilot can not add entries to the calender and I can just ask for my calender when I have time. But when I for example can see when someone is blocked and when availible from my rights Copilot can not do it in calenders from other persons
It would be a good feature if Copilot could make new entries in the calender.Or if I can ask copilot when Person A, B and C have time together and create the calender entrie.Actually Copilot can not add entries to the calender and I can just ask for my calender when I have time. But when I for example can see when someone is blocked and when availible from my rights Copilot can not do it in calenders from other persons Read More
¡Saludo desde la meseta!
¡Me alegra que ya estés en la meseta!
¡Este es el inicio de un gran camino hacia la calidad analítica!
Cuéntame algo de ti que te guste hacer en el tiempo libre… a mi por ejemplo ¡¡¡me encanta el buceo, el yoga y correr!!!
¡Me alegra que ya estés en la meseta! ¡Este es el inicio de un gran camino hacia la calidad analítica! Cuéntame algo de ti que te guste hacer en el tiempo libre… a mi por ejemplo ¡¡¡me encanta el buceo, el yoga y correr!!! Read More
Scan a business card and save the contact in Outlook
Scan a business card and automatically create the contact in outlook for that would be a nice feature for copilot/ M365 App
Scan a business card and automatically create the contact in outlook for that would be a nice feature for copilot/ M365 App Read More
This Week in Microsoft AI 10-11-2024
Welcome to This Week in Microsoft AI. Each Friday I comb through the AI and Copilot publications here on the HLS Blog AND other Microsoft publication sources to bring you a consolidated catch-up post to keep you up to date with all things Microsoft AI and Copilot. So, without further delay…
HLS Blog Posts
Candidly Copilot – HLS Weekly Podcast (microsoft.com)
Creating an Agent in SharePoint that Spans Multiple Sources – Copilot Snacks (microsoft.com)
Other Microsoft Posts
Microsoft AI Summit 31.10. – Microsoft Community Hub
Your guide to Intune at Microsoft Ignite 2024 – Microsoft Intune Blog
Partner Blog | Build your team’s AI expertise with upcoming Microsoft partner skilling opportunities – Microsoft Community Hub
Attend Microsoft Ignite from anywhere in the world! – Microsoft Community Hub
Get tailored support with the new Partner Center AI assistant (preview) – Microsoft Community Hub
Automate RAG Indexing: Azure Logic Apps & AI Search for Source Document Processing (microsoft.com)
The Future of AI: Building Scalable, Customized GenAI Solutions with Microservices Architecture – Microsoft Community Hub
Microsoft 365 Copilot Wave Two updates - Pages, Excel, OneDrive, and agents
Build Safer Chatbots: Integrate Microsoft Content Safety with Azure OpenAI | Step-by-Step Guide
Join Microsoft AI experts for Make Azure AI Real Season 2
Use Coaching with Copilot suggestions on how to improve your content in Word – Microsoft Community Hub
Coming soon: MS-4002: Prepare security and compliance to support Microsoft 365 Copilot – Microsoft Community Hub
Coming late October: PL-7004: Implement AI models with Microsoft Power Platform AI Builder – Microsoft Community Hub
Explore skilling opportunities in your region—and unlock business growth – Microsoft Community Hub
Welcome to the New Era of Microsoft OneDrive: AI, Productivity, and Memories at Your Fingertips – Microsoft Community Hub
Azure AI Search October Updates: Nearly 100x Compression with Minimal Quality Loss (microsoft.com)
AI Content Safety Fast PoC – Microsoft Community Hub
New “Season of AI” Focused on Copilots – Microsoft Community Hub
How Copilot in Word helps you take more strategic action – Microsoft Community Hub
Quickly transform some data for analysis using Copilot in Excel (microsoft.com)
That’s it for this week!
Thanks for visiting – Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More
Hands on Workshops to Drive your Success: Join Ultimate Partner LIVE!
We are happy to share Ultimate Partner LIVE – Executive Summit ’24, a Microsoft sponsored event, is taking place in Dallas, Texas, on October 22-23rd.
In addition to keynote and panel discussions, Ultimate Partner LIVE will include Hands-On Workshops facilitated by industry leading experts. Gain real-world guidance, frameworks, and best practices focused on Marketplace Activation and Co-sell enablement.
Reis Barrie, CEO of Carve Partners, will be leading an impactful workshop, ideal for ISVs who are looking to build a successful Co-sell Microsoft partnership. In the Scaling Workshop for ISVs: Maximize your Co-sell Impact session Reis leverages his deep industry knowledge and over a decade of experience working with Microsoft, to help partners navigate complexities of the cloud ecosystem and formulate growth strategies.
Workshop Details:
Carve’s Scaling Workshop is designed to provide ISV Partners with a playbook to unlock the full potential of their Microsoft partnership. This workshop is led by the same team that has supported multiple Microsoft Partner of the Year Award winners and nominees over the past five years.
After attending, you will gain an understanding of the Microsoft FY25 co-sell landscape, the tools needed to formulate your growth strategy, and an action plan tailored to your status and objectives to effectively navigate the co-sell marketplace.
Ultimate Partner LIVE – Executive Summit ’24, offers exclusive insights, valuable networking opportunities, and actionable strategies for success to create new business opportunities.
Whether you’re an emerging leader in partnerships, marketing, or revenue, eager to make an impact, or a seasoned expert aiming to drive scalable growth with Microsoft, this event is designed for you!
Microsoft Tech Community – Latest Blogs –Read More
Cloudserve Systems and FidraSoft offer transactable partner solutions in Azure Marketplace
Microsoft partners like Cloudserve Systems and FidraSoft deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about these offers below:
CloudZap: CloudZap by Cloudserve provides comprehensive visibility into Microsoft Azure accounts and their security, performing vulnerability assessment and penetration testing (VAPT) for cloud platforms. Its reports are platform agnostic, user friendly, and accessible from any device.
TeamFolio Employee Skills Hub: TeamFolio from FidraSoft is a knowledge discovery and enterprise skills hub that empowers your organization by unearthing what you already know. Use it to identify people with the skills, certification, and knowledge needed for quicker customer responses and project success.
Microsoft Tech Community – Latest Blogs –Read More
Перестали запускаться 4 программы после перехода из канала бета в канал Windows Insider
Здравствуйте!!!
Помогите решить проблему с запуском программ?
Проблема такая стояла последняя бета версия виндовс 11 23H2 и эти программы работали без проблем. Я решил перейти на канал Windows Insider и с него установил последнюю версию виндовс 24H2 и после этого 4 программы от Хрумер перестали запускаться в чем причина не понятно вылетают ошибки программы не запускаются. Помогите решить вопрос с запуском программ! Скрины ошибок прикрепляю.
Здравствуйте!!!Помогите решить проблему с запуском программ?Проблема такая стояла последняя бета версия виндовс 11 23H2 и эти программы работали без проблем. Я решил перейти на канал Windows Insider и с него установил последнюю версию виндовс 24H2 и после этого 4 программы от Хрумер перестали запускаться в чем причина не понятно вылетают ошибки программы не запускаются. Помогите решить вопрос с запуском программ! Скрины ошибок прикрепляю. Read More
Issues loading Outlook
Hello all,
For quite some time now I have issues loading Outlook. The page keeps refreshing and doesn’t load completely. I have tried to figure it out and solve the problem. Unfortunately I am still unable to. Any guidance or tips are welcome.
Thank you in advance.
Hello all,For quite some time now I have issues loading Outlook. The page keeps refreshing and doesn’t load completely. I have tried to figure it out and solve the problem. Unfortunately I am still unable to. Any guidance or tips are welcome. Thank you in advance. Read More
Azure NetApp Files – Error creating the volume
I’m encountering an issue while trying to create a new volume on my NetApp system, which is integrated with Azure AD (Entra ID). I don’t have a traditional on-premises Active Directory or Domain Controller and am relying entirely on Azure AD.
When I attempt to create the volume, I receive the following error:
Error when creating – Failed to create the Active Directory machine account “NETAPP-B213”. Reason: LDAP Error: Local error occurred Details: Error: Machine account creation procedure failed
[ 76] Loaded the preliminary configuration.
[ 79] Successfully connected to ip 10.0.8.4, port 88 using TCP
[ 111] Successfully connected to ip 10.0.8.4, port 389 using TCP
[ 111] Entry for host-address: 10.0.8.4 not found in the current source: FILES. Ignoring and trying next available source
[ 122] Successfully connected to ip 10.0.8.4, port 88 using TCP
[ 129] FAILURE: Unable to SASL bind to LDAP server using GSSAPI: Local error
[ 132] Unable to connect to LDAP (Active Directory) service on evri3ba830eo2hg.migramer.com (Error: Local error)
[ 132] Unable to make a connection (LDAP (Active Directory):MIGRAMER.COM), Result: RESULT_ERROR_LDAPSERVER_LOCAL_ERROR.
(Code: ErrorFromNFSaaSErrorState)
Has anyone encountered this issue or have any insights on resolving this LDAP error with Azure AD and NetApp? Any assistance would be greatly appreciated!
Thanks, Mauricio
I’m encountering an issue while trying to create a new volume on my NetApp system, which is integrated with Azure AD (Entra ID). I don’t have a traditional on-premises Active Directory or Domain Controller and am relying entirely on Azure AD.When I attempt to create the volume, I receive the following error: Error when creating – Failed to create the Active Directory machine account “NETAPP-B213”. Reason: LDAP Error: Local error occurred Details: Error: Machine account creation procedure failed[ 76] Loaded the preliminary configuration.[ 79] Successfully connected to ip 10.0.8.4, port 88 using TCP[ 111] Successfully connected to ip 10.0.8.4, port 389 using TCP[ 111] Entry for host-address: 10.0.8.4 not found in the current source: FILES. Ignoring and trying next available source[ 122] Successfully connected to ip 10.0.8.4, port 88 using TCP[ 129] FAILURE: Unable to SASL bind to LDAP server using GSSAPI: Local error[ 132] Unable to connect to LDAP (Active Directory) service on evri3ba830eo2hg.migramer.com (Error: Local error)[ 132] Unable to make a connection (LDAP (Active Directory):MIGRAMER.COM), Result: RESULT_ERROR_LDAPSERVER_LOCAL_ERROR.(Code: ErrorFromNFSaaSErrorState) Has anyone encountered this issue or have any insights on resolving this LDAP error with Azure AD and NetApp? Any assistance would be greatly appreciated!Thanks, Mauricio Read More