Tasks, Workers, Threads, Scheduler, Sessions, Connections, Requests – what does it all mean?

With this meditation I attempt to explain what some of the more common concepts that get used with SQL Server thread management and scheduling are. Parable: There was an all-powerful, but humble and benign Master, whom the workers revered and humbly served. The master accepted requests from other kingdoms and graciously agreed to grant all…


Meditation: Is the IOCP listener actually listening?

What is the IOCP Listener? The IOCP listener is a dedicated system thread that accepts incoming connections to SQL Server. It is a SQL Network Interface (SNI)-layer thread that listens for TCP/IP sockets or Named Pipes traffic (VIA is going away but still in the code). When a connection comes in, the listener accepts it…


SQL RPC vs. Windows RPC

  Question: “If one executes stored procedures using the RPC events mechanism (instead of Language events ), do any additional RPC ports need to be open (as is the case with SSIS )? Configuring the Windows Firewall to Allow SQL Server Access – http://msdn.microsoft.com/en-us/library/cc646023(v=sql.100).aspx   Answer: This confusion is introduced by “name overloading”, i.e “RPC”…


My crazy car project –Chapter II(not software/work related)

Now that I had a strategy in place how did it go? (For the initial strategy please see: https://blogs.msdn.microsoft.com/charles_sterling/2012/09/20/my-crazy-car-project-the-beginningnot-softwarework-related/ ) So how did the initial build out go? Step 1 build an engine…with Chevy small blocks this is easy and cheap(ish)   Step 2 Get a hoist to put it into the car…My Doubting wife…


Dual-use Coding Techniques for Games, part 1

Writing shared code for Windows Store, Xbox One, Universal Windows Platform (UWP) apps, and Win32 desktop apps Introduction Apps written for the Windows Store make use of the Windows Runtime (WinRT) and a restricted subset of Win32 APIs located in the core API family. Traditional Win32 desktop apps have access to a larger desktop API family,…


PowerShell: Script to recover all deleted items in a mailbox

UPDATE 14/9/2018: Script has now moved to https://gallery.technet.microsoft.com/exchange/PowerShell-Recover-items-89f9f92e, and supports recovery to original item location.  I’ve removed the script from this page, as it is outdated. We had a request recently for a sample PowerShell script that shows how to recover deleted items from and Exchange 2010 mailbox.  While not possible (as far as I am…


Controle de Conta de Usuário (UAC)

  Introdução O Controle de Conta de Usuário (UAC) é um conjunto de tecnologias de infraestrutura implantado no  Windows Vista e aperfeiçoado no Windows 7 que é frequentemente mal-entendido pela maioria dos usuários. A percepção comum é que o UAC é um recurso irritante e inútil cujo objetivo é perguntar se o usuário deseja realmente…


Traffic Analysis with Microsoft Data Explorer

For the past couple months, I’ve been running a simple app on my desktop which records the estimated length of my commute using Bing Maps Traffic. The output is stored in a CSV file. The CSV file looks like this: 12/1/2011,5:07 PM,HomeToWork,22:26 12/1/2011,5:07 PM,WorkToHome,33:44 12/1/2011,5:12 PM,HomeToWork,22:47 12/1/2011,5:12 PM,WorkToHome,35:20 12/1/2011,5:17 PM,HomeToWork,22:09 12/1/2011,5:17 PM,WorkToHome,35:33 12/1/2011,5:22 PM,HomeToWork,22:04 12/1/2011,5:22…


Overview of Microsoft Dynamics AX build numbers

For newer versions click here -> Microsoft Dynamics 365 for Finance and Operations builds Microsoft Dynamics AX 2012 R3     (Roadmap survey) Version Build Availability Download link Recent kernel build 6.3.6000.7213 08 Oct 2018 KB4465786 Cumulative Update 13 6.3.6000.149* 13 Sep 2017 KB4032175 Cumulative Update 12 6.3.5000.138* 21 Nov 2016 KB3199741 Cumulative Update 11 6.3.4000.127 29 Jun 2016 KB3157865…


Fantasy NASCAR + Microsoft Data Explorer

As a member of the Data Explorer team and a fan of NASCAR, it was only natural (or not?) that I would combine the two. Besides, it’s fun to file bugs to our dev team who overwhelming choose soccer as their favorite sport. Even as I write this I can hear them saying, “It’s football,…