A year ago Torsten Ahlemeyer created a networkable ship sinking game with pure T-SQL for training purposes. In the meantime, this project has been greatly expanded and has, among other things, got an opponent in the form of an AI instance implemented in Azure. Originally only intended to teach beginners the subtleties of the query language, including advanced programming such as PIVOT, recursion, triggers, runtime optimization, etc., using a continuous example, the project has developed a life of its own. Starting with the graphical user interface through to the implementation of various levels of the T-SQL computer opponent, the journey continues through to the generation of mass data as training material for the AI.

First we realize a network game between two human players. Then we create a computer opponent in pure T-SQL that we can later play against itself. All functions are fully automated and generate thousands of games from the level of a 5-year-old to a master player at the push of a button.