Dear All,
We have a Dataverse created via an Azure Synapse Link. The data is synching with D365 Finance & Operations every 15 mins and is using the Parquet file format. We have created a separate DB (that basically is just a bunch of Views over the Tables in the Dataverse – call it VIEW_DB) which we expose to other users rather than going directly to the Dataverse DB.

Once we have this data in the Dataverse, we then need to copy some data to a different target for reporting and use traditional SSIS to do this. As such, also every 15 mins we run this process to extract data from the VIEW_DB that is being synch’d. This mostly works OK (99% success). However, every so often and at irregular times, we receive the following error message …

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
Source: “Microsoft SQL Server Native Client 11.0” Hresult: 0x80040E14
Description: “Statement(s) could not be prepared.”.
Description: “Could not use view or function ‘db_datareader.TM1_vwJournal’ because of binding errors.”.
Description: “Invalid object name ‘dataverse_xxxx_unqxxxxxxxxx.dbo.LedgerJournalTable’.”.
Description: “OLE DB Source” failed validation and returned validation status “VS_ISBROKEN”.
Description: One or more component failed validation.

Has anyone experienced anything like this?
Why would this run OK for most of the time but fail once or twice every couple of days or so?
Would it have anything to do with the Sync process disrupting our OLEDB connection?

Any help much appreciated.

Basil

​Dear All,We have a Dataverse created via an Azure Synapse Link. The data is synching with D365 Finance & Operations every 15 mins and is using the Parquet file format. We have created a separate DB (that basically is just a bunch of Views over the Tables in the Dataverse – call it VIEW_DB) which we expose to other users rather than going directly to the Dataverse DB.Once we have this data in the Dataverse, we then need to copy some data to a different target for reporting and use traditional SSIS to do this. As such, also every 15 mins we run this process to extract data from the VIEW_DB that is being synch’d. This mostly works OK (99% success). However, every so often and at irregular times, we receive the following error message …Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
Source: “Microsoft SQL Server Native Client 11.0” Hresult: 0x80040E14
Description: “Statement(s) could not be prepared.”.
Description: “Could not use view or function ‘db_datareader.TM1_vwJournal’ because of binding errors.”.
Description: “Invalid object name ‘dataverse_xxxx_unqxxxxxxxxx.dbo.LedgerJournalTable’.”.
Description: “OLE DB Source” failed validation and returned validation status “VS_ISBROKEN”.
Description: One or more component failed validation.Has anyone experienced anything like this?Why would this run OK for most of the time but fail once or twice every couple of days or so?Would it have anything to do with the Sync process disrupting our OLEDB connection?Any help much appreciated.Basil  Read More

​

Hello everyone,

Currently I am using Ubuntu 20.04 LTS device enrolled in Intune for device management. First created a custom script with execution context with ‘User’ and execution frequency is 15 minutes. But the script executed only when sign-in with the Intune app. Also, the script doesn’t execute once in 15 minutes and execute only if I manually refresh it in Intune app. Then, I tried execution context with ‘root’ and the script doesn’t even executed and returns error with error code 0 in Intune admin center. 

When manually executed the script on device, it runs with no problem. Script was uploaded as file in the portal, execution retries set to 1, and device group is assigned correctly, and can anyone h what is the problem? 

​Hello everyone,Currently I am using Ubuntu 20.04 LTS device enrolled in Intune for device management. First created a custom script with execution context with ‘User’ and execution frequency is 15 minutes. But the script executed only when sign-in with the Intune app. Also, the script doesn’t execute once in 15 minutes and execute only if I manually refresh it in Intune app. Then, I tried execution context with ‘root’ and the script doesn’t even executed and returns error with error code 0 in Intune admin center. When manually executed the script on device, it runs with no problem. Script was uploaded as file in the portal, execution retries set to 1, and device group is assigned correctly, and can anyone h what is the problem?   Read More

​

Since Sunday I haven’t been able to get my booking page to load to where I can access it. To the public it looks fine and is still accepting bookings. Here is a screenshot below of what the front facing side of the booking page looks like

To the public everything looks and works fine

 The screenshot below shows how after signing into booking, the booking page I created doesn’t have my administrator label

My administrator label is grayed out for the page I created

While I can still access the page, nothing loads correctly. Calendar, Services, Staff, Business information, Customers all are grayed out. 

My calendar is grayed out, even though I have active bookings

It says I have no services, but I have 2 out of 5 active

 I tested cloning the page from the booking homepage and can see that my services and staff still exist, only I cannot access them in the actual booking page

