Well, this is my first post in 2020 and it better be good and helpful to you out there. Happy new year!!!. I want to discuss data profiling using SSIS in this post. If you are not familiar with data profiling, its a process of looking at a data set to make general sense of […]
Restoring database in sql server is one of the important tasks database administrators have to do from time to time. Restoring a database just means to bring up a backed up copy of the database online. There are many scenarios that may require for the database to be restored from a backup such as when […]
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 […]