Microsoft Support & Discussions

Today, I worked on a service request that is related with our previous article Lesson Learned #276: ALTER TABLE statement conflicted with the CHECK constraint importing a bacpac - Microsoft Community Hub But, in this situation, is related about the business logic implemented by our customer. Let's analyze what happened with "The ALTER TABLE statement conflicted with the CHECK constraint "Table1". The conflict occurred in database "DatabaseName", table "Table1" As we mentioned before, our first approach was to follow up our article: Lesson Learned #276: ALTER TABLE statement conflicted with the CHECK constraint importing a bacpac - Microsoft Community Hub bu…

On January 13th, Windows Security and Microsoft Defender for Endpoint customers may have experienced a series of false positive detections for the Attack Surface Reduction (ASR) rule "Block Win32 API calls from Office macro" after updating to security intelligence build 1.381.2140.0. These detections resulted in the deletion of certain Windows shortcut (.lnk) files that matched the incorrect detection pattern. There is no impact for customers who do not have the “Block Win32 API calls from Office macro” rule turned on in block mode or did not update to security intelligence update build 1.381.2140.0. For currently impacted customers: what do I need to do? Impac…

Series Overview Orchestration allows conditional logic and enables user to take different based upon outcomes of a previous activity. Building upon the concepts of conditional paths, ADF and Synapse pipeline allows users to build versatile and resilient work flows that can handle unexpected errors that work smoothly in auto-pilot mode. This is an ongoing series that gradually level up and help you build even more complicated logic to handle more scenarios. We will walk through examples for some common use cases, and help you to build functional and useful work flows. Pre-requisite Before dive deep into pipeline logics and building complicated work flows, w…

We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.3. The update addresses a few issues on top of the 10.2.2 release. Fixed issues Fixed incorrect update counts when timeout occurs in batch queries 2024 Fixed incorrect token expiration date when using Azure Functions 2025 Fixed null SQL state and zero error code when database exception is thrown 2027 Getting the latest release The latest bits are available to download from Microsoft, from the GitHub repository, and via Maven Central. Add the JDBC 10.2.3 RTW driver to your Maven project by adding the following code to your POM file to include it as a dependency in y…

We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.3. The update addresses a few issues on top of the 11.2.2 release. Fixed issues Fixed null SQL state and zero error code when database exception is thrown 2022 Fixed incorrect update counts when timeout occurs in batch queries 2021 Fixed incorrect token expiration date when using Azure Functions 2020 Fixed connecting to the wrong SQLServer host 2019 Getting the latest release The latest bits are available to download from Microsoft, from the GitHub repository, and via Maven Central. Add the JDBC 11.2.3 RTW driver to your Maven project by adding the following code …

Students and recent graduates can get ready for the Cloud with a free training webinar to prepare for a free certification exam. Build skills that open doors! Register now for a live Microsoft Fundamentals training webinar featuring AZ-900 Azure Fundamentals or AI-900 AI Fundamentals certification content. These technical, expert-led skilling events are 100% free for eligible students and recent graduates and are an excellent opportunity to prepare for taking the Microsoft Fundamentals certification exams. * Don’t miss out on this exclusive, time-limited offer to get ready for the Cloud and boost your employability. Reserve your spot before they’re al…

Authors: Reza Ramezanpour, Dhiraj Sehgal and Tommy Falgout Cloud computing revolutionized how a business can establish its digital presence. Nowadays, by leveraging cloud features such as scalability, elasticity, and convenience, businesses can deploy, grow, or test an environment in every corner of the world without worrying about building the required infrastructure. Unlike the traditional model, which was based on notifying the service provider to set up the resources for customers in advance, in an on-demand model, cloud providers implement application programming interfaces (API) that can be used by customers to deploy resources on demand. This allows t…

Heya folks, Ned here again. Starting in Windows 11 Insider Preview Build 25276, the Pro editions of Windows now disable SMB insecure guest authentication fallbacks by default. Guest logons don't require passwords & don't support standard security features like signing and encryption. Allowing a client to use guest logons makes the user vulnerable to attacker-in-the-middle scenarios or malicious server scenarios - for instance, a phishing attack that tricks a user into opening a file on a remote share or a spoofed server that tricks a client into thinking it's a legitimate one. The attacker doesn't need to know the user's credentials and a bad password is ignor…

