Posts related to SQL Server (on-prem and cloud)
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 This offering of constrained vCPU capable VMs has been around for quite a while in Azure. Use it for your SQL Server or Oracle servers that are not CPU intensive but need the rest of the resources RAM, IO, network to be of a larger VM but with a lower price because of fewer cores to license.
Reading Time: < 1 minute Today I had the opportunity to share my experience with the community in a virtual event organized from our local MCT Group, namely the Greek MCTs. Check the deck and the recording from the session.
Reading Time: < 1 minute The topic of my session was Live Query Statistics and Query Store. Below the presentation deck and some photos from the event.
Reading Time: 3 minutes Collation is the mechanism that dictates the way things happen behind the JOIN, ORDER BY and comparison of characters in our database.
Reading Time: < 1 minute I just submitted my session for this year’s Azure event “Global Azure 2020” happening in Athens, Greece. I’m a bit stressed since this is my session after many years but also excited as I will be speaking…