Skip to content

Amine Haloui

26 posts since April 2024

SQL Server: Basic AG – One listener, multiple databases

Introduction When it is not possible to have SQL Server Enterprise and there is a need to set up an AlwaysOn cluster, it is possible to use SQL Server Standard and implement basic availability groups. However, the Standard edition of SQL Server comes with certain limitations when it comes to availability groups. Here are some of these limitations However some… 

Build SQL Server audit reports with Powershell

Introduction When you are tasked with conducting an audit at a client’s site or on the environment you manage, you might find it necessary to automate the audit process in order to save time. However, it can be challenging to extract information from either the PowerShell console or a text file. Here, the idea would be to propose a solution…