About the Author I am pursuing my bachelor's degree from IIT Roorkee, India and a Beta Microsoft Learn Student Ambassador. I am passionate about Web Development and Open-Source Contribution. I also like sharing tech information with others. Web Apps is one of the Azure services which enables users to host web applications for FREE. Azure Web Apps host user interactive websites. Now, why should students consider using Azure to build websites? Auto Scale: Azure promises 99.95% availability in its service level agreement for web apps. In helps users to scale up or scale out the web apps instances when required. Easy Deployments: Users can dire…

Announced at Ignite 2022, the integration of Microsoft Planner with Viva Goals is now available. This capability enables you to view your teams' Planner tasks and update the Objectives and Key Results (OKRs) in Viva Goals that relate to your Planner work. You can automatically track your team's progress towards your high-level key results based on the completion of day-to-day tasks in Planner. For more information about Viva Goals, check out the Make Your Goals a Reality with OKRs and New Capabilities from Microsoft Viva Goals and 4 goal-setting trends for 2023 and how Microsoft Viva Goals can help articles. Continue reading...

As we enter a new year, more gyms are packed, more books are read, but within the first month, about a third of individuals will see a dissolution of their goals. Setting goals and sticking to them isn’t just a challenge for personal pursuits—it holds true for your professional life too. Organizations and business leaders are looking for ways to weather the uncertainty and economic pressures while creating an engaged workforce to achieve business objectives. One of the major challenges they face is building organizational clarity and purpose, while also trying to “do more with less”. This is where combining a goal-setting strategy with the right technology …

We are pleased to announce the following new features, improvements, and bug fixes in the BingAds SDK December 2022 Release (V13.0.15). Key Features New API Interfaces AdInsight API: GetTextAssetSuggestionsByFinalUrls GetRecommendations [*]CustomerManagement API: New interface for SignupCustomer [*]Reporting API: Hotel Ad reporting Video reporting [*]CampaignManagement API: OnlineConversionAdjustment HotelAds New bidding schemes (PercentCpc, Commission) [*]Bulk service Bulk support for OnlineConversionAdjustment Bulk support for Hotel Ad entities, i.e.  HotelAdvanceBookingWindowCriterion, HotelCheckInDayCri…

In January, many of us are thinking about our goals, priorities, and aspirations for the new year. An important aspect of this is personal growth and development: what new skills do we want to develop, or experiences do we want to have? Unfortunately as the year goes on, people often forget to prioritize learning. As we get caught up in day-to-day work tasks, we put activities for longer-term growth and development on the back burner. That’s why it’s crucial for companies to create a culture of learning by embedding employee learning into everyday tools and experiences where people spend time at work. Led by people, facilitated by technology A culture of learnin…

In September 2022, we announced the option to configure the number of TempDB files and their growth increments. For more details, read Improve your SQL Managed Instance performance with new TempDB configurations. Today we are pleased to announce a new option to configure your TempDB max size. As expected, your new TempDB configuration will persist upon a server restart, an instance update management operation or a failover. What are TempDB size, used space and free space? TempDB size is the sum of the file sizes of all TempDB files. A TempDB file size is an allocated (zeroed) space for that TempDB file. Initial file size for all TempDB files is 16 MB. That…

The MVP Program has a long-term commitment to skilling through technical communities. In this interviews series focusing on skilling initiatives, we will be highlighting MVPs who actively contributes to the Skilling Program. Vlad Catrinescu, Canada Tell us a little about yourself. What is your focus as an MVP and what do you do professionally? “I’m an Microsoft 365 Apps and Services MVP which the name of the official category. The category is quite big, but I specialize in the Microsoft 365 collaboration stack, mostly from an IT PRO point of view. You will often see me speaking about Teams, SharePoint, OneDrive, PowerShell, and more. Professional…

We found today an out of memory exception raised by SQL Server Management Studio exporting a database. This exception may occurs because, for performance improvement the export process, this process uses memory to extract schema model and depending how large is your schema objects definition, for example, how many tables, contraints, indexes, etc.. you could reach this error message. To avoid this specific exception, using the parameter /p:Storage=File with SqlPackage redirect the backing storage for the schema model used during extraction to storage instead of memory. Use the following command line to include /p:Storage=File - sqlpackage.exe /Action:Export /ssn:t…

