Opinions, tips, and news orbiting Microsoft
First published on MSDN on May 26, 2017 There are times when you just run into something and you can deem less important and continue. And there are times, where you have to stop and deal with it. In the past few weeks this wait type has simply come … Continue reading DBMIRROR_DBM_MUTEX: The world of Redo Operations
First published on MSDN on Aug 18, 2017 In a customer scenario we saw a query against system views related to AlwaysOn taking a fairly long time. SELECT * FROM sys.availability_databases_cluster adc INNER JOIN&nbs… Continue reading What really happens when HADR_CLUSAPI_CALL wait type is set?
First published on MSDN on Dec 07, 2017 Customer was receiving the following error:
Msg 8169, Level 16, State 2, Line 1 Conversion failed when converting from a character string to uniqueidentifier.
Here are all the ways that you can recreate this e… Continue reading Dealing with error 8169 “Conversion failed when converting from a character string to uniqueidentifier. “
First published on MSDN on Dec 07, 2017 A customer approached us asking for help on automatic a monitoring process. The goal was to send some type of notification when a particular threshold was reached. He had already discovered this blog but still … Continue reading Create a monitoring and notification mechanism for HADR worker thread Pool
First published on MSDN on Jan 12, 2018 Recently, we have observed a number of cases where DBAs or application developers are complaining about out-of-memory errors or even machine not responding (hangs) despite the fact that there is plenty of … Continue reading OS Hang or Out of Memory due to SQL Ser… No Wait, it’s SQL Analysis Services (SSAS)
First published on MSDN on Dec 16, 2012 Have you wondered if there is a simple way to find out if a query is slowed down by bottlenecks? Looking at the Duration (Elapsed Time) and CPU (Worker Time) reported by a completed query can reveal the answer…. Continue reading SQL Performance Meditation: Duration and CPU Reveal a Profound Truth
“Why is this value changing unexpectedly and where or when is this occurring?!” This is a question many of us dread asking ourselves, knowing that we’ll have to do some tedious trial-and-error debugging to locate the source of this issue. For C++ developers, the exclusive solution to this problem has been the data breakpoint, a… Continue reading Break When Value Changes: Data Breakpoints for .NET Core in Visual Studio 2019
Xamarin.Essentials provides developers with cross-platform APIs for their mobile applications. On this week’s Essential API of the week we take a look at Clipboard, which enables you to easily get and set text to the system wide clipboard.Show Not… Continue reading Clipboard (Xamarin.Essentials API of the Week) | The Xamarin Show