Skip to content

Random IT Utensils

IT, operating systems, maths, and more.

  • .NET Internals Cookbook
  • Bio
  • Series and interesting posts
  • Talks, Papers, Workshops
    • Async Biggest C# Mistake
    • 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
    • Manual Memory Management
    • Ordering the Chaos
    • Understanding Windows and .NET

Tag: MSSQL

Windowing functions in recursive CTE

July 13, 2019March 23, 2019 ~ Leave a comment

Today we will see an interesting case of incompatibility between MS SQL Server 2017 and PostgreSQL 9.6 (and different versions as well). Let’s start with this code: We emulate a recursive CTE. We have two columns in source dataset, we want to sum first column for rows partitioned by second column. This gives a very … Continue reading Windowing functions in recursive CTE

Machine Learning Part 4 — Linear regression in T-SQL

November 10, 2018February 12, 2019 ~ 2 Comments

This is the fourth part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet This time we are going to implement linear regression as a function. This gives us a little more flexibility in terms of debugging the code … Continue reading Machine Learning Part 4 — Linear regression in T-SQL

Machine Learning Part 2 — Linear regression in SQL

October 27, 2018August 1, 2018 ~ 2 Comments

This is the second part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Image that you have only a data warehouse with SQL capabilities to train and evaluate your models. Last time we ran Python code to calculate … Continue reading Machine Learning Part 2 — Linear regression in SQL

Recent Posts

  • Types and Programming Languages Part 2 — Exception while handling exception
  • Types and Programming Languages Part 1 — Do not return in finally
  • .NET Inside Out Part 25 – Using is broken revisited
  • Async Wandering Part 11 — Wrapping fibers in context
  • Rx — Custom traffic shaper

Categories

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

Archive

  • January 2021 (3)
  • 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

  • Types and Programming Languages Part 2 — Exception while handling exception January 16, 2021
  • Types and Programming Languages Part 1 — Do not return in finally January 9, 2021
  • .NET Inside Out Part 25 – Using is broken revisited January 2, 2021