We all got into Seattle, Wa last night however it got real tuff for me the last 30 minutes until we landed at SeaTac Airport. I started getting real dizzy and almost to the point of passing out. Now the crew mentioned that it happens all the time, however this was new and very scary for me. After a couple of cold napkins on the neck and some OJ, I started feeling better. If anyone has experienced this please let me know. The only thing I could figure was the 5 hour flight and sitting in the middle seat without really stretching. Anyways, I made it safe and getting ready for my presentation on Hacking Sql Server.

Dynamics backend is SQL and at first glance it seems that it could be queried and changed just like any other Sql Server backend, but there are fields and relationships that you might not be made aware of. Also, after doing some research, we realized that the Business Connector  that comes with Dynamics was the interface of choice for getting data to Dynamics. Still the question was, "how?" and still have real time updates like we do using Service Broker to get data out. Our model was simple, for the two endpoints call stored procedures that would send messages between the two databases and by the way, this is why we are using Service Broker. It is extremely light for doing this type of functionality. The problem was calling the Business Connector from the DAX side once messages started piling in the queues. I could have had another process running that processed the queues but I wanted to try and keep the same model. Immediately my answer was a CLR Stored Procedure  that could call the managed Business Connector. At least I thought it was totally managed as an interop dll. Something I learned was it was not and it could not be added into SQL's CLR. I saw some articles of how to do it with web services; however I knew that I could probably use WCF as well. After reading a couple of articles I was able to implement it.

My vision is clear...I want to build back up the energy that JaxDUG had when I first joined it. My passion is technology and I hope to share it by sharing knowledge and building new technology community leaders. Before JaxDUG, I had never spoken to anyone as a group. In fact, some may have heard my story about me taking Speech in college. My professor told me that he would pass me, however he recommended that I steer away from public speaking. Well here I am speaking at Code Camps, User Groups, and major technology conferences and I owe it all to JaxDUG.