SQL Server

Posts related to SQL Server (on-prem and cloud)

Microsoft recalls CU 7 for SQL Server 2019

Reading Time: < 1 minute

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.

Creating a SQL Login with SQL Server Availability Groups

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.

Read More