Challenges and Error's encountered while gathering the sample data

Error Log 

SQL errors encountered 

Challenges 

• The data I need sits on a server that is on a vessel out at sea x using line of site and the vessel is about +-9000 km from me . The connection is lagging causing the response time to be slow.

• To over come this I started working to refine the sql query with picking a smaller range for the data 

• With a 1 hour  and the top 1000 records filter. Once I was satisfied with the query I remove the records filter and started adjusting the time filter. 

• For now I am going to try and work on a day worth of data and see if I can find new relationships and or anomaly. 
• The days worth of data posed another challenge I couldn't copy it of the server into the excel sheet as I did with the smaller data set , so I exported the file as a csv file and push the file of the server.

Conversion failed when converting date and/or time from character string.

solution : I removed the 00 to match the data format 

The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.

solution : I got this error while trying to get data for at least 1 day. to solve the issue, I removed the 24:00 cut of to the next days 00:00 value