BE SHARING

Ali Asghari

Lost access to SQL Server. Now what ?

15.03.2023 by Ali Asghari

In this blog we will explain what to do to regain the access to your SQL Server instance. Here is our scenario : – You have by accident removed all logins in SQL Server instance – Your sa account by(…)

SQL Server

Prepare Failover Cluster for AG configuration

01.12.2022 by Ali Asghari

In this blog I will show you some important powershell commands to prepare a Failover Cluster for AG configuration. Please keep in mind, this is a test environment and I will not talk about firewall rules. Our objective is to(…)

Oracle

ODA – oda-admin’s reset password no end loop

24.08.2022 by Ali Asghari

If you are new like me in the ODA world, there is a chance that you don’t know the workaround for the ODA Administration console, asking you to reset the oda-admin’s pasword each time ! The solution is really simple.

Database Administration & Monitoring

Create and configure an Oracle linked server in SQL Server Instance

15.07.2020 by Ali Asghari

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit(…)

Database Administration & Monitoring

Install & configure a Nagios Server

19.05.2020 by Ali Asghari

What is Nagios ? “Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before they affect critical business processes.” https://www.nagios.org/ In simple words, you can monitor your servers (linux, MSSSQL, etc …) and(…)