SQL

Unable to install SQL Server 2019 – SQL Install Error: The MOF compiler could not connect with the WMI server

The other day I was doing K2 5.5 installation on top of Windows Server 2019 and somehow that install beat all the records in terms of weird issues I run into, and even after re-provisioning server and starting from scratch I had to do resolve quite a few of them. One of those errors (not Unable to install SQL Server 2019 – SQL Install Error: The MOF compiler could not connect with the WMI server

PowerShell Script – Detect installed SQL Server Version and switch to appropriate setup directory

Some time ago I wrote a blog post where I explained how to change SQL Server instance collation for installed SQL server instance (see “Changing SQL collation for deployed instance without reinstall (almost)“). That post contained some scripting bits to detect installed SQL Server version and navigate to appropriate setup directory to facilitate collation change PowerShell Script – Detect installed SQL Server Version and switch to appropriate setup directory

Simplistic SQL cycle example

Just a little example (one of the simplest) demonstrating how to do a cycle in SQL to populate N rows in some table with specified value: Just leaving it there 🙂

Microsoft Azure 70-473 Design and Implement Cloud Data Platform Solutions – Design and Implement Security

Earlier I tried to compile list of Microsoft documentation and other resources relevant for 70-473 exam preparation but I quickly realized that exam scope makes this list too huge and unwieldy. I now decided that I would rather split this into smaller resources lists following specific exam sections. Below you can see the list of Microsoft Azure 70-473 Design and Implement Cloud Data Platform Solutions – Design and Implement Security