sqlserver

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

Constrained vCPU capable Azure VMs

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.

Read More

My presentation from the MCT virtual event on how to profile your SQL Server

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.

Read More