Tutorial of MS SQL Extended Events in 7 T-SQL Steps

Hi, today I would like to show you how you can use Extended Events Sessions on SQL Server 2008 or above. Extended Event Sessions are future of monitoring of the SQL Server. From many years solutions that used SQL Profiler Traces or DMV were not always accurate and fast. DMV queries could be very fast. However it is impossible to get statistics only per one sessions from DMV. And that is why I want to show you Continue ReadingTutorial of MS SQL Extended Events in 7 T-SQL Steps

Simple Service Bus Training

Hi, today I prepared my first screencast training on YouTube about the Simple Service Bus I made. It took me a lot of effort and it is just a start. If you like such content please share that information in comments. I would love to make more such videos in future. Here you can find ( downloads). Enjoy! p ;).

SQL Ninja uses ORDER BY with CASE

Hi, today I want to show you simple technique which can be used when you need parameterised ORDER BY cause in T-SQL. Sometimes you may want to have elegant query. Example is from my today’s code review that I gave to colleague. On the Internet is very difficult to find such solution. So, I decided to show it to you here. There are many possible scenarios for this example usage. For example you may want to have Continue ReadingSQL Ninja uses ORDER BY with CASE

Multi Service Bus Project Launch

Hi, I started today Multi Service Bus (GIT repo) project. Already I have full C# implementation. And I will be working on other languages implementations. First on Java and than on C++. I have some ideas how to made this in Java, but overall I am not Java expert, only C# expert, so that may be a bit difficult at the beginning. But I will be working on this, even if I do not know how. Of Continue ReadingMulti Service Bus Project Launch

Settlers IV PL on MacBook Pro in FullScreen 16:10

Hi. today I want to share with you solution of making Settlers IV PL – Gold Edition v. 2.50.1516 working on MacBook Pro fullscreen in 16:10 aspect ration resolution. Settlers IV is in my opinion one of the best fairy tail designed computer strategy. It was published in 2001 and still you can buy it. Also it not using DRM, so it is very important for emulation of the game. For make this game working on MacBook Continue ReadingSettlers IV PL on MacBook Pro in FullScreen 16:10

Coding by to Design of KinectCamV2

Hi, today I want to share with you design example of KinectCamV2. Steve Jobs sometimes used to say that design is not about how solutions and devices look, it is about how they work. And I just have seen today very nice design example at home of KinectCamV2. So, at this moment I had a good idea of today’s post for my blog. I think the best example of any design is to watch how people use Continue ReadingCoding by to Design of KinectCamV2

FastStringKeyDictionary Intro

Hi, today I will show you intro, partly implemented code of the fast dictionary with string type key. My work is partial. There are tests for Add, ContainsKey and TryGetValue methods. If you like you can continue this work and add also Remove method and an Enumerator. I left that to give you a direction and the idea but I want to left something for you. In fact easy part for work on your own. So, you Continue ReadingFastStringKeyDictionary Intro

Binary Tree Visible Nodes Counting

Hi, today I would like to share with you solution of the code puzzle with binary tree. There are 2 trees examples t1 and t2 and your job is to find visible nodes and visible nodes are that are not smaller then all parents. When you go down for t1 tree you can find 4 such visible nodes. And for the second tree there are 2 nodes that are visible. Important thing is that the root node Continue ReadingBinary Tree Visible Nodes Counting

Common Communicator

Hi, today I would like to share with you idea of creating common communication components. I did it many times and I have even prepared my own presentation with many examples of such kind of problem solution. After some time of experiments I created few design diagrams that implement communication in minimal and advanced way the same time. So, let me show you what is the design on common communicator that you can create for your own Continue ReadingCommon Communicator

Coder Legacy

In-Proc Agents CommunicationsHello, this is my first article on Aspect Coder Network and I decide to start with some very modern subject of software architecture I am working on by a very long time before on implementation on this idea on .NET/C# technology stack. It takes me about four years to find best practices of this subject. Which is modeling inter-process communications as a key of aspects designing for modeling multi-agent environment? It is useful technique, especially Continue ReadingCoder Legacy

TSQLTester for SQL Ninja with Mocking

Hi, I am using very often TSQLTester from the moment it was created. And it saved me a lot of time with my performance challenges. Of course my favorite advantage of TSQLTester is testing content of data. Today I would like to extend first implementation and give you option for mocking of procedures of functions that in standard production cases connecting to the Service Bus or writing to some Queue implementations in the middle of our code Continue ReadingTSQLTester for SQL Ninja with Mocking

Just Productivity Tools

Hi, I just get from Telerik very cool Just Code productivity tool. I received “Complimentary Developer License with Subscription and Priority Support” license for free, because one lady likes bonsai like me :). Just kidding, I get it to have a chance to write this review. I try also install Just Decompile tool because it is free and I had fillings that those two tool can helping me doing complementary work. I have to say that I Continue ReadingJust Productivity Tools