Microsoft Support & Discussions
Free PC Help Forum microsoft products support and discussions. If you need help with Microsoft Windows, Windows Server software, Microsoft 365, Microsoft Azure or any other Microsoft product you can post here. If you want to discuss Microsoft and their line of products you can do that here also.
84,928 topics in this forum
-
Automating cumbersome tasks - Disk snapshots!
by Guest DarrenTurchiarelli- 0 replies
- 0 views
With cost optimization being at the forefront of many conversations, organizations as well as individuals are constantly seeking new ways to optimize their Azure environment from an operational lens, remove the attack surface area and subsequently their spend in an automated fashion. Azure Advisor is one offering where consumers can review recommendations based on cost, security, reliability, operational excellence, and overall performance. There is a treasure trove of recommendations within each of these categories coupled with quick fixes, but some consumers want to take these recommendations a step further and leverage automation to do the heavy lifting for them. …
-
Lesson Learned #311:Error-1117 the request could not be performed because of an I/O device error
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Our customer got the following error message performing a backup very large database to a blog storage - Error-1117 the request could not be performed because of an I/O device error. In this situation, you may reach this error depending on the size of the blob storage, in this situation, please, run the backup in stripping backup format "Azure Blob Storage block blobs have 200GB size limitation. If your database is bigger than 200GB, you should use stripped backup by providing several URL locations where parts of the backup will be placed" Native database backup in Azure SQL Managed Instance | Microsoft Learn Also, remember at the moment of the restore if yo…
-
Getting started with ML.NET
by Guest carlottacaste- 0 replies
- 0 views
What is ML.NET Machine learning (ML) is everywhere. We use ML empowered applications every day: when choosing the next TV series to watch based on Netflix recommendations for example, or when asking Alexa to play our favorite song. Soon every application on every platform will incorporate some ML capabilities, empowering the application itself and making it smarter. This is the key reason why ML has been added into the .NET ecosystem a few years back, by creating an open-source framework (ML.NET) which enables developers to train, build and ship custom ML models for a wide range of scenarios (sentiment analysis, forecasting, recommendations and more). Since then, th…
-
DB2 Installation Guide on ANF
by Guest RalfKlahr- 0 replies
- 0 views
DB2 Installation Guide on ANF Introduction This document will show how you can install SAP NetWeaver 7.5 based on IBM DB2 11.1 and SLES12SP5 in Azure using Azure NetApp Files (ANF) as storage platform for data and log areas. As of July 26th 2022, this combination is fully supported by IBM. SAP notes: 2015553 - SAP on Microsoft Azure: Support prerequisites - SAP ONE Support Launchpad Microsoft documentation IBM Db2 Azure Virtual Machines DBMS deployment for SAP workload - Azure Virtual Machines | Microsoft Docs Set up IBM Db2 HADR on Azure virtual machines (VMs) - Azure Virtual Machines | Microsoft Docs SAP on UNIX and DB2 with NFS and Network…
-
ANF Backup for SAP Solutions
by Guest RalfKlahr- 0 replies
- 0 views
ANF Backup for SAP Solutions Introduction Azure NetApp Files backup expands the data protection capabilities of Azure NetApp Files by providing fully managed backup solution for long-term recovery, archive, and compliance. Backups created by the service are stored in Azure storage, independent of volume snapshots that are available for near-term recovery or cloning. Backups taken by the service can be restored to new Azure NetApp Files volumes within the same Azure region. Azure NetApp Files backup supports both policy-based (scheduled) backups and manual (on-demand) backups. For additional information, see How Azure NetApp Files snapshots work To start with pl…
-
Lesson Learned #310: Parameter Sniffing
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
When we are using parameterized queries with object such as stored proecdure and functions, the engine can take the value passed to a parameter and use it to compare with statistics (index or colum). This is known as parameter sniffing Basically, running a stored procedure the first compilation the optimizer "sniff" the parameter value and compile the query with the distribution of the statistics of this value. In many cases, parameter sniffing reduces time in compilation and perform much better the execution, but, sometimes a high variance in terms of data distribution will impact in the performance. For example, if the first execution of a query u…
-
MTC Weekly Roundup - January 27
by Guest Cecilia_Bergstedt- 0 replies
- 0 views
Hello and happy Friday, MTC! January is almost over if you can believe it (I can’t!), but the year is just getting started and we have tons of events and content coming your way soon! So, let’s recap this week’s happenings and take a look at what’s coming in the community! MTC Moments of the Week To start off, we want to give a shout out to this week’s MTC Member of the Week, @RecepGencaslan! Recep joined the MTC earlier this month (welcome!), and they’ve already hit the ground running by engaging in the SharePoint and Exchange forums. Hats off to you! Next up, in events, we had our first monthly AMA of the year with experts from the Windows 36…
-
Lesson Learned #309: Create a DDL Trigger on Database in Azure SQL
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Today, I've an interested way to add an additional logical at the moment that we create or drop a table, basically using, CREATE TRIGGER [XZY] ON DATABASE AFTER create_table For example, we could create this trigger to prevent that our users don't create table without using in the name of the table the prefix test. CREATE TRIGGER [TR_DDL_AFTER_TABLE] ON DATABASE after create_table as declare @AffectedTable nvarchar(255) Select @AffectedTable = EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(100)') declare @AffectedSchema nvarchar(255) Select @AffectedSchema = EVENTDATA().value('(/EVENT_INSTANCE/SchemaName)[1]','nvarchar(100)')…
-
Lesson Learned #308:Extended properties are not permitted on 'dbo.xyz', or the object does not exist
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Today, we worked on a service request that our customer is implementing DATA SYNC and they got the following error message: "Database re-provisioning failed with the exception 'SqlException Error Code: -2146232060 - SqlError Number:15135, Message: Object is invalid. Extended properties are not permitted on 'dbo.schema_info_dss', or the object does not exist. This error occurs when the application is calling sys.sp_addextendedproperty and you specify an incorrect schema of the table, for example, dbo (the table schema_info_dss is based on another schema) or simply the table doesn't exist. Example: EXEC sys.sp_addextendedproperty @name = N'Description' …
-
Meet a recent Microsoft Learn Student Ambassador graduate: Josh Tillson
by Guest Student_Developer_Team- 0 replies
- 0 views
Content warning: This post discusses mental health issues. Tell us your name, country, university and degree? My name is Josh Tillson, I’m a Computer Science and Business major at the University of British Columbia in Canada. [*]Why did you join the Student Ambassadors community? I joined to learn more about Microsoft tools and technologies while connecting with other students across the globe studying in similar fields. [*]What was being a Student Ambassador like? Both fun and empowering. The program is truly set up in such a way that in order to make the most of it, you need to take initiative and get involved. If you do so, you’ll get exposure…
-
Meet a recent Microsoft Learn Student Ambassador graduate: Jingyi Zhu
by Guest Student_Developer_Team- 0 replies
- 0 views
Tell us your name, country, university and degree? My name is Jingyi Zhu. I am pursuing a degree in Bachelor of Commerce, a double concentration in Management Information Systems and Human Resources at McGill University in Canada. I enjoyed the a lot as it has a lot of flexibility. On the one hand, I have to complete fundamental business courses to better understand how it works as a whole. On the other hand, I can specialize in the area I am interested in, which is technology and people. When did you join the Student Ambassadors community? I joined the Student Ambassadors program in October 2021, which was in my first semester as a senior student. …
-
Meet a recent Microsoft Learn Student Ambassador graduate: Saad Aslam
by Guest Student_Developer_Team- 0 replies
- 0 views
Tell us your name, country, university and degree? Hi . I am Saad Aslam. I graduated from Government College University Lahore in Pakistan with a bachelor’s degree in Computer Science. Gold Student Ambassador Saad Aslam When did you join the Student Ambassadors community? I joined Microsoft Learn Student Ambassadors Community in January, 2020. Was there a specific experience you had while you were in the program that had a profound impact on you? Why was it so impactful? For example – being involved in a Social Impact Project, Networking with a Cloud Advocate or MVP, Mentoring another Student Ambassador? Back in 2019, I…
-
Microsoft Dynamics 365 Sales
by Guest ShabnamMohammadi- 0 replies
- 0 views
Microsoft Dynamics 365 Sales enables salespeople to build strong relationships with their customers, take actions based on insights, and close deals faster. Use Dynamics 365 Sales to keep track of your accounts and contacts, nurture your sales from lead to order, and create sales collateral. You can also create marketing lists and campaigns and follow service cases associated with specific accounts or opportunities. Cool Feature of Dynamics 365 Sales Visual insights. The out-of-the-box dashboards and charts have almost everything that you need to get insight into your business. More information: Gain insights with dashboards in Dynamics 365 Sales. …
-
- 0 replies
- 0 views
This blog has been authored by Eva Chen, Program Manager, Microsoft Health and Life Sciences We recently announced the release of the Azure Health Data Services Toolkit, an open-source project that enables our customers to more easily customize and extend the functionality of their Azure Health Data Services implementations. A developer-centric toolkit for customization With the growth of health data workloads on Azure, we’ve found that developers need ways to build custom scenarios on top of our services. Currently, users do not have a consistent and developer-centric approach to allow customization or an easy way to run custom code with Azure Health …
-
Windows Server Learning Topics AMA Tuesday
by Guest jepatrick- 0 replies
- 0 views
Looking to grow your hybrid cloud and Azure skill set? This January 31 at 9 a.m. Pacific time you will get a chance to chat with Microsoft learning content creators, technical trainers, and cloud advocates about training and certification topics specifically geared towards Windows Server professionals. You can RSVP at aka.ms/windowsserverama Here's an introduction to the Microsoft team that will be on the chat to answer your questions: Vinicius Apolinario, Senior Cloud Advocate Ask me about: Windows Server Containers Julio Cruz, Microsoft Technical Trainer Ask me about: Multicloud, certifications Thomas Maurer…
-
Celebrating data privacy week—New Microsoft Priva features available in public preview
by Guest Alma- 0 replies
- 0 views
As we celebrate Data Privacy Week, we are reminded of the importance of keeping privacy top of mind. Data Privacy Week encourages us to learn more about protecting our privacy online, especially in a vast digital world. For individuals and organizations alike, privacy and security often go hand in hand. With ever increasing data footprints, strong awareness of online privacy is important, but handling data appropriately and respecting privacy are key. Microsoft recognizes the importance and challenge of managing personal data and launched Microsoft Priva to support organizations in their privacy journey in 2021. Today, Microsoft Priva offers two solut…
-
Diagnose and Resolve issues Blade – Self-help tool for troubleshooting issues.
by Guest Karthik Yella- 0 replies
- 0 views
Software fails, hardware breaks and you can run into issues when trying new things. Whenever we encounter an issue on Azure, we quickly open our favorite search engine, weed through the results, and look for answers pertaining to that issue. But what if I tell you that we have a blade in the Azure Portal that can help you diagnose and resolve issues, find authoritative troubleshooting resources (tools, guided steps, and articles), and easily get additional help as needed. The Diagnose and Solve problems blade empowers Azure customers to troubleshoot and solve Azure service issues via service/resource health insights, automated troubleshooters (insight diagnostics), cu…
-
Leveraging KEDA to scale Azure DevOps agents efficiently
by Guest AndreDewes_MSFT- 0 replies
- 0 views
Introduction The default option to have a scalable self-hosted pool in Azure Devops is use Azure virtual machine scale sets. However, if you have an ecosystem that is running mostly in containers and Kubernetes, you might also think about using containers instead and leverage KEDA scalable triggers to spin up more agents when the demand increases and lower them when the demand decreases. Compared to Azure VM scale sets, the Kubernetes instances are much faster to create (given you have available resources in the cluster and don't need to create new nodes). The purpose for this article is to quickly demonstrate a working solution for this scenario. It is not the…
-
Lesson Learned #307:Reference to database and/or server name is not supported in this version
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Our customer got the following error message: Msg 40515, Level 15, State 1, Line 19 - Reference to database and/or server name in 'DbName.dbo.TableName' is not supported in this version of SQL Server, executing the following TSQL: select * into [DbName].[dbo].[TableName] from [TableName2] As we mentioned, in this URL: Cross-database Query in Azure SQL Database. This requires accessing tables on different DBs using 3 part naming that is not possible in Azure SQL Database but in Azure SQL Managed Instance is possible. If we need to use Azure SQL Database, the recomendation is to use external tables - Cross-database Query in Azure SQL Database Continue readin…
-
Lesson Learned #306: TCP Provider, error: 2 - Connection was terminated
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
In some situations, we found that our application reported the following error message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated ) Working with our customer we found that this issue might be caused when our application server reachs CPU throttling, High Memory Utilization. Also, in AKS, High CPU Reservation (Requests) plus too many pods have very large difference between their CPU Requests and CPU Limits, these pods will be affected by CPU Throttling. To Protect the pods against CPU Throttling the recomendation is to Set their CPU Request equal to the high value…
-
Lesson Learned #305: Client Connection marked as broken because of SQLSTATE(08S01)
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Today, we worked on a service request that our customer is using Hikaki pooler and time to time they got the following error message: HikariPool-1 - Connection ConnectionID:18 ClientConnectionId: xxxx-xxxx-xxx marked as broken because of SQLSTATE(08S01), ErrorCode(0),exc.stack=com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out (Read failed) After reviewing several articles, for example, Improve Java application reliability with Azure SQL Database using JDBC and connection pooling. - Microsoft Community Hub , Using the JDBC driver - JDBC Driver for SQL Server | Microsoft Learn, We saw that our customer is facing TCP timeouts, following a r…
-
Power Apps Challenge: Peer-to-Peer Mentorship App
by Guest theoyinbooke- 0 replies
- 0 views
Prove Your Skill Are you up for this challenge? I need to ask you before we get started. Let me make this point clear, in this challenge, there is no losing, it's either you WIN or you WIN. Meaning, you have so much to win by participating in this challenge. While there are no prize, working on this project is a clear way to convince recruiter or potential employee on your ability to use Power Platform address business problems creatively. Use Case Description A medium-sized consulting firm wants to improve employee development and retention by providing mentorship opportunities for its employees. They decide to implement the Peer-…
-
Tackling AI Inference workloads on Azure’s NC A100 v4 virtual machines with time to spare
by Guest HugoAffaticati- 0 replies
- 0 views
by Hugo Affaticati (Technical Program Manager), Tonny Wong (Principal Product Manager), Jon Shelley (Principal TPM Manager), and John Lee (Principal Product Manager). Introduction The NC A100 v4-series virtual machines (VMs) on Azure offer great flexibility for a wide range of workloads. Powered by NVIDIA A100 80GB PCIe Tensor Core GPUs and 3rd generation AMD EPYC 7V13 (Milan) processors, these instances are well-suited for autonomous vehicle training, oil and gas reservoir simulation, video processing, AI/ML inference-powered web services, and much more. They are available in different sizes and configurations to support various computational needs, rangi…
-
A quick start guide to benchmarking AI models in Azure: MLPerf Inference v2.1 on Multi-Instance GPU
by Guest HugoAffaticati- 0 replies
- 0 views
By Hugo Affaticati – Technical Program Manager Useful resources: Information on the NC A100 v4-series: Microsoft Information on MIG: NVIDIA In this document, one will find the steps to run the MLPerf Inference v2.1 benchmarks for BERT, ResNet-50, RNN-T, and 3D-UNet on one of seven slices of NVIDIA-powered NC A100 v4-series Tensor Core GPUs with Multi-Instance GPU (MIG). Learn more about MIG on Azure and Azure’s submission to MLPerf Inference v2.1. Pre-requisites: Deploy and set up a virtual machine on Azure by following “Getting started with the NC A100 v4-series.” Set up the environment: Once your machine is deplo…
-
Armchair Architects: Is Big Data Turning into Dark Data?
by Guest EricCharran- 0 replies
- 0 views
Welcome back to another episode of Armchair Architects as part of the Azure Enablement show. Today we're going to talk about data, but not just any data. We're going to talk about this phenomenon called dark data and what do you do about it. I hadn't heard about this until I got a chance to talk to our architects, and it was super cool to learn about it and they'll help us understand what it is and what areas I should pay attention to. Let's go find out about dark data and let's go talk to our architects. I think it's time we talk about data and in particular, I want to talk about this thing I think that people are using to scare children at night when they want th…