Microsoft Support & Discussions

How to see the queries that PBI (Or any other tool) send to Kusto/ADX Why do you need to see the queries? When you use PBI with data from ADX / KQL database (In Fabric) in direct query, the KQL queries are generated by the native connector in stages. You can start by using a quick PBI report in Fabric or use Power BI desktop and paste a KQL query that or navigate to a table / function. In the Power Query editor, you can do transformations to the data which will be translated(aka folded) to KQL and added to the original query or table. Once in the report you will have other elements that will add more parts to the query like measures , calculated …

This blog is not intended to cover CosmosDb in detail, we will glance at some of its main features, then present a use case of integrating it into an existing SQL application. If the reader is already familiar with Cosmos you may skip the intro section. Introduction Document databases gained huge popularity in the past decade. Their flexible and semi structured nature makes it easier for developers to persist and query data, when compared to traditional relational engines. Their hierarchical format facilitates binding database fields to object-model or user interface attributes, especially when dealing with complex entities with multiple collections and nested att…

I dagens stadig mer digitale verden er AI-teknologi i ferd med å transformere måten vi jobber på. Som en pioner innen innovasjon har Microsoft introdusert nye spennende funksjoner under navnet Microsoft 365 Copilot, samtidig som de har offentliggjort 2023 Work Trend Index. Disse initiativene gir et innblikk i hvordan AI vil forme fremtidens arbeidsplass og jobbprosesser. I denne bloggposten skal vi utforske de nye Microsoft 365 Copilot-funksjonene og utforske de fascinerende funnene fra 2023 Work Trend Index. Microsoft 365 Copilot er et sett med AI-drevne funksjoner som er designet for å øke produktiviteten, forbedre samarbeidet og støtte brukerne i deres daglige a…

Today, we got a new issue that our customer faced the error - Failed to connect to storage account with OS error 53 configuring transactional replication in Azure SQL Managed Instance. In this situation, our customer configured the storage account with private endpoint and all points to that the issue is related due to DNS misconfiguration. We followed the troubleshooting steps reported here: Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance - Microsoft Community Hub After following the article Synchronize virtual network DNS servers setting on SQL Managed Instance virtual cluster - Azure SQL ... our c…

Cloud Solution Provider (CSP) Hoster-programmet fra Microsoft har blitt en viktig plattform for kunder og partnere som ønsker å dra nytte av skyteknologi og tjenester. Nylig kunngjorde Microsoft et spennende veikart for planlagte forbedringer, som lover å redusere kostnader og gi enda flere fordeler for alle involverte parter. I denne posten skal vi se nærmere på disse kunngjorte endringene og deres potensiale for å forbedre opplevelsen for kunder og partnere i CSP Hoster-programmet. Reduserte kostnader og økte fordeler: Microsoft's veikart for forbedringer i CSP Hoster-programmet inneholder flere nye tilbud og programendringer som er utformet for å hjelpe kunder o…

This blog post has been co-authored by Microsoft and Bala RameshBabu from NetApp. Windows containers are on the rise and one question customers running enterprise workloads have is: How does one go about provisioning SMB file shares for Windows containers on Azure Kubernetes Service (AKS)? This technical blog explains a reference architecture that uses AKS and Azure NetApp Files for providing persistent storage to containerized Windows applications. An overview of Azure NetApp Files and Astra Control Azure NetApp Files is an enterprise grade native managed file storage service on Azure, powered by NetApp. It provides the following benefits: Thr…

I et forsøk på å skape en forenklet opplevelse for partnerne våre, samler vi nå Surface PC- og Hub-kanalene til én enkelt kanal. Fra og med denne måneden vil vi invitere alle partnere til å signere den nyeste kanalpartneravtalen i Partner Center for å fortsatt være autorisert til å selge Surface-porteføljen, som nå dekker alle produkttyper. For mer detaljer besøk Surface Reseller Alliance Portal her Continue reading...

Microsoft Build, en av årets mest etterlengtede utviklerkonferanser, har nettopp avslørt over 50 spennende oppdateringer for utviklere. Dette inkluderer alt fra spennende integrasjoner som Bing til ChatGPT, banebrytende verktøy som Windows Copilot, en ny Copilot Stack med felles utvidbarhet, Azure AI Studio og en revolusjonerende dataanalyseplattform kalt Microsoft Fabric. La oss dykke ned i noen av de mest bemerkelsesverdige oppdateringene og se hvordan de vil påvirke utviklingsverdenen. Bing møter ChatGPT: Microsoft har tatt et stort skritt fremover ved å integrere Bing i ChatGPT, noe som gir utviklere muligheten til å benytte seg av Bing-søkens kraft direkte i …

