Thursday, December 14, 2017

ServiceStack is the future of Building Cross-Platform Web Services

ServiceStack is the current and future replacement to WCF, ASMX, MVC, MVC with Web API, Web API, SQL Server Web API, SQL Server HTTP Endpoints, Oracle Web Services, and other custom web service implementations for building cross-platform, client-agnostic, server-agnostic, web-service solutions.   I have used RestSharp client and ServiceStack web-services (on the server side) to create cross-platform, technology independent, micro-services implementations.   ServiceStack is AWESOME


The Flash traveling thru Space and Time, Stargate Portal, Wormhole

Thursday, March 3, 2016

SQL Server Index and Statistics Maintenance Scripts

SQL Scripts for index and statistics management which could help you manage SQL Server more efficiently and correctly.    Click here

Thursday, March 14, 2013

ContextSwitchDeadlock was detected

There is a bug in .NET RCW when frequently calling COM and/or COM+ components that use STA threading model.  The fix is to use the code from here.   In order to avoid the following error:


ContextSwitchDeadlock was detected
Message: The CLR has been unable to transition from COM context 0x16daf0 to COM context 0x16d8c8 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over timeTo avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.




Tuesday, June 14, 2011

Fastest SQL Server Paging implementation

I found a great article that shows the fastest sql paging implementation. Click here to learn more.