Category: Microsoft
Category Archives: Microsoft
sql query realted to null and not null values in a temp table
Hi all,
1.This is my table from that I have to select that not null values of ID1 and ID3, also select NULL value of ID2 and ID4 not null value.
2. If ID1,ID3 having both NULL and NOT NULL values means show all NOT NULL values.
3. ID2 having NULL values means show that NULL value of ID2.
4.ID 4 has NOT NULL value means show that ID4 NOT NULL value .
if the records have similar columns then take not null values, no similar take whether null or not null
output should be like this :
can anyone please help me with this, Thanks in advance!!
Hi all,1.This is my table from that I have to select that not null values of ID1 and ID3, also select NULL value of ID2 and ID4 not null value.2. If ID1,ID3 having both NULL and NOT NULL values means show all NOT NULL values.3. ID2 having NULL values means show that NULL value of ID2.4.ID 4 has NOT NULL value means show that ID4 NOT NULL value .if the records have similar columns then take not null values, no similar take whether null or not null output should be like this : can anyone please help me with this, Thanks in advance!! Read More
MidDay Café Episode 55 – AI and the Employee Experience
As the capabilities, and transformational power of AI, continue to evolve at a quickening pace, organizations are grappling with choices around when and how to implement and its impact on organizations and their employee experience. Microsoft is committed to helping organizations begin today building that AI muscle so they can assess and be prepared to adapt new modes of work and workstreams ushered in by this rapidly evolving age of Enterprise AI.
In this MidDay Café hosts Tyrelle Barnes and Michael Gannotti have a sit-down discussion around AI, the need to build AI muscle at an individual and organizational level now, and its impact on the employee experience. Also discussed are Microsoft services that can help customers more fully assess their organizations use of AI and its impact in a data driven fashion.
Resources:
Microsoft Copilot for Microsoft 365—Features and Plans | Microsoft 365
Microsoft Copilot for Microsoft 365 documentation | Microsoft Learn
Copilot for Microsoft 365 Adoption Playbook | Microsoft Copilot
Deploying Copilot for Microsoft 365 in four chapters – Inside Track Blog
Copilot Success Kit – Microsoft Adoption
Employee Experience and Engagement | Microsoft Viva
Microsoft Viva | Microsoft Learn
Microsoft Viva – Microsoft Adoption
*The following are AI driven notes automatically provided by Microsoft Teams Meeting Recap
Meeting notes:
AI Transformation: Michael and Tyrelle discussed the ongoing AI transformation in the workplace, emphasizing its rapid pace and the need for organizations to adapt quickly to leverage AI effectively. They highlighted the importance of AI in driving innovation and efficiency.
AI’s Impact on Innovation: Michael and Tyrelle emphasized the transformative impact of AI on innovation, noting the rapid pace at which AI is evolving and its significance in driving workplace efficiency and productivity.
Organizational Adaptation: They discussed the necessity for organizations to quickly adapt to the AI transformation, highlighting the importance of being proactive in leveraging AI to remain competitive in the market.
AI in the Workplace: The conversation included insights on the integration of AI into various aspects of the workplace, stressing the need for organizations to embrace AI to enhance their operational capabilities.
AI in Mobile Devices: Michael highlighted the integration of AI into mobile devices, such as iOS and Android, and the implications for workplace productivity and personal convenience. This underscores the ubiquity of AI and the necessity for organizations to consider mobile platforms in their AI strategies.
AI Integration in Mobile: Michael discussed the widespread integration of AI into mobile platforms, including iOS and Android devices, and how this trend is influencing workplace productivity and personal convenience.
AI Ubiquity: The conversation underscored the ubiquity of AI and the importance for organizations to incorporate mobile AI strategies into their overall approach to technology adoption.
AI Compliance and Security: Michael stressed the importance of using AI tools that are compliant and secure for enterprise needs, pointing out the limitations of consumer AI tools in a professional setting. This highlights the need for organizations to choose AI solutions that align with their security and compliance requirements.
Enterprise AI Compliance: Michael emphasized the critical need for AI tools to be compliant with enterprise security and regulatory standards, differentiating between the capabilities of enterprise-grade AI and consumer AI tools.
Security Limitations: He pointed out the limitations and potential risks associated with using consumer AI tools in professional settings, advocating for the selection of AI solutions that meet organizational security and compliance needs.
AI Tool Selection: The discussion included the importance of carefully selecting AI tools that align with an organization’s security policies and compliance requirements to ensure data protection and regulatory adherence.
Employee Experience and AI: Tyrelle discussed the impact of AI on employee experience, particularly in reducing stress and repetitive tasks. This underscores the potential of AI to improve workplace satisfaction and productivity.
AI’s Role in Employee Experience: Tyrelle highlighted the positive impact of AI on employee experience, focusing on how AI can alleviate stress and reduce the burden of repetitive tasks, thereby improving overall workplace satisfaction and productivity.
Workplace Satisfaction: The conversation explored the potential of AI to enhance workplace satisfaction by assisting employees with tasks that can be automated, allowing them to focus on more meaningful work.
AI and Innovation Pace: Michael and Tyrelle reflected on the accelerated pace of innovation due to AI, predicting a significant leap in technological advancements in the coming years. They emphasized the importance of organizations being proactive in adopting AI to stay competitive.
Accelerated Technological Advancements: Michael and Tyrelle discussed the accelerated pace of innovation driven by AI, predicting that the coming years will see significant leaps in technological advancements, which organizations must proactively adopt to maintain a competitive edge.
Proactive AI Adoption: They emphasized the need for organizations to be proactive in adopting AI technologies, highlighting the competitive advantage gained by staying ahead in the rapidly evolving AI landscape.
Future of AI Innovation: The conversation included insights into the future trajectory of AI innovation, suggesting that the pace of development is likely to continue accelerating, further transforming industries and work practices.
Viva and Copilot Integration: Michael and Tyrelle discussed the integration of Viva and Copilot, highlighting how these tools together can enhance employee experience by providing insights and facilitating more efficient work processes. This demonstrates the synergy between different Microsoft tools in improving workplace productivity.
Viva and Copilot Synergy: Michael and Tyrelle explored the integration of Viva and Copilot, detailing how the synergy between these Microsoft tools can lead to enhanced employee experiences and more efficient work processes.
Insights and Efficiency: The discussion highlighted how the combination of Viva and Copilot provides valuable insights and facilitates efficiency, demonstrating the potential of integrated tools to improve workplace productivity.
Improving Productivity: They discussed the role of Viva and Copilot in improving workplace productivity, emphasizing the importance of leveraging integrated tools to streamline work processes and enhance employee engagement.
Thanks for visiting!
Tyrelle Barnes LinkedIn : Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More
AVD Connection Issue
1. I can connect AVD from the Browser but when I try to log in from a remote desktop, I get some error like the screenshot below.
Kindly help me as soon as possible.
Looking for your quick response.
thanks
Augustine Anand S
1. I can connect AVD from the Browser but when I try to log in from a remote desktop, I get some error like the screenshot below. Kindly help me as soon as possible. Looking for your quick response. thanksAugustine Anand S Read More
Excel, how to add/detect a coloured cell as only number “1” and ignore the cell value
Hey, ive got a attendance report with up to 10 weeks per person. Right now i have 2 sepertae formulas, 1 which uses cell value to determine colour (so 1=red (absent), 2=green (present) etc.) And another formula that uses the “total weeks present” (‘4/10) to determine a percentage (=40%). Is there any way i can get the “total weeks present” to increase by 1 (from’4/10 to ‘5/10) when i fill in the cell with present (2) and not increase the “total weeks present” by 2 (almost ignoring the cell value, but detecting the cell is full or something like that)?
Thanks in advance!
Hey, ive got a attendance report with up to 10 weeks per person. Right now i have 2 sepertae formulas, 1 which uses cell value to determine colour (so 1=red (absent), 2=green (present) etc.) And another formula that uses the “total weeks present” (‘4/10) to determine a percentage (=40%). Is there any way i can get the “total weeks present” to increase by 1 (from’4/10 to ‘5/10) when i fill in the cell with present (2) and not increase the “total weeks present” by 2 (almost ignoring the cell value, but detecting the cell is full or something like that)?Thanks in advance! Read More
recipients in public event
Dear all,
We are currently testing the function to create public online events in Teams in order to use the corresponding functions for invitations and reminders. I have the following questions:
Is it correct that a webinar that requires registration does NOT provide an invitation email? If so, how does it work?Is it correct that a public meeting does NOT provide a reminder email? If so, how does it work?Is it correct that the invitation to a public event contains ALL email addresses and that this is also visible to the other recipients?
Many thanks in advance
Ralf Ryter
Dear all, We are currently testing the function to create public online events in Teams in order to use the corresponding functions for invitations and reminders. I have the following questions:Is it correct that a webinar that requires registration does NOT provide an invitation email? If so, how does it work?Is it correct that a public meeting does NOT provide a reminder email? If so, how does it work?Is it correct that the invitation to a public event contains ALL email addresses and that this is also visible to the other recipients?Many thanks in advanceRalf Ryter Read More
Filter a table using value selected in a list and filtering another table using the filtered values
Hi All,
I have the following tables
Table 1
TenderIDProjectTitleOrganisation2024_1Title 1Organisation12024_2Title 2Organisation22024_3Title 3Organisation32024_4Title 4Organisation4
Table 2
TenderIDTataSailJSPL2024_1YesNoYes2024_2NoYesYes2024_3YesYesYes2024_4YesNoYes
I want to select one of Tata, Sail, JSPL from a List
1. Basis the value selected, I want all those TenderIDs where value in Tata column is “Yes”
2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is “Yes”
Hi All, I have the following tables Table 1TenderIDProjectTitleOrganisation2024_1Title 1Organisation12024_2Title 2Organisation22024_3Title 3Organisation32024_4Title 4Organisation4 Table 2TenderIDTataSailJSPL2024_1YesNoYes2024_2NoYesYes2024_3YesYesYes2024_4YesNoYes I want to select one of Tata, Sail, JSPL from a List1. Basis the value selected, I want all those TenderIDs where value in Tata column is “Yes”2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is “Yes” Read More
MATRIX’S BACKGROUND COLOR
HI, I NEED A HELP
I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K.
I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX…
HOW CAN I DO THIS FOR EACH COLUMN YEAR?
THANKS
HI, I NEED A HELPI HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K.I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX… HOW CAN I DO THIS FOR EACH COLUMN YEAR? THANKS Read More
Surface Dock Connectivity Issues
Hi all,
Hoping someone can potentially provide some insight into the below issue in relation to a surface dock:
“connectivity to the external displays no longer works. The connector will charge the laptop and usb outputs work for phone charging etc. The screens/external display also work as have checked it with another laptop however will not allow display use.”
Any suggestions would be greatly appreciated.
Hi all, Hoping someone can potentially provide some insight into the below issue in relation to a surface dock: “connectivity to the external displays no longer works. The connector will charge the laptop and usb outputs work for phone charging etc. The screens/external display also work as have checked it with another laptop however will not allow display use.” Any suggestions would be greatly appreciated. Read More
Show value from table based on selection
Hi all
On an Excel spreadsheet tab I have a table with the following data:
YearSession% Passed% FailedAverageHighest2020July-2055454.882021July-2128725.052022July-2258424.262023July-2382184.062024July-2478224.27
On a separate tab I have the below table. On the data point column I have added a validation drop-down list of the above data points, i.e. % Passed, % Failed, Average and Highest. How can I then display that value in the data value column, taking into consideration the Year and Session? For example the first row below should show 58.
YearSessionData pointData value2022July-22% Passed58
Many thanks!
Hi all On an Excel spreadsheet tab I have a table with the following data: YearSession% Passed% FailedAverageHighest2020July-2055454.882021July-2128725.052022July-2258424.262023July-2382184.062024July-2478224.27 On a separate tab I have the below table. On the data point column I have added a validation drop-down list of the above data points, i.e. % Passed, % Failed, Average and Highest. How can I then display that value in the data value column, taking into consideration the Year and Session? For example the first row below should show 58. YearSessionData pointData value2022July-22% Passed58 Many thanks! Read More
PNP Connect with certificate
Hello. I have 2 registered applications in Azure. I genereted certificates and uploaded and also i granted permissions. Situation is weird because app1 i can acces from only one computer app2 from second. I cannot acces to app1 from pc2 and to app2 from pc1 because of this error:
Values are correct. Please help.
Best regards,
Kamil
Hello. I have 2 registered applications in Azure. I genereted certificates and uploaded and also i granted permissions. Situation is weird because app1 i can acces from only one computer app2 from second. I cannot acces to app1 from pc2 and to app2 from pc1 because of this error:Values are correct. Please help.Best regards,Kamil Read More
How to deploy SAP IQ-NLS Solution using Azure Premium Files on Azure.
SAP IQ High-Availability can be achieved with IQ Multiplex architecture [ SAP Note 2477758], but not when deployed in NLS mode. As per the SAP First Guidance for SAP IQ 16.x, here, Multiplex Architecture is not available/evaluated for the SAP-NLS solution. This blog outlines one of the methods for deploying SAP IQ-NLS utilizing Azure Premium Files on the Azure platform.
Overview
Several customers leverage SAP IQ for storing historical data, extracting aged data from the SAP BW system to enhance SAP BW performance and achieve cost efficiency. It’s crucial to meticulously design and implement the SAP IQ architecture to ensure that data remains online and accessible as per the demands of business processes. We collaborated with our partners and customers to develop an SAP IQ-NLS solution architecture on Azure, incorporating Azure Premium Files. This solution addresses to the customer’s need for SAP IQ High Availability across zones, aiming to achieve a Recovery Point Objective (RPO) of zero across zones in a Zonal Disaster Recovery (Zonal DR) setup. In this architecture, the Primary SAP IQ operates as a standalone system, with its database installed on Azure Premium Files using Zone-Redundant Storage (ZRS). The virtual machine (VM) is then replicated to the secondary zone through Azure Site Recovery [ASR].
As SAP does not provide an official reference for SAP IQ-NLS High Availability (HA)/Disaster Recovery [DR] architecture to meet RPO=0, a bespoke solution developed to fulfil the customer’s requirements. The DR solution has been developed and rigorously tested within the Microsoft Azure Cloud environment. It’s strongly advised that customers conduct thorough DR and performance testing of the scenario to ensure that it meets their business and performance needs.
Architecture Overview
The proposed solution comprises deploying two Virtual Machines (VMs) across different zones as active/passive SAP IQ deployment within the Azure East US region. One VM will serve as the Primary VM, hosting the SAP IQ binaries, while the other VM, deployed across a separate zone, will function as the Secondary VM using Azure Site Recovery for zonal DR.
Key Components
Virtual Machines:
Two VMs deployed across different zones in Azure East US.
Primary VM hosts SAP IQ binaries.
Secondary VM configured for zonal DR using Azure Site Recovery.
Azure Premium Files:
Database files hosted on Azure Premium Files with Zonal Redundant Storage (ZRS) feature for data redundancy across zones.
Azure Site Recovery (ASR):
For orchestrating failover to the Secondary VM in case of a zonal outage.
Recovery plan for seamless failover and Disaster Recovery requirements.
Backup Strategy:
Additional Azure managed disk to the Primary VM for regular backups.
Rubrik backup tool backup management capabilities.
Implementation Steps
VM Deployment:
Provision two VMs in Azure East US region across different zones.
Configure networking and security settings for optimal performance and security.
Azure Premium Files Setup:
Create Azure Premium Files storage account with Zonal Redundant Storage (ZRS) enabled.
SAP IQ Installation:
Install SAP IQ Software (binaries) on the Primary VM.
Database files on Azure Premium Files with ZRS feature.
Configure SAP IQ database files to be hosted on Azure Premium Files.
Azure Site Recovery Configuration:
Set up Azure Site Recovery for zonal DR between Primary and Secondary VMs.
Create recovery plan to automate failover process in case of a zonal outage.
Backup Management:
Attach an additional managed disk to the Primary VM for regular backups.
Configure Rubrik backup tool for comprehensive backup management.
Summary
Implementing SAP IQ database on Azure Premium Files ensures zone redundancy of the database files, making them available across zones to achieve an RPO of zero. The Virtual Machine hosting the SAP IQ Software will be a standalone Virtual Machine in the Primary zone, replicated to the target zone using Azure Site Recovery. This solution guarantees high availability of database files across zones and the ability to failover the compute across zones for Disaster Recovery purposes. This approach perfectly aligns with the customer’s requirements and provides a robust infrastructure for running critical SAP IQ workloads on Azure.
The architecture and documentation provided align with general best practices based on the Azure services, and it’s strongly advised that customers conduct thorough testing tailored to their business needs to mitigate any potential technical or business risks associated with deploying SAP IQ.
Additional related references:
Understand Azure Files performance | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Teams Speaker Coach preview – when will it be fully rolled out?
We would like to roll out Speaker Coach to our organization but are hesitant since it is still in “Preview” (since 2022). Is anyone aware of timing on this functionality moving out of Preview?
Preview: Speaker Coach in Microsoft Teams meetings – Microsoft Support
We would like to roll out Speaker Coach to our organization but are hesitant since it is still in “Preview” (since 2022). Is anyone aware of timing on this functionality moving out of Preview? Preview: Speaker Coach in Microsoft Teams meetings – Microsoft Support Read More
Crashes on Google Maps
Version 128.0.2664.0 (Offizielles Build) canary (64-Bit) crashes repeatedly on starting Google Maps.
Version 128.0.2664.0 (Offizielles Build) canary (64-Bit) crashes repeatedly on starting Google Maps. Read More
“Message from yourself” used to spam users.
Hello all,
a User was asking, how he got a message from “himself” he wasn’t writing.
I’m sure he wasn’t sending a spam link to himself.
Is it possible to check “messages with yourself” as admin or reconstruct the situation?
any Ideas?
Hello all,a User was asking, how he got a message from “himself” he wasn’t writing.I’m sure he wasn’t sending a spam link to himself.Is it possible to check “messages with yourself” as admin or reconstruct the situation?any Ideas? Read More
Swiss DCs Partner Update Call June 2024
Please find attached the pdf slides from this quarter’s partner Swiss DCs update call. The recording and AI recap is here: Regular Partner Q&A Call on CH DC-20240621_140141-Meeting Recording.mp4 (sharepoint.com)
Main info covered:
Please find attached the pdf slides from this quarter’s partner Swiss DCs update call. The recording and AI recap is here: Regular Partner Q&A Call on CH DC-20240621_140141-Meeting Recording.mp4 (sharepoint.com)
Main info covered:
New Public Customer Story
Luzerner Kantonsspital with partner Polypoint
Azure
Azure OpenAI GPT-4 Turbo and GPT-4o available as Provisioned Throughput in Switzerland North – PAYG not yet available, will be listed here:https://learn.microsoft.com/en-us/azure/ai-services/openai/concepts/models
Azure VMware Solution now generally available in Switzerland North
More powerful NVIDIA GPUs NVv5 now generally available in Switzerland North, enabling e.g. resource-intensive applications such as CAD for Virtual Desktop
Azure Storage Actions (preview), a fully managed platform that helps customers automate data management operations for Azure Blob Storage and Azure Data Lake Storage
Please approach me if your customers have a need for further workloads in Swiss DCs
Defender
Announcement Post | LinkedIn
Covered solutions: Microsoft Defender for Endpoint MDE, Microsoft Defender for Identity MDI and Microsoft Defender XDR as underlying platform
Be aware of a few specific points per the pdf or call recording
Next Call
Current call series will be extended, next call will be on Friday Sept 20 2024 14.00
Please approach me if you’d like to join as well Read More
Logic App Email Not Sending
Hello.
I have a Logic App that is supposed to check for Sentinel incidents every 10 minutes and send an email when an incident has been created. This only seems to work about 80% of the time and there is nothing obvious to me why emails aren’t sent for all incidents captured by the query. Run history shows a status of “Succeeded” every time.
Here is the LA;
The Recurrence is 10 minutes.
Query;
SecurityIncident
| where TimeGenerated >= ago(10m)
| summarize arg_max(TimeGenerated, *) by IncidentNumber
| where Severity != “Informational”
| where Severity != “Low”
| where Status != “Closed”
| extend AlertNum = tostring(AlertIds[0])
| extend Generated = format_datetime(datetime_utc_to_local(TimeGenerated, ‘US/Eastern’), “MM/dd/yyyy hh:mm tt”)
| project Title, AlertNum, IncidentNumber, Generated, Severity, Status, IncidentUrl
| join (SecurityAlert
| project SystemAlertId, Description
)
on $left.AlertNum == $right.SystemAlertId
If I run the query outside of the Logic App it always returns the incident.
Within the LA run history the indication is there are no results;
As mentioned, this work about 80% of the time, so the configuration of the Send Email step is properly setup.
Any suggestions appreciated.
Hello.I have a Logic App that is supposed to check for Sentinel incidents every 10 minutes and send an email when an incident has been created. This only seems to work about 80% of the time and there is nothing obvious to me why emails aren’t sent for all incidents captured by the query. Run history shows a status of “Succeeded” every time. Here is the LA;The Recurrence is 10 minutes.Query;SecurityIncident| where TimeGenerated >= ago(10m) | summarize arg_max(TimeGenerated, *) by IncidentNumber| where Severity != “Informational”| where Severity != “Low”| where Status != “Closed”| extend AlertNum = tostring(AlertIds[0])| extend Generated = format_datetime(datetime_utc_to_local(TimeGenerated, ‘US/Eastern’), “MM/dd/yyyy hh:mm tt”) | project Title, AlertNum, IncidentNumber, Generated, Severity, Status, IncidentUrl| join (SecurityAlert| project SystemAlertId, Description)on $left.AlertNum == $right.SystemAlertId If I run the query outside of the Logic App it always returns the incident. Within the LA run history the indication is there are no results;As mentioned, this work about 80% of the time, so the configuration of the Send Email step is properly setup. Any suggestions appreciated. Read More
Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB
Today, I would like to share how to insert records from a CSV file stored in Azure Blob Storage into a temporary table in TempDB in Azure SQL Database using OPENROWSET and a format file.
First, we need to create a database scoped credential and an external data source to access the Azure Blob Storage.
CREATE DATABASE SCOPED CREDENTIAL MyCredential
WITH
IDENTITY = ‘SHARED ACCESS SIGNATURE’,
SECRET = ‘sv=2022-11-02&ss=bfqt&srt=sco&sp=rwdlacupiytfx&se=2024-06-30T16:56:42Z&st=2024-06-21T08:56:42Z&spr=https&sig=tAjokk5xO9kc%3D’;
CREATE EXTERNAL DATA SOURCE MyDataSource
WITH (
TYPE = BLOB_STORAGE,
LOCATION = ‘https://blobstorage.blob.core.windows.net/demo’,
CREDENTIAL = MyCredential
);
In this situation, I would like to create a format file that defines the structure of the CSV file and how it maps to the table columns. Below is an example format file in XML.
<?xml version=”1.0″?>
<BCPFORMAT xmlns=”http://schemas.microsoft.com/sqlserver/2004/bulkload/format” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<RECORD>
<FIELD ID=”1″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”2″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”3″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”4″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”5″ xsi:type=”CharTerm” TERMINATOR=”rn” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
</RECORD>
<ROW>
<COLUMN SOURCE=”1″ NAME=”Key” xsi:type=”SQLINT”/>
<COLUMN SOURCE=”2″ NAME=”NumData” xsi:type=”SQLINT”/>
<COLUMN SOURCE=”3″ NAME=”Col_01″ xsi:type=”SQLNVARCHAR”/>
<COLUMN SOURCE=”4″ NAME=”Col_02″ xsi:type=”SQLNVARCHAR”/>
<COLUMN SOURCE=”5″ NAME=”Col_03″ xsi:type=”SQLNVARCHAR”/>
</ROW>
</BCPFORMAT>
Save this format file and upload it to your Azure Blob Storage container.
Finally, we use OPENROWSET function to load data from the CSV file using the format file and insert it into a temporay table in TempDB.
SELECT *
INTO #test1
FROM OPENROWSET(
BULK ‘test1.csv’,
DATA_SOURCE = ‘MyDataSource’,
FORMATFILE =’format.xml’,
FORMATFILE_DATA_SOURCE = ‘MyDataSource’,
FIRSTROW = 2
) AS rows;
Microsoft Tech Community – Latest Blogs –Read More
New on Microsoft AppSource: June 7-13, 2024
We continue to expand the Microsoft AppSource ecosystem. For this volume, 193 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
Buddiz – AI for Schools & Higher Ed Colleges: Buddiz provides AI tools and solutions for schools, colleges, teachers, students, and parents, incorporating interactive chatbots into lesson planning and learning experiences. An advanced dashboard furnishes real-time analytics.
ChatGPTeMail: Najtech’s ChatGPTeMail add-in for Microsoft Outlook lets you compose and respond to emails through ChatGPT. Click the add-in icon to refine your draft’s language and tone. Compare versions before and after the transformation, then use them to elevate your professional correspondence.
Hardware Assets Inventory: Are you tired of using spreadsheets to track and manage your IT assets? IT Power’s app lets you view the status of your hardware assets from anywhere. Easily add new items, sort them into different categories, and monitor your stock. Access your inventory data from your mobile devices, your tablet, or your preferred browser.
HR Suite 360 – Human Capital Management (Start Package): HR Suite 360 from NEXXYSS offers a complete human resources solution, from recruitment to performance management. Keep employee records, track absences, store documents, and manage contracts. This offer is available in French.
Icon Map Pro: Icon Map Pro from Tekantis is a geospatial visualization tool designed for data analysts, GIS specialists, and business intelligence professionals. It offers background mapping, overlays, reference layers, and data layers. The tool provides seamless integration of geographic insights with an intuitive low-code or no-code Microsoft Power BI interface.
IndiGO Electronic Document: IndiGO Electronic Document from Indigo Technologies simplifies and automates the transfer of electronic documents for healthcare institutions. It ensures compliance with regulatory requirements and improves operational efficiency by centralizing information and reducing processing times and errors. This offer is available only in Spanish.
PleoMaintenance CMMS: PleoMaintenance from PleoData manages work orders, preventive maintenance scheduling, inventory parts, and asset costs via standard operating procedures built into workflows. Predict failures, eliminate downtime, and improve reliability with PleoMaintenance.
RENOVA2: RENOVA2 measures individual and group emotional well-being and relates this to organizational performance. Using advanced machine learning models trained on more than 90 groups, RENOVA2 identifies prevalent emotional well-being conditions in the Latin American population and issues personalized reports and recommendations. This offer is available only in Spanish.
SITA Mission Control SaaS: SITA’s Mission Control app enhances cross-functional cooperation in airline operations by connecting day-of-operations teams and driving increased collaboration through real-time air-ground information exchange. The app helps airlines better manage operational variability, turnarounds, fuel consumption, and carbon emissions.
Skypoint AI Platform for Social Services: Skypoint’s AI platform unifies all data sources into a data lakehouse and brings fragmented data into a social services-specific ontology. Streamline regulatory adherence, enhance staff scheduling, and customize care and wellness plans for residents based on data insights.
TriZetto Touchless Authorization Processing: TriZetto Touchless Authorization Processing (TTAP) is a cloud-based solution that automates healthcare prior authorization requests, streamlining the process and reducing turnaround time. It supports medical pre-planned inpatient and outpatient procedures, automates eligibility checks, and accommodates payer clinical guideline sets.
Vue.ai’s Intelligent Document Processing: Vue.ai automates document processing and workflows, allowing teams to improve accuracy and spare themselves repetitive manual tasks. Vue.ai is easy to use, handles all types of data, and has powerful AI features, such as pretrained and customizable models.
Waffle Chart Maker: The Waffle Chart Maker by VisioChart is a versatile and interactive tool for data visualization in Microsoft Power BI. It offers customizable features such as color, sorting, and display units, making it adaptable to different data representation needs. Cross-filtering enables comprehensive analysis, making it easier for stakeholders to understand and act upon insights.
Waterfall Chart: Waterfall Chart from VisioChart is a powerful visual tool for Microsoft Power BI to make your reports and dashboards informative and visually stunning. It automates variance calculations, year-over-year growth rates, and more, transforming your data into actionable insights. Customizable features ensure your chart is both aesthetically pleasing and functional.
Go further with workshops, proofs of concept, and implementations
Application Monitoring Solution with Microsoft Sentinel: AVASOFT’s consulting services aim to help you get started with or extend your use of Microsoft 365 by providing the expertise, capabilities, and know-how that you may lack in-house or need to enhance. In this engagement, AVASOFT will customize Microsoft Sentinel’s monitoring capabilities to offer detailed insights into your application’s performance and security.
CO2e Emissions Reporting Workshop: Lingaro offers sustainability expertise and data integration support to help companies accurately report carbon dioxide emissions. Using Microsoft tools like Power BI and Azure to manage, analyze, and visualize data, Lingaro’s experts will enable detailed reporting and analytics.
Continia Document Capture Installment, Workshop, and Support: Are you looking to implement Continia Document Capture? Navtilus can handle the installation process seamlessly, ensuring a smooth transition for your team. Navtilus will set up templates adjusted to fit your requirements, ensuring optimal performance and efficiency.
Copilot Change Management and Adoption: This workshop from ASI Solutions will give you hands-on experience with Microsoft 365 Copilot. Learn change management strategies to maximize the benefits of this transformative tool and provide the skills and support needed for successful adoption.
Copilot for Microsoft 365 Workshop: Inovasys will help your organization assess needs and build a plan for implementing Microsoft 365 Copilot so you can enhance productivity and gain access to resources, best practices, and community support to ensure successful implementation.
Copilot for Microsoft 365: 12-Week Impact Analysis Implementation: WM Reply offers a 12-week program to help organizations adopt Microsoft Copilot. The program includes a Copilot dashboard setup, employee surveys, focus groups, A/B testing, and ROI calculation. WM Reply provides expert mentorship to ensure effective and safe use of AI.
Copilot Microsoft 365: Workshop Sessions: This workshop from ASEE Solutions will teach participants how to integrate AI-powered tools into their daily duties, automating routine tasks and enhancing creativity. Topics will include drafting reports, summarizing data, and creating presentations.
Copilot Pro Adoption & Advisory Service: Logotel will implement DOJO, a tool based on Microsoft 365 that’s dedicated to the adoption of Microsoft Copilot. Employees can practice with a Microsoft AI assistant, facilitating fluid and effective adoption over time. Scale the impact of AI and unleash the potential of each person and team in your organization.
Dell Implementation Services for Copilot Security: Dell Technologies can maximize the full potential of your Microsoft Copilot for Security investment. Dell’s certified professionals will create customized prompts and ingest data from a range of security tools so your teams can gather intelligence, hunt threats, and effectively respond to any incident.
Device Domain Migration from On-Premises to Cloud: With the expertise of AVASOFT, your organization can efficiently migrate device domains from on-premises locations to the cloud, ensuring a secure and compliant environment while optimizing operational costs.
Device Monitoring with Microsoft Defender for Endpoint: Stay ahead of potential security breaches with the real-time monitoring and response capabilities of Microsoft Defender for Endpoint. In this offer, AVASOFT will help you manage and analyze device logs, gain activity insights, ensure compliance, centralize monitoring, and quickly identify and investigate security incidents.
Device Security Management with Microsoft Intune: Use Microsoft Intune to secure numerous devices and centralize control for easier management. In this offer, AVASOFT will help your organization implement Microsoft Intune to safeguard against cyber threats and ensure robust endpoint protection.
Dynamics 365 Business Central: 8-Week Implementation: AlphaBOLD will provide a hassle-free implementation of Microsoft Dynamics 365 Business Central. This will be preceded by a system gap analysis to identify needs, challenges, and automation opportunities. Post-go-live support will ensure system success through issue resolution, update management, ongoing training, and knowledge transfer.
Dynapt Advisory Services for Microsoft 365 Copilot: Dynapt offers AI advisory services for Microsoft 365 Copilot to enhance productivity, creativity, and innovation within organizations. The services include licensing planning, security configuration, usage setup, business case identification, pilot rollout, employee training, governance planning, and ongoing support.
Fabric in a Day: Workshop: Derevo’s workshop will accelerate your team’s adoption of Microsoft Fabric, an analytics platform that unifies data sources and tools like Azure Data Factory, Azure Synapse Analytics, and Power BI. Microsoft Fabric helps business professionals harness the potential of their data and lay the foundation for the AI era.
Increasing Efficiency with Copilot: Vision Software S.A.S will enable you to make the most of Microsoft 365 Copilot. Vision will explore different possibilities and business scenarios where Copilot can boost productivity, optimize performance, and foster dynamic collaboration. This offer is available only in Spanish.
Infosys Extending of Copilot Capabilities: Infosys can fast-track your AI journey. In this offer, Infosys will build custom copilots using Microsoft 365 Copilot and its prompts library. These copilots will automate tasks and address various persona needs in your organization.
Infra and Network Monitoring with Microsoft Sentinel: AVASOFT offers consulting services to help organizations efficiently monitor infrastructure and networks using Microsoft Sentinel. Proactive monitoring ensures resilience against threats. Focus on your business goals while AVASOFT manages your infrastructure and network security.
Integrating Microsoft Sentinel with Carbon Black EDR: Combine the power of Microsoft Sentinel analytics with Carbon Black EDR’s endpoint protection for comprehensive threat visibility. With AVASOFT’s assistance, your organization can efficiently integrate Microsoft Sentinel with Carbon Black EDR, ensuring a secure and compliant environment while optimizing operational efficiency.
Integrating Microsoft Sentinel with External EDR Service: In this offer, AVASOFT will seamlessly integrate Microsoft Sentinel with an external endpoint detection and response service to establish robust security, ensure compliance, centralize alert management, and enable proactive threat detection.
Microsoft Defender XDR Accelerator: This service from The Partner Masters will simplify your company’s security operations center workflow, reduce manual work, and provide a comprehensive view of threats. Experts from The Partner Masters will plan, design, deploy, and configure a pilot of Microsoft Defender XDR with the option for full production deployment.
Microsoft Multi-Cloud Security Engagement: 2-Week POC: Long View will use Microsoft Defender for Cloud to enhance your organization’s cloud security. Long View will establish foundational cloud security posture management, then activate cloud workload protection features to detect API threats and vulnerabilities across up to five resources.
Microsoft Volume Licensing: IT Partner’s experts will help you choose the right licensing program for your organization, as well as track renewals and monitor pricing adjustments. This will ensure you get maximum value from your Microsoft 365 investment while staying compliant and ready for audits. The service requires at least one legal business entity and the intent to purchase five products.
Power BI Migration Accelerator: 3-Week Proof of Concept: This service from iLink Systems helps businesses transition from IBM Cognos Analytics or Qlik Sense to Microsoft Power BI. It offers support for the latest Power BI features, as well as advanced data modeling and streamlined model editing and management. Minimal business interruption is ensured, and ongoing support will be provided.
Security Operations Center with Microsoft Sentinel: AVASOFT offers consulting services to help businesses efficiently manage security operations using Microsoft Sentinel. In this engagement, AVASOFT will empower your business with a security operations center powered by Microsoft Sentinel. This will streamline monitoring and analysis so your team can easily track security events and anomalies.
Self Service with Power BI: From Requirement to First Insightful Report in 4 Hours: This workshop from ITGAIN Consulting teaches skills for developing insightful reports using Microsoft Power BI, with a focus on a manufacturing company facing a drop in profit. Participants will enhance their analytical skills and visualize solutions in Power BI. The workshop can be held on-site or remotely in English or German.
SMB Readiness Workshop for Microsoft 365 Copilot: Intended for small and medium-sized businesses with 50 to 300 user, this workshop from Clear Concepts assesses readiness for Microsoft 365 Copilot. Clear Concepts will discuss the tool’s benefits, technical requirements, and licensing, then determine cloud environment readiness and deployment timelines.
Sustainability Reporting: CSRD: Lingaro offers comprehensive sustainability reporting services to help businesses comply with the European Union’s Corporate Sustainability Reporting Directive (CSRD). Lingaro will guide clients through the reporting process using Microsoft tools like Power BI and Azure.
Sustainability Reporting: US SEC: Lingaro offers expert services to guide clients through the United States Securities and Exchange Commission reporting process, with a focus on sustainability and climate-related disclosures. Lingaro will help you properly disclose greenhouse gas emissions and climate impacts, using Microsoft tools to provide accurate reporting.
Teams for GCC High: 3-Week Implementation: RSM’s Teams for GCC High is a secure communication and collaboration platform designed to meet the compliance needs of government entities. It utilizes Microsoft’s Cloud for Sovereignty, ensuring compliance with U.S. government regulations and requirements.
Unifying Microsoft Sentinel with Cloud Services: AVASOFT offers consulting services to help organizations unify Microsoft Sentinel with cloud services for comprehensive security coverage, centralized monitoring, and strengthened data protection. Deliverables include enhanced security and risk management, resource optimization, and centralized visibility and control.
Workshops: Solve the Right Problem the Right Way: This workshop series from Sirocco helps customers overcome obstacles and agree on goals for an initial project scope. The first workshop identifies the biggest barrier to their goal; the second discovers the root cause of the barrier; the third frames the problem for solutions; the fourth generates ideas to find innovative answers.
Contact our partners
1000minds Health-Related Quality of Life Value Set
9A Advanced Manufacturing – CAD/PLM Link
Access Charity CRM Add-in for Microsoft Outlook
Access Charity CRM Add-in for Microsoft Word
Accigo Readiness Assessment for Copilot for Microsoft 365
Accurate and Updated U.S. Denied Parties List (DPL)
ADAM AI Augmented Data Management Engine
AI Assistants for Healthcare Facilities
AI Consulting Services: 1-Day Workshop
AI LaunchPad: Custom AI Solutions for Office 365
AnaApp Sourcing & Vendor Management
APIVerve: Unified API Access for Streamlined Development
Aptean Production Costing for Food and Beverage
Assessment for Migration from Dynamics AX to Dynamics 365
AVL Data Analytics for Battery
B2C eCommerce for Dynamics 365 Business Central
Barcode API for Shipping Labels
BE-terna Incoming Document Register
Bionic Reading for Microsoft Word
BURQ iPaaS: eBay Integration with Dynamics 365 Business Central
CAP Logistics: Warehouse Operations
CAPEX & OPEX Authorization for Expenditure
Cloudmore Commerce Platform for Direct CSP Providers
Contract Management Extension for Dynamics 365
Coupler.io Revenue Dashboard for QuickBooks
DataPoint Add-in for PowerPoint
Devart Connector: Connect HubSpot to Excel
Devart Connector: Connect Magento to Excel
Devart Connector: Connect Mailchimp to Excel
Devart Connector: Connect Marketo to Excel
Devart Connector: Connect MySQL to Excel
Devart Connector: Connect NetSuite to Excel
Devart Connector: Connect Oracle to Excel
Devart Connector: Connect PostgreSQL to Excel
Devart Connector: Connect QuickBooks Online to Excel
Devart Connector: Connect Salesforce Marketing Cloud to Excel
Devart Connector: Connect Shopify to Excel
Devart Connector: Connect SQLite to Excel
Devart Connector: Connect SQL Server to Excel
Dynamics GP to Dynamics 365 Business Central Migration: 4-Week Assessment
EnterpriseGPT with Smart Search
Eyna: Advanced Package Management
Financials Template for SharePoint and Excel
Folderit DMS Add-in for Outlook
Frontline Worker Assessment for Healthcare
Gen AI-Powered Insurance Underwriter
Gen AI-Based Smart Credit Underwriter
Generative AI Community Support: 6-Month Service
GetAccept for Microsoft Dynamics 365
HCP Home Care Packages Aged Care Management for Microsoft Dynamics 365
High-Quality U.S. Publicly Listed Company Hierarchy
ILINX Process Improvement Platform
InsightStore Consumer Analytics Platform
KUBE 365 Business Process Automation Platform
Kyriba Open Reports Studio – Emerald
Kyriba Open Reports Studio – Quartz
Local Government Accelerator: 1-Hour Assessment
Microsoft 365 Copilot: 4-Week AI Assessment
Microsoft 365 Optimization Assessment
Microsoft 365 Threat Assessment
Mobile Time Tracking for Microsoft Dynamics 365
Nanhua Futures Assistant for Microsoft Excel
OnePortal: Digital Grid Connection Requests
OneTrust Data Activation and Compliance Risk Platform
Oraya Insights: Market Monitoring Your Way
Patient Experience: 2-Hour Briefing
Power Apps Process Coordination: Workshop & Assessment
Proactive Security Monitoring Service
ProcessNx Business Process Digital Transformation Platform
Real-Time Production Monitoring & Analytics
RingCentral RingCX for Dynamics 365
SAGE: Consumer Insights AI Assistant
Security and Compliance Assessment with Microsoft Purview
Service Portal for Dynamics 365 Business Central
SSH’s Electronic Invoice Solution for Mexico
Stock Trading Platform Monitor
The Last Business Card – NFC Digital Business Cards
Thomson Reuters Legal Task Manager
TRASER DMS 365 x Continia Document Capture
With Copilot Plugin Extension for ITSM
XTEL AI Enterprise Analytics Suite
Yooz Connector for Finance and Supply Chain Management
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
Unlock the power of Microsoft Education in your Learning Management System
Microsoft Education is committed to supporting educators and learners with engaging and inclusive learning experiences, wherever teaching and learning happens. Whether you teach and learn in a physical classroom, online, or in a hybrid mode, Microsoft Education has the tools and resources to help you achieve your goals. One of the ways we do this is by integrating our products and services with popular Learning Management Systems (LMS). Building on our previous work to bring Microsoft 365 documents, Microsoft Teams collaboration, OneNote Class Notebooks, and Microsoft Reflect into LMS platforms, our new integration of Teams Assignments represents a leap forward in bringing more of the unique value of Microsoft Education directly to LMS users.
Achieve More with Assignments in your LMS
The new Teams Assignments integration brings unique new capabilities into your LMS, saving educators time, and providing powerful tools to accelerate learning. For example, with Teams assignments you can:
Leverage AI during assignment creation to rapidly draft assignment descriptions and rubrics
Accelerate student learning with powerful tools like Reading Progress, Search Progress, and Speaker Progress
Deliver quizzes with Microsoft Forms
Access unique assignment types such as Microsoft Whiteboard, MakeCode, and Flip video
Use Reflect exit check-ins to understand student sentiment related to assignments
Teams Assignments are seamlessly integrated with LMS assignments via the Learning Tools Interoperability® (LTI®) v1.3 Advantage standard. As an educator, you can create new Teams assignments or link existing Teams assignments in your LMS course. Once linked, you can view and access those assignments as you would any other assignment in the LMS course. Your students can view and access their Teams assignments in the same way as their other LMS assignments. Assignment grades in Teams are automatically imported into the LMS gradebook. You can now use the best that Teams assignments and your LMS offer working together, instead of working alongside each other.
This new integration is currently in private preview for PowerSchool Schoology Learning and Canvas. Support for additional LMS platforms will be added soon. You can sign up here for information on current and future previews.
Choose the Right Tool for the Right Assignment
Many educators are already using the OneDrive LTI® tool to bring M365 documents into LMS assignments. The new Teams Assignments LTI® tool is a complementary solution that brings unique capabilities of Teams for Education to LMS users. When creating an assignment in your LMS, you should choose the tool that best meets the needs of the specific assignment. Whatever the choice of tool, the assignment can be viewed and accessed like any other assignment in the LMS, and grades will be added into the LMS gradebook.
Teams Assignments LTI® tool
OneDrive LTI® tool
What is it best used for?
Learning Accelerators, Forms Quizzes, Whiteboard, MakeCode, Flip video, AI-assisted assignment creation, and any other features exclusive to Teams Assignments
Embedding or linking M365 documents in course content; Collaborative editing of documents; Assignments to be completed in Word, PowerPoint, or Excel
When opened in the LMS, where are assignments completed and turned in?
Microsoft Teams
Word, PowerPoint, or Excel
Where are assignments graded?
In Microsoft Teams, with grades automatically copied back to the LMS gradebook.
In the LMS, using the native LMS capabilities.
Requires Microsoft Teams for Education?
Yes
No
Leverage Microsoft Education for more than Assignments in your LMS
The new Teams assignments integration is the latest advancement in our continued efforts to bring the full value of Microsoft Education to users of learning management systems. You can already use the capabilities of Microsoft Teams, OneDrive, OneNote Class Notebooks, Microsoft Reflect directly within LMS courses. You can learn more about these integrations with leaning management systems such as Blackboard Learn, Brightspace, Canvas, Schoology Learning and Moodle in our previous overview, and our support page.
Learning Tools Interoperability® (LTI®) is a trademark of the 1EdTech Consortium, Inc. (www.1edtech.org)
Microsoft Tech Community – Latest Blogs –Read More
ZAP (Zero-Hour Auto Purge) on internal traffic
Greetings !!
Well I have ZAP enabled (Anti-spam inbound policy & Anti-malware policy) and it is working fine with some exceptions. Internal traffic that should be ZAP(ed) reports: “ZAP took no action due to a tenant policy (ZAP disabled)”.
I suppose there is something else that is preventing ZAP on internal traffic. Do any IP addresses whitelisted in the Connection filter policy (Default) bypass the Anti-spam inbound policy ?
Any thoughts ?
Thank you.
Greetings !!Well I have ZAP enabled (Anti-spam inbound policy & Anti-malware policy) and it is working fine with some exceptions. Internal traffic that should be ZAP(ed) reports: “ZAP took no action due to a tenant policy (ZAP disabled)”. I suppose there is something else that is preventing ZAP on internal traffic. Do any IP addresses whitelisted in the Connection filter policy (Default) bypass the Anti-spam inbound policy ? Any thoughts ? Thank you. Read More