#DataWeekender CU5 / Virtual Event / 14th of May 2022

Posted by in SQL Server on Jan 27th, 2022 | 0 comments
#DataWeekender CU5 / Virtual Event / 14th of May 2022
VIRTUAL EVENT   #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 5th running on the 14th of May 2022. ​ Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL, Logic...
read more

SQL Server / Configure an Azure Load Balancer for a SQL Server Always On AG in Azure Virtual Machines / Possible Floating IP and Health Probes Connectivity and Networking issues

Posted by in SQL Monitoring, SQL Server, SQL Tips and Tricks on Jan 21st, 2022 | 1 comment
SQL Server / Configure an Azure Load Balancer for a SQL Server Always On AG in Azure Virtual Machines / Possible Floating IP and Health Probes Connectivity and Networking issues
I will take you through the steps on how to properly configure Azure Load Balancer with Azure SQL Server VMs (IaaS), Windows Failover Cluster (WFC),  Availability Group AG, and listener endpoint. The following link shows us what is the best Microsoft Practice, and how Microsoft suggests we should configure an Internal Load Balancer (ILB) for the Availability Group Listener. Create & configure the load balancer   How LB really works with Always On Availability Group on SQL Server on Azure VMs? There are two types of Load Balancers  –...
read more