30 years of the MVP Program marked a highly awaited gathering of Most Valuable Professionals (MVP), Regional Directors (RD), Product Groups and Community Managers for the first hybrid MVP Global Summit, and 4 years since meeting in person post pandemic. Excited MVPs ascended in the hallways of Microsoft’s Headquarters in Redmond, filling their bellies with Microsoft’s famous breakfast bacon as they prepared to embrace their day to connect and learn with their peers. Whilst around the globe, virtual attendees dedicated the early and late hours of their days (and all the hours in between!), contributing to discussion, and catching the latest product news and update…

Gone are the days where all you are required to do as a Data Analyst is to create Reports and Dashboards for the business. We are now in the age of decision intelligence where you are required to directly support business decisions through the output from your Power BI Reports and Dashboards. To meet this level of demand and expectations, you need to start leveraging the AI capabilities in Power BI. In case you are not aware, Power BI has so many AI Features that will 10x your productivity and greatly improve the quality of your work. Let's Explore the AI Features together Smart Data Discovery and Visualization in Power BI Power BI is rich in AI …

Quick fix is now available in the query editor The query editor provides suggestions and warnings as you write your queries. The quick fix feature can be used to adjust the query based on these suggestions and warnings. To fix a query based on a suggestion or warning: Hover over the term to view the suggestion or warning. Select Quick fix to show the available quick fix options. Select the desired quick fix option. You can also use this feature to extract a value out into a variable: Or define an existing function inline before its use. Adding an inline function definition may be useful to improve readability and maintainability …

Troubleshoot Spring Apps OutOfMemory(OOM) issue Java Memory Management Heap memory Young Generation: where all new objects are allocated and aged Eden Space: where new objects are allocated Survivor Space: where objects moved from Eden after surviving one garbage collection cycle are. Survivor Space is divided to two parts, s1 and s2. Old Generation: also called Tenured Space, where objects having remained in the survivor spaces for a long time are. [*]Non-heap memory: By default the maximun it size is the 1/4 of the memory requested Metaspace : which stores the class definitions loaded by class loaders Compressed Class Space: which is for compressed…

Even before the pandemic, researchers long wondered what it would mean if going to work didn’t mean going to work. How might our jobs, offices, and workdays change if modern technology allowed us to disconnect from physical locations? What would be the real benefits? What would be the hindrances? Then COVID-19 hit. From a business perspective, everything became upended and uncertain—but from a researcher perspective, it created a tremendous opportunity. If social scientists ever wanted to engineer a massive study on the effects of an all-digital workforce, this was their chance. At Microsoft, scientists began considering the research possibilities in early March, a…

One question that we hear quite often is why we chose to capitalize the first three letters when abbreviating this feature sometimes, and at other times, we chose not to. For example, why only abbreviate it like PSP optimization, and not just PSPO? As one of the new members of the growing Intelligent Query Processing (IQP) family, PSPO has had a few growing pains. But PSP (see, there I go with the short abbreviation inconsistency again) is continuing to take steps towards addressing one of the most common performance challenges in SQL Server, bad parameter sniffing. Not all parameter sniffing is bad, and PSPO, while in its introduction to the database world, has ta…

By Rebecca Muller, Community Editor at Thrive Global When you're overwhelmed, your first instinct might be to jump around from task to task, trying to get it all done without any structure. After all, when your to-do list seems like it's a mile long, and your plate is overflowing, organizing your tasks into designated time blocks can seem like the last thing you want to do — but experts tell us it's exactly what you need to manage your stress, and break free of the perpetual time famine that comes from trying to do everything at once. Research finds that "timeboxing" your workload into visual blocks can help you stay organized when you have a lot to do, and …

Illustration by Javier Jaen Call 2020 the year that everyone had to learn to adapt. The pandemic affected everyone differently. But the one thing we all had in common is that nothing went as planned. We had to reimagine how we worked, learned, and shopped. How we communicated. How we lived. Through it all, confronted with so many challenges, people showed a remarkable spirit of resilience. Individuals, families, and organizations displayed an inspiring adaptability. Disruptions caused setbacks, but we responded with flexibility and ingenuity. As valuable as resilience is in the face of adversity and uncertainty, what is it, really? Is it a display of …

