Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server

What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans. One of the objectives of the SQL Server query optimizer (QO) is to spend a “reasonable time” in query optimization as compared to query execution….


Presentations, Poker and More on this Week’s Friday Five!

Xamarin Android WebView Authentication Oscar Garcia is a Principal Software Architect who resides in Sunny South Florida. He is a Microsoft MVP and certified solutions developer with many years of experience building solutions using .Net framework and multiple open source frameworks. Currently, he specializes in building solutions using technologies like SharePoint, ASP.NET, NodeJS, AngularJS, and other JavaScript…


Search administration in TFS for Collection Attach/Detach operations

Collection detach / attach operations will not require any additional management operation from Search configuration side if it’s done on the same TFS release instance. There are however few management operations that you need to aware of for more complex scenarios such as collection migration to a new TFS instance, collection re-attach to an upgraded…


Webinar 10/23: Advanced data prep with Power BI dataflows for unified data and powerful insights

Look at the all new Power BI dataflows with Program manager Anton Fritz Power BI dataflows’ public preview is just around the corner, in this session the product team will introduce you the new and advanced capabilities for data-prep in Power BI.  Preparing and defining ETL for insights is significant challenge for businesses today—ingestion, cleansing, transformation,…


Exploring Clang Tooling Part 1: Extending Clang-Tidy

This post is part of a regular series of posts where the C++ product team and other guests answer questions we have received from customers. The questions can be about anything C++ related: MSVC toolset, the standard language and library, the C++ standards committee, isocpp.org, CppCon, etc. Today’s post is by guest author Stephen Kelly,…


Inspecting a D365FO Meta Data Hotfix Content

In this article, you will find detailed instructions, on how to inspect content of a D365FO meta data hotfix. The article describes a manual approach as well as running PowerShell scripts to extract the underlying dependencies of hotfixes and affected objects. All descriptions are in attached “Inspecting a D365FO Meta Data Hotfix Content.docx” document. Inspecting-a-D365FO-Meta-Data-Hotfix-Content2


Creating the perfect MVP Summit

Was asked to share some thoughts on creating the Perfect MVP Summit. Every year we ask MVP’s what they want from the MVP Summit and every year the answers are the same: Insight into the product planning Connection with the product team members Despite this incredibly simple set of directives we still manage to get…


Twitter AMA on Service Fabric Mesh

The Service Fabric team will be hosting an Ask Me Anything (AMA) (more like “ask us anything”!) session for Service Fabric Mesh on Twitter on Tuesday, October 30thfrom 9am to 10:30am PST. Tweet to @servicefabric or @AzureSupport using #SFMeshAMA with your questions on Mesh and Service Fabric. What’s happening? We’ll have folks from the Service…