Ehsan Pourtorab

Intentionally Saturate MySQL Memory Until Server Crashes

I was testing one of my automations and needed MySQL to intentionally consume a lot of memory, so it will be killed by OOM Killer and I found this great answer in StackOverflow:

Migrate from on-premise MySQL Server to Amazon Aurora in near zero downtime

Introduction A lot of companies are thinking about migrating their infrastructure to Cloud and one of the most important show stoppers is downtime, especially when it comes to database migration. In this post, I am going to show you how we migrated our on-premise MySQL Server to Amazon Aurora for MySQL in near-zero downtime. AContinue reading “Migrate from on-premise MySQL Server to Amazon Aurora in near zero downtime”

Linux df command shows the disk is full but it is not

Problem Sometimes you might run the df command and it shows the disk is full, but when you list the directory using the ls command or when you run the du command, you realize that the disk is not really full. In this case there might be a running process that has opened a fileContinue reading “Linux df command shows the disk is full but it is not”

How to find SQL Server service account with T-SQL

Problem You can simply use SQL Server Configuration Manager to realize what is the SQL Server Service Account, but what if for any reason you are not able to use it. how can you find the service account using T-SQL? Solution Simple and easy:

How to find a SQL Server job with a binary job id

Problem You may run the sp_WhoIsActive to check the currently active sessions in your SQL Server and find an active session from one of your jobs. if you look at the program_name column, you’ll see something like this: So, how do you find the corresponding job? Solution You can find all of the SQL ServerContinue reading “How to find a SQL Server job with a binary job id”