Neha Shah and Jonathan Larson Resilient organizations weather crises by adapting with flexibility, ultimately emerging stronger. That is easier said than done, of course. While many organizations may strive toward resilience, leaders have limited clarity into how to measure progress, much less manage it. The difficulty lies in resilience being an interdependent, systemic function of responses from individual employees, workgroups and the organization. To address this complex problem, we turn to organizational network analysis (ONA), which allows us to visualize and measure the complete system, while also breaking it down to meaningful chunks. Organizational …

By Marina Khidekel, Chief Content Officer at Thrive Global There's a phrase that Thrive's founder and CEO Arianna Huffington often says: "Stress is inevitable, but cumulative stress is avoidable." And since we all have days where our to-do list is a mile long and we feel completely in over our heads, it's important to arm ourselves with tools to get ahead of the stress before it becomes cumulative and leads to burnout. We asked our Thrive community to share with us the small ways they get ahead of stress before it overwhelms them. Which of these strategies will you try? Plan your day the night before "One tip that helps me is to plan my next da…

Illustration by Javier Jaén Research from Microsoft shows that huge numbers of people may leave their current jobs. As a result, businesses will have to recruit huge numbers of new employees. And they’ll have to do it amid what the Microsoft Work Trend Index calls “a disruption as great as last year’s sudden shift to remote work: the move to hybrid.” Over the last year, workers have spent less time physically in offices than ever before—which for many has led to feelings of disconnectedness from their teams. But that is only one reason for the expected turnover. As vaccination rates increase and the pandemic eases, many people are contemplating a major life …

Azure Database for MySQL - Flexible Server now supports semi-synchronous replication of data between two geo-paired regions. With this feature, you can now create a read replica in the Azure paired region of your source server to help ensure that your workloads are fault tolerant and resilient to regional disasters. You can also use this feature to position data closer to your users' location to provide low latency access for read workloads. Creating a read replica in a geo-paired region To access the functionality, in the Azure portal, navigate to Replication blade for your server. Click on Add replica and initiate a create replica provisioning workflow. Ple…

Greetings! I’m thrilled to announce that Conditional Access authentication strength is now generally available. This powerful feature allows organizations to choose the right authentication method requirements for specific scenarios, making it easier than ever for organizations to move towards more secure, modern, and strong authentication. With Conditional Access authentication strength, administrators can define a minimum level of authentication strength required for access, based on factors such as the user's sign-in risk level or the sensitivity of the resource being accessed. This can be especially useful for organizations that operate in highly regulated indu…

Forget about having to download the Azure Stack HCI ISO file and having to convert it to VHDX to use for Software Defined Networking (SDN) deployment, you can now directly download the Azure Stack HCI VHDX file from the Azure Stack HCI software download site: Azure Stack HCI Registration | Microsoft Azure. Once you fill in your details and click on Submit, you will see an option to download the Azure Stack HCI software. In the “Choose language” dropdown menu, select “English – VHDX” and click on “Download Azure Stack HCI” to download the VHDX file. For context, SDN in Azure Stack HCI uses a VHDX file containing the Azure Stack HCI operating system (OS) as a…

In Microsoft Fabric, a Lakehouse SQL Endpoint or Warehouse is accessible through a Tabular Data Stream, or TDS endpoint, familiar to all modern web applications that interact with a SQL Server endpoint. This is referred to as the SQL Connection String within the Microsoft Fabric user interface. To get started, you must complete the following prerequisites: You need access to a SQL Endpoint or a Warehouse within a Premium capacity workspace with contributor or above permissions. Authentication to warehouses in Fabric In Microsoft Fabric, two types of authenticated users are supported through the SQL connection string: Azure Active Directory (Azure AD…

With Viva Sales, Netlogic is growing sales, delighting its customers while improving employee work-life balance. "It has been a long journey to find the right solution for our productivity challenges, and until recently, there were few products like Copilot in Viva Sales. My team was thrilled when I used the new email thread summary feature in a meeting. We get tons of email threads every day. Now we can look at these six bullet points and understand what to do." said David Swenson. As a Business Development Director at Netlogic, David is constantly on the move, relying on Outlook and Teams to stay connected. He functions like a virtual CIO for his customer…

Voices of Healthcare Cloud is a webinar series hosted by myself, Aaron Porzondek & @Joshua Thompson. My name is Shelly Avery, I am currently a Dir, Healthcare Specialist for Health and Life Sciences focusing on the largest Payor and Provider customers in the US, Vasu is a Sr Customer Success Manager for Microsoft 365 for Health and Life Sciences & Josh is a Sr Account Executive for Healthcare. The goal of this webinar series is to highlight how Healthcare is seeing positive business and clinical outcomes with cloud technology. We will be bringing new and creative solutions to you at least once a month, so we hope you tune in live or catch the on-dem…