Our customer has the following scenario: They need to import CSV file from a blob storage to Azure SQL Database. To perform this operation our customer is using BULK insert option. CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password123!!!!' CREATE DATABASE SCOPED CREDENTIAL [JM_Scope] WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = 'sv=2021-06-08&ss=b&srt=sco&sp=rwdlaciyx&se=2023-01-13T16:39:22Z&st=2023-01-13T08:39:22Z&spr=https&sig=k6XYHDjqsco7fyuGt...' CREATE EXTERNAL DATA SOURCE [JM_EXT_DSource] WITH ( TYPE = BLOB_STORAGE, LOCATION = 'https://blogstorage.blob.core.windows.net/import/', CREDENTIAL = [JM…

You are not Alone Yes, you are not alone on this Tech journey. Whatsoever you are facing now, we have students that have gone through them too and that are doing amazing things today. Wouldn't you like to hear from some of these students? Register for the Event Click on the image below to register for the event You can also click here to register for the event Connect and Network During this event, you have the opportunity to speak directly with current Microsoft Learn Student Ambassadors who are students like you and ask them any questions you may have about their experience, the program, and the tech industry as a whole. This …

Note that official support for PHP 8 will only be available on Linux, as a result of this App Service will only support PHP 8 on Apps Service Linux instances. For additional information on this topic: PHP on App Service, php.internals: Microsoft Support of PHP on Windows. This article will demonstrate on how to use PHP 8 for App Service Windows, since there would be no official support from Microsoft for it, please use at your own risk. Generally, we are following this post: How to use a Custom PHP runtime for App Service Windows - (azureossd.github.io) to download a custom PHP runtime and map Handler for it. 1. Create a new Web app for Windows using …

Tamper protection is a feature of Microsoft Defender for Endpoint that prevents antivirus tampering and misconfiguration by malicious apps and actors. Microsoft Intune and Microsoft Defender for Endpoint integrate to allow enterprises to selectively enable and disable tamper protection in their environment. We received customer feedback to expand protections. One of the most requested features for tamper protection is protection of antivirus exclusions. With that in mind, the Microsoft Defender team has implemented new functionality that allows (path, process, and extension) to be protected when deployed with Intune. Microsoft has enabled functionality tha…

With any client/server application there are times when things are not in sync between the server and the client, and you want to correct that. Most of the time there are automated ways this will happen, perhaps on a schedule or a triggered event. Inevitably there are also times when you want that resync to happen NOW and not wait until the normal automated processes kick off. There are four ways to do this for Intune devices and while they are very similar, there are differences in what you can expect from them. In Intune the primary method most admins will be familiar with is from the Admin console. This will tell the software client to do a normal, scheduled…

It is not the first time, that we used to have this type of service requests that our customers reported slow connections in an Elastic Database Pool. Following I would like to share some details about my lessons learned about this topic. Besides following the best practices about connection and command retry-logic, connection pooling and redirection, we need too know several topics: Connection Pooling definition: as Connecting to a data source can be time consuming. To minimize the cost of opening connections, drivers uses an optimization technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections. This is c…

On April 11, 2023, less than 90 days from today, Exchange Server 2013 reaches End of Support! After that date, Microsoft will no longer provide: Technical support for problems that may occur Bug fixes for issues that are discovered and that may impact the stability and usability of the server Security fixes for vulnerabilities that are discovered and that may make the server vulnerable to security breaches Time zone updates Exchange Server 2013 will continue to run after this date, of course; however, due to the risks listed above, we strongly recommend that you migrate from Exchange Server 2013 as soon as possible. If you haven't started your migration fro…

Introduction Preventing sensitive data, such as customer personal records like Date of Birth or SSN, from traversing the internet helps you maintain compliance with regulations such as GDPR, CCPA and payment card industry (PCI). It is critical for customers in the financial services, healthcare, and government sectors. Azure Private Link, when combined with Azure Firewall, ensures sensitive traffic not only stays on the Azure network but is also monitored, audited, and secured. Securing traffic using Azure Firewall To help meet data security, customers use Azure Firewall to inspect traffic flowing between their on-premises networks & cloud infra. …