Business Intelligence, SQL Server Power BI – Scheduled refresh stuck 23.08.2024 by Amine Haloui Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included.
Database Administration & Monitoring, Database management, Development & Performance, SQL Server SQL Server: Basic AG – One listener, multiple databases 19.08.2024 by Amine Haloui 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 Build SQL Server audit reports with Powershell 17.04.2024 by Amine Haloui 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(…)