Backing up databases is one of the tasks perform by database administrators in many organizations. The aim is to make a copy of the database with data either to restore to another server, keep it to restore in case of issues on the database, migrating application, for use on a desktop or for any other […]
This is a question one of my friends asked me today at work and l decided to write it out and share with anyone who might need it. How do you ping a database on a server to see if its in a healthy state. Assuming your writing an application and you want to test […]
Have you been in a situation where you wanted to make a backup of a database and restore to another server and realized you couldn’t backup and restore to the new location because of the size of the database? How about even after dropping or truncating huge tables and still the database size is not […]
So l just completed my data science specialization with John Hopkins University via coursera today. I am actually excited completing this study because l’m new to data science and l need an introduction to know where to go next in my career as a sr. data developer. For the past 10 months, l have been […]