SQL Server / PowerShell / Check SQL Server version and a current patch level for all servers you specify using PowerShell

Posted by in Azure, Powershell, SQL Server on Apr 24th, 2022 | 0 comments
SQL Server / PowerShell / Check SQL Server version and a current patch level for all servers you specify using PowerShell
Script Download: SQLServerUpdateStatus Download Summary: Check SQL Server Version and the current patch level for all servers you specified. As well check the latest patches/updates available for the installed SQL Server version and send an email with results. Description: SQL Server Instance Update Status PowerShell script which can be invoked remotely from another PC through the command line, with PowerShell or executed remotely through task scheduler adding servers names. The script is checking server registry values for (Version,...
read more

SQL Server / Remove SCHEMABINDING from the multiple VIEWs without DROP and CREATE statements

Posted by in SQL Server, SQL Tips and Tricks on Mar 12th, 2022 | 0 comments
SQL Server / Remove SCHEMABINDING from the multiple VIEWs without DROP and CREATE statements
What is the SCHEMABINDING within VIEW?It simple binds the view to the schema of the underlying objects. Tables behind the View cannot be altered in any way which could affect view definition. You can find more at this MS article: ALTER VIEW (Transact-SQL) There is a easy way to remove SCHEMABINDING, you just need ALTER VIEW statement. But what if you have 100 views that needs to be altered? Well there are no SWITCH OFF button for SCHEMABINDING in SQL Server. I had same situation and I wrote this simple script which will generate ALTER VIEW...
read more

#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 | 0 comments
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