Month: February 2019

Hello Team, Some days ago, I worked in a service request in this following scenario: Using the portal, our customer, copied the database from one server to another. After it, our customer was not able to connect to the copied database in the destination server. I would like to explain why, performing the following example:… Continue reading Lesson Learned #71: Fixing an orphaned users using a copy database process in Azure SQL Databases.→

SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments.   When running on smaller environments SQL Server reduces the worker target. For an X64 installation, using the sp_configure ‘max worker threads’ value of 0 SQL Server uses the following calculation. On small environments SQL Server always uses… Continue reading SQL Server Worker Thread Default Calculation→

Final Update: Sunday, 10 February 2019 12:24 UTCWe’ve confirmed that all systems are back to normal with no customer impact as of 02/10, 12:00 UTC. Our logs show the incident started on 02/10, 11:20 UTC and that during the 40 minutes that it took to resolve the issue some customers whose data resides in South… Continue reading Experiencing Data Access Issue in Azure and OMS portal for Log Analytics – 02/10 – Resolved→

Microsoft is aware of the time zone change for Qyzylorda region of Kazakhstan. Qyzylorda will permanently switch from UTC+06:00 to UTC+05:00 on December 21, 2018 at 00:00 local time. A new Windows time zone will be created to reflect this change.
Our o… Continue reading Timezone update for Qyzylorda, Kazakhstan→

The text field for qualifier value in Azure portal under Integration Account > Partners > Set (AS2|X12|Edifact) Identity allows you to enter alphanumerical characters and a set of special characters limited to ‘-‘ (dash), ‘(‘, ‘)’ (parenthesis) and ‘.’ (dot). However the RFC 4130 defining the allowed characters in an AS2 partner identifier specifies a… Continue reading Special characters in Logic Apps B2B partners identifier→

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-10-deployment-guide/ The Performance Analyzer is delivered as a SQL Server solution and consists of a number of collectors as SQL jobs, X++ classes, VB scripts and performance counters. It also includes a set of sample SQL… Continue reading DynamicsPerf 2.10 Installation for Dynamics 365 Local Business Data (On Prem) / Dynamics AX→

INTRODUCTION The tool DynamicsPerf (Performance Analyzer for Dynamics) is used by Microsoft Dynamics Support team, Premier Field Engineers and Product Group team members to diagnose performance issues with Dynamics products such as Dynamics 365 Local Business Data (On Prem), Dynamics AX and Dynamics CRM. IMPORTANT: The purpose of the Performance Analyzer is to be used… Continue reading DynamicsPerf 2.10 Deployment Guide→

Recently on the OWASP DevSlop Show, Teri Radichel and I performed a security assessment of the Azure implementation for DevSlop.co. We did it based on my previous blog post, Pentesting Azure — Thoughts on Security in Cloud Computing. You may want to… Continue reading Pentesting Azure — The Report→