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: Hyper-V default switch and VMs on static IP addresses.
When running a small test sandbox using Hyper-V, the default switch is an ideal “quick and dirty” solution to provide hosted VM internet access (shared with the local workstation). Such configuration is extremely helpful for developers and testers, who can just run few VMs on their desktop or laptop. Of cause, a fully blown corporate… 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
Accidental Task: Test SCCM Certificate Expiration.
When System Center Configuration Manager (SCCM) Client connects to upstream management point, it should confirms it identity. In an environment with a single security realm (i.e. in the same Active Directory forest), such identification is implemented seamlessly without any additional configuration. However, if management points are not in the same trusted environment, then certificates come… Read More
Max's blog on SCOM Authoring and more 