If I wanted to clone the same booking page I cannot access, all of my services and staff show up

Here is an expanded look of the 5 services under clone

Any support on how I can see/access the administrative side of my booking page?

​Since Sunday I haven’t been able to get my booking page to load to where I can access it. To the public it looks fine and is still accepting bookings. Here is a screenshot below of what the front facing side of the booking page looks likeTo the public everything looks and works fine   The screenshot below shows how after signing into booking, the booking page I created doesn’t have my administrator label My administrator label is grayed out for the page I created While I can still access the page, nothing loads correctly. Calendar, Services, Staff, Business information, Customers all are grayed out. My calendar is grayed out, even though I have active bookings It says I have no services, but I have 2 out of 5 active I tested cloning the page from the booking homepage and can see that my services and staff still exist, only I cannot access them in the actual booking pageIf I wanted to clone the same booking page I cannot access, all of my services and staff show up Here is an expanded look of the 5 services under clone Any support on how I can see/access the administrative side of my booking page?  Read More

​

It’s very important to understand how to play in order to have the best experience. First, you can pick one of the four main levels: Horror, Ancient, Water, or Blast. Additionally, you may take part in Pins Hooky Horrorland (made levels). Please keep in mind that the levels will get harder in the order they show up in the choices. You control Peppino in the main game to get through each floor’s tricky terrain. Help the character find the door to the next dungeon, kill monsters, and gather items for cooking.

A pizza tower player will get a badge when they finish a level. This title depends on how well you did in the level or how much damage you took during the boss fight. The six levels in this platform game are P, S, A, B, C, and D, from best to worst. To get each rank, you’ll have to meet different goals. Knowing your limits comes from you. Yes, use all of your character’s strengths and do your best to see how you did.

​It’s very important to understand how to play in order to have the best experience. First, you can pick one of the four main levels: Horror, Ancient, Water, or Blast. Additionally, you may take part in Pins Hooky Horrorland (made levels). Please keep in mind that the levels will get harder in the order they show up in the choices. You control Peppino in the main game to get through each floor’s tricky terrain. Help the character find the door to the next dungeon, kill monsters, and gather items for cooking.A pizza tower player will get a badge when they finish a level. This title depends on how well you did in the level or how much damage you took during the boss fight. The six levels in this platform game are P, S, A, B, C, and D, from best to worst. To get each rank, you’ll have to meet different goals. Knowing your limits comes from you. Yes, use all of your character’s strengths and do your best to see how you did.  Read More

​

It is common in professional documents to continue a section with text such as:

1.1 My Heading (continued)

I see no way to do this in Word automatically.  If there is a way please advise.

​It is common in professional documents to continue a section with text such as: 1.1 My Heading (continued) I see no way to do this in Word automatically.  If there is a way please advise.  Read More

​

One of our Staff Member’s bookings looks different to everyone else, this has only just changed, it used to look the same as everybody else’s. (maybe the IT team changed a setting in the background).

Does anyone know what setting would do this and where that setting is so that we can change hers back?

She suddenly needs to put a prefix to the phone number, and has a checkbox for SMS’s (we are in Australia so we don’t have SMS as an option).

The Single Staff Member’s Bookings looks like this

Everybody else’s looks like this

​One of our Staff Member’s bookings looks different to everyone else, this has only just changed, it used to look the same as everybody else’s. (maybe the IT team changed a setting in the background). Does anyone know what setting would do this and where that setting is so that we can change hers back? She suddenly needs to put a prefix to the phone number, and has a checkbox for SMS’s (we are in Australia so we don’t have SMS as an option). The Single Staff Member’s Bookings looks like this    Everybody else’s looks like this  Read More

​

Co-authored by Djordje Jeremic & Mladen Andzic 

Azure SQL Database and Azure SQL Managed Instance are industry leading Platform as a Service (PaaS) database offerings suitable for building applications of any scale.  Both these offerings come with core resiliency and reliability promise designed to protect against software or hardware failures.

Occasionally, there may be an outage that disrupts the service’s availability, and it’s essential to be ready to manage such a scenario. To ensure higher business continuity, consider taking these proactive measures:

Enable High Availability
Enable zone redundancy to ensure Azure SQL Database or Azure SQL Managed Instance uses availability zones and is resilient to zonal failures.
Enable Disaster Recovery
To achieve redundancy across regions, enable Failover Groups for Azure SQL Database or Azure SQL Managed Instance to quickly recover from a catastrophic and rare regional failure. 

