Microsoft is recalling CU7 for SQL 2019 because of a known reliability issue with the database snapshot feature.
If you haven’t installed it yet, it is advised not to install it, even if you don’t make use of this feature, as DBCC CHECKDB also uses it. Instead wait for the CU 8 which is scheduled for the week of October-12.
You can read more here.
Reading Time: 2 minutes Well, we always say that is not good to use SQL Server logins and is best to enable only Windows Authentication mode on the SQL Server instance as a best practice. It seems that although it *is* a good practice if you are running a native Windows environment, it also makes your life easier if you have an Availability Group deployment in your hands, as you will see.
Reading Time: 2 minutes There are many ways to deploy resources on Azure, talking about the Azure Resource Manager deployment model and not the Classic one. I’ve been doing many deployments in the last couple of months and the thing is… you will do it more than once and that is certain. So, scripting comes handy.
Reading Time: 2 minutes Tip: Azure Update Management does not seem to work. All seems to be in place, yet it does not work as expected. Let’s see what we did to go past this.
Reading Time: 3 minutes Today morning I had to deploy some new rules on an existing production Azure Load Balancer. So, I spun up the VS Code and my JSON ARM Template library to make the appropriate changes. Little did I know that this would soon fail. I had to turn to PowerShell to get the job done efficiently.
