What is Scalar UDF Inlining? You can read about Scalar UDF Inlining in great details here: https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver15, but in general, it’s exactly what how it sounds. UDF is an abbreviation for User Defined Function, and scalar means it returns a single value of simple type. Like int, varchar, float, etc. To improve query performance, SQL… Read More
Accidental Task: Recover SQL Server Product Key from Existing Installation
OK, this task is not accidental in general. The task, probably, appeared withe the very first deployment of SQL Server, or a bit later, when its CD box was lost. But it was new for me, so I started googling. The very first solution seem to be in Jakob Bindslet’s post on 11th of November… Read More
Max's blog on SCOM Authoring and more 