Disaster Recovery

Failover groups offer a strong solution for disaster recovery, helping you effectively meet stringent Recovery Time Objective (RTO) and Recovery Point Objective (RPO) goals. Failover Groups offer two failover policies, and we have recently renamed them to make their purposes clear and intuitive:

Customer Managed Failover Policy
(formerly called ‘Manual’)
Microsoft Managed Failover Policy
(formerly called ‘Automatic’)

We strongly advise customers to set the failover policy to Customer Managed, as it allows you to control when to initiate forced failovers based on specific criteria of your organization and maintain business continuity.

With the Microsoft Managed failover policy, as the name implies, you entrust Microsoft with the responsibility of initiating forced failovers. However, forced failovers are only triggered by Microsoft in extreme situations during a region-wide outage, with failover command issued for all failover groups in the affected region. During an outage, assessing its impact and scale takes time, and we focus on mitigating the outage first. As a result, the decision whether to activate the Microsoft Managed failover policy or the timing of forced failovers can vary significantly, and often, the policy may not be activated. Please see additional considerations for this failover policy.

Call to action

It is imperative to set the failover policy of your failover groups to Customer Managed. This ensures you have full control over when to initiate forced failovers for Disaster Recovery, based on your assessment of outage impact compared to potential data loss due to forced failover. Follow the steps for Azure SQL Database & Azure SQL Managed Instance to update the failover policy.

When failover groups are enabled use the read-write listener endpoint in your application connection string, so applications automatically connect to whichever server and database is the current primary.

Resources for Azure SQL DB

Overview of business continuity
High availability and disaster recovery checklist
Disaster recovery guidance

Resources for Azure SQL Managed Instance

Overview of business continuity
High availability
Failover groups
Disaster recovery guidance

​Microsoft Tech Community – Latest Blogs –Read More 

By Olivia Daniels

Attention security professionals! Microsoft Ignite 2024 is just around the corner, taking place from Monday, November 18, 2024, through Friday, November 22, 2024, in Chicago, Illinois. This is your chance to dive deep into the latest advancements in AI and security to help you build a security-first culture within your organization. 

General in-person passes are sold out, but don’t worry—you can still purchase a pass using Microsoft Security’s RSVP code

Read the full post here: Microsoft Ignite Sold Out? Not for Security Professionals! Secure Your Spot

​By Olivia Daniels
 
Attention security professionals! Microsoft Ignite 2024 is just around the corner, taking place from Monday, November 18, 2024, through Friday, November 22, 2024, in Chicago, Illinois. This is your chance to dive deep into the latest advancements in AI and security to help you build a security-first culture within your organization. 
 
General in-person passes are sold out, but don’t worry—you can still purchase a pass using Microsoft Security’s RSVP code
 

 
Read the full post here: Microsoft Ignite Sold Out? Not for Security Professionals! Secure Your Spot  Read More

​

By Ashish Jain 

​By Ashish Jain 

The traditional network security models are becoming increasingly ineffective in a world where remote work and cloud services are the norm. Conventional technologies like VPNs, while popular, offer limited protection in a boundary-less landscape, typically granting users excessive network access and posing significant risks. If compromised, these can lead to unauthorized access and potentially lateral movement within corporate networks, exposing sensitive data and resources. Microsoft Entra Private Access is at the forefront of addressing these challenges by effectively integrating identity and network access controls.
 

 
Read the full post here: Explore the key benefits of Microsoft Entra Private Access

   Read More

​

I am a developer wanting to build an application to obtain the phone number from an (unanswered) inbound call on Teams in order to query a customer database for prior orders, etc., and open a window showing that data to the user receiving the incoming call.

After a lot of online searching, I learned that it is possible to obtain the incoming phone number using call records, but this will NOT work for me because call records are only created after the call ends.

My question is: Is it possible, through the Graph API or some other method, to extract the phone number from an incoming call on Teams in real-time (or as close as possible) and pass that data to an application that can do something with it?

​I am a developer wanting to build an application to obtain the phone number from an (unanswered) inbound call on Teams in order to query a customer database for prior orders, etc., and open a window showing that data to the user receiving the incoming call. After a lot of online searching, I learned that it is possible to obtain the incoming phone number using call records, but this will NOT work for me because call records are only created after the call ends. My question is: Is it possible, through the Graph API or some other method, to extract the phone number from an incoming call on Teams in real-time (or as close as possible) and pass that data to an application that can do something with it?  Read More

​