Issue Modifying search_path Parameter for Azure Database for PostgreSQL

Azure Database for PostgreSQL users have recently reported an issue to us that occurs when setting a custom value for the search_path parameter from the Server parameters blade in the Azure Portal.  The issue is that this custom value is modified automatically by the service when saved.  For example: A value entered of: “$user”, public,…


EF 2.0 I am a believer

  EF Core 2.0 I am a believer I am not much of a database guy, I enjoy code and am not a big fan of learning new old tools SQL Management Studio, SSIS, etc… not my forte. So I am working on a project and exploring Database evolution.  The original project started with EF…


Top stories from the VSTS community – 2017.10.20

Here are top stories we found in our streams this week related to DevOps, VSTS, TFS and other interesting topics.  TOP STORIES Continuous Deployment of Cloud Services with VSTS – Oren NovotnyIn my last blog post, I showed how you can use ASP.NET Core with an Azure Cloud Service Web Role. The next step is…


Query Store Best Practices for Mission Critical or Busy SQL Server

Query Store feature helping lot of SQL Admin in isolating top resource consuming queries quickly and also troubleshooting plan choice regressed scenario which is difficult to isolate or time consuming process. Now with powerful report and using few clicks you can check top resource consuming query and force optimum plan. In this article I would…


Desired State Configuration(DSC) for SQL Server ***Update 2

Following up from my last post I have published the Failover Cluster Instance composite configurations and updated the previous configurations.  Initially lets talk about the updates to the which were pushed. Single Instance, Primary AlwaysOn,  and Secondary AlwaysOn  all had additional optional parameters added enabling all configurable items to be leveraged.  Each of these are…


Visual Studio Code C/C++ extension October 2017 update

Yesterday we shipped the October 2017 update of the Visual Studio Code C/C++ extension. Following the lightbulb suggestions for IntelliSense include path feature that was shipped last month, we’re adding another feature to make IntelliSense setup easier – support for the compile_commands.json file, eliminating the need for manually configuring includes and defines. In addition, this…


Pointing Build Definitions to Specific VMs (agents)

We’ve recently collaborated with some customers who are upgrading from previous releases of Dynamics 365 to the recent July 2017 application. These customers typically have to support their existing live environment on the older application, but also produce builds on the newer application (with newer platform). Currently the build agent is not aware of the…


Is Dynamics CRM (On-Premise as well as Online) Server-Side Sync filling up your ORG_MSCRM database and you wonder why?

Well, if you are wondering, looking at the TraceLogBase table size, that there is a problem with the Dynamics CRM Server-Side Sync, then I would say ‘NO’. There is no problem with the product but the fact that you might have ignored the fact that you are capturing all the logs, Information, Warnings & Errors!…


Microsoft EDU Moments

Happy Friday! It has been another busy week for our superb team of #MicrosoftEdu Educators!  Our Microsoft Moments blog this week will focus on: School Celebration Moment UK Digital Skills Program #MicrosoftEDU UK Roadshow Windows 10 Creators Update Top MIEE Tweet! Here’s this weeks Microsoft Moments: School Celebration Moment  This week we talk about the…