Skip to content

Random IT Utensils

IT, operating systems, maths, and more.

  • Applied Integer Linear Programming
  • .NET Internals Cookbook
  • Bio
  • Series and interesting posts
  • Talks, Papers, Workshops
    • Async Biggest C# Mistake
    • Async With Coroutines and Fibers in C#
    • Basics Designs and How We Got Them Wrong
    • Bridging the World Together
    • Connect remotely like a pro!
    • Debugging Memory Leaks in .NET
    • DLL Injection in Windows
    • Exploring memory in .NET
    • From Bulb to High Level Language
    • Generics everywhere
    • Hacking C# From the Inside
    • Integer Linear Programming
    • Internals of Async
    • Internals of Exceptions
    • Locks are tricky
    • Manual Memory Management
    • MOV, async, DSL – are they connected?
    • Ordering the Chaos
    • Public Speaking
    • Seeing Behind the Scenes with Low-Level Tooling for Hardcore Debugging
    • Testing at Scale
    • Understanding async machinery down to a single detail
    • Understanding Windows and .NET

Tag: SQL

SQLxD Part 23 — Query parser tests

October 21, 2017June 3, 2017 ~ afish ~ Leave a comment

This is the twenty third part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Here go the tests for query parser: If you followed this series then this whole code should be very easy. Summary We now have engine for … Continue reading SQLxD Part 23 — Query parser tests

SQLxD Part 22 — Query parser

October 14, 2017June 3, 2017 ~ afish ~ Leave a comment

This is the twenty second part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation For parsing queries we use IronPython. Let’s begin with C# code for executing PLY engine: And now goes the parser: This is simply an implementation of … Continue reading SQLxD Part 22 — Query parser

SQLxD Part 21 — SELECT

October 7, 2017June 3, 2017 ~ afish ~ 1 Comment

This is the twenty first part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We have all things to transform rows and columns. Now it is time to implement SELECT clause. We have two ways: either we use aggregates or … Continue reading SQLxD Part 21 — SELECT

SQLxD Part 20 — Transformers

September 30, 2017June 3, 2017 ~ afish ~ 1 Comment

This is the twentieth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We can extract nodes, transform them into rows, filter, join, group, order, and transform them. It is high time to glue all the things together in order … Continue reading SQLxD Part 20 — Transformers

SQLxD Part 19 — Expressions tests

September 23, 2017June 3, 2017 ~ afish ~ 1 Comment

This is the nineteenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Last time we implemented expressions, it is high time to test them: Having expressions working we can use them in transformers. This is the topic of the … Continue reading SQLxD Part 19 — Expressions tests

Posts navigation

Older posts
Newer posts

Recent Posts

  • Async Wandering Part 15 — How async in C# tricks you and how to order async continuations
  • RPA Part 1 — Sharing Word/Excel between objects in Blue Prism
  • Pitless Pit Part 1 — Furmanek Test for consciousness
  • Bit Twiddling Part 6 — Stop RDP from detaching GUI when the client disconnects
  • Bit Twiddling Part 5 — Fixing audio latency in mstsc.exe (RDP)

Categories

  • Administration
  • Coding
  • Computer Science
  • Databases
  • Debugging
  • Math
  • Philosophy

Archive

  • November 2024 (1)
  • September 2024 (2)
  • June 2024 (1)
  • May 2024 (4)
  • April 2024 (1)
  • March 2024 (3)
  • February 2024 (2)
  • December 2023 (2)
  • February 2023 (4)
  • January 2023 (4)
  • December 2022 (5)
  • November 2022 (4)
  • October 2022 (5)
  • September 2022 (4)
  • August 2022 (4)
  • July 2022 (5)
  • June 2022 (4)
  • May 2022 (4)
  • April 2022 (5)
  • March 2022 (4)
  • February 2022 (4)
  • January 2022 (5)
  • December 2021 (4)
  • November 2021 (4)
  • October 2021 (5)
  • September 2021 (4)
  • August 2021 (4)
  • July 2021 (5)
  • June 2021 (4)
  • May 2021 (5)
  • April 2021 (4)
  • March 2021 (4)
  • February 2021 (4)
  • January 2021 (5)
  • December 2020 (4)
  • November 2020 (4)
  • October 2020 (5)
  • September 2020 (4)
  • August 2020 (5)
  • July 2020 (4)
  • June 2020 (4)
  • May 2020 (5)
  • April 2020 (4)
  • March 2020 (4)
  • February 2020 (5)
  • January 2020 (4)
  • December 2019 (4)
  • November 2019 (5)
  • October 2019 (4)
  • September 2019 (4)
  • August 2019 (5)
  • July 2019 (4)
  • June 2019 (5)
  • May 2019 (4)
  • April 2019 (4)
  • March 2019 (5)
  • February 2019 (5)
  • January 2019 (4)
  • December 2018 (5)
  • November 2018 (4)
  • October 2018 (4)
  • September 2018 (5)
  • August 2018 (4)
  • July 2018 (4)
  • June 2018 (5)
  • May 2018 (4)
  • April 2018 (4)
  • March 2018 (5)
  • February 2018 (4)
  • January 2018 (4)
  • December 2017 (5)
  • November 2017 (4)
  • October 2017 (4)
  • September 2017 (5)
  • August 2017 (4)
  • July 2017 (5)
  • June 2017 (4)
  • May 2017 (4)
  • April 2017 (5)
  • March 2017 (4)
  • February 2017 (4)
  • January 2017 (4)
  • December 2016 (5)
  • November 2016 (4)
  • October 2016 (5)
  • September 2016 (4)
  • August 2016 (4)
  • July 2016 (5)
  • June 2016 (4)
  • May 2016 (4)
  • April 2016 (5)
  • March 2016 (4)
  • February 2016 (4)
  • January 2016 (5)
  • December 2015 (4)
  • November 2015 (4)
  • October 2015 (5)
  • September 2015 (4)
  • August 2015 (3)

RSS Posts