Code Puzzle – Get Behind Firewall

Hi, today I have very nice code puzzle for you. Code Puzzle is to implement two blue boxes in following diagram. That can be implemented in Java and/or C# with following requirements. The only system that can receive connections is behind green box that is a open server endpoint. The system behind red box is closed and you cannot connect to it. I have very special prize for the best, clean and easiest solution of this code Continue ReadingCode Puzzle – Get Behind Firewall

PL Lotto Predictor in C# with Encog 3.3

Yes, I know that it is impossible to predict lottery results. But if the results would be predictable? Of course I know they are not, but just hypothetically for a play with Perceptron Neural Network and prediction algorithms I want to show you that in 250 lines of code you are able to play with prediction thanks to Encog 3.3 library. I bought recently 2 Jeff Heaton’s  books about neural network and C# and his library. That Continue ReadingPL Lotto Predictor in C# with Encog 3.3

Batch Processing Aspect in Java

Hi, today I made port of my Batch Processing Aspect in Java. It is quite a bit different aspect than I made previously in C#. In C# I made something that is fully asynchronous and in Java I made aspect that does sync invocations from many threads. I have in my mind uses of this aspect to web application or web api or web service implementation that has static controller field for example named “batchProcessingAspect” and invokes Continue ReadingBatch Processing Aspect in Java

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 ;).

Using of TextWriter by StringBuilder

Hi, today I want to share with you very simple idea of using correctly TextWriter class. You can imagine that TextWriter is created on the network stream solution in SOA (WCF), REST (WebAPI) or Web (ASP.NET) application. When you write to that stream very often you could have a lot of unnecessary round-trips between clients and server. But there is a nice technique with StringBuilder I want to share with you in below tests. I think nothing Continue ReadingUsing of TextWriter by StringBuilder

SQL Ninja gets Products from Group Tree CTE

Hi, today I want to show you comparison of 2 possible techniques fro get data about all Products mapped to the Product Groups tree. I wrote as usual one T-SQL script that you can run each time you want to modify something to recalculate your results and check how they perform in your SQL Server. There are 2 nice things you can get from provided example. First is 2 ways of calculation that you can choose from. Continue ReadingSQL Ninja gets Products from Group Tree CTE

SQL Ninja moves Data in Auto Balancer Loop

Hi, today I want to share with you one of my last invention. That is extremely useful when you need to move data for example to historical or archive tables on your SQL Server. Imagine that the same moment you move your data someone can with lower probability use table you move data from. When you decide to insert data to new table and then delete them of course in delete query you lock whole table. Now Continue ReadingSQL Ninja moves Data in Auto Balancer Loop

SQL Ninja PK Clustered or Non Clustered for GUID

Hi today I would like to share with you experiment I did small experiment for checking improvement of operations in table with primary key that has UNIQUEIDENTIFIER (GUID) type and it is PRIMARY KEY in this table. I want to check what if PK will be CLUSTERED (by default) and what if PK will be NONCLUSTERED index. There is very common question on any job interview so, probably all of you already know the different between both Continue ReadingSQL Ninja PK Clustered or Non Clustered for GUID

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

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

PLSQLTester

Hi, today I am happy to announce PLSQLTester that is version of TSQLTester that works on Oracle database instead of Microsoft SQL Server. It works basically the same. and below you can find how it looks. It depends only on ODP.NET provider so, assembly Oracle.DataAccess need to be installed to build this solution. And it works the same way like TSQLTester there are following parameters: connectionStringFile, testCodeSqlFile, newCodeSqlFile, oldCodeSqlFile and preCodeSqlFile, postCodeSqlFile. And last two are not Continue ReadingPLSQLTester