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 […]
True or False and briefly explain why a) Cache is usually faster than main memory. True. Cache memory is directly connected to the central processing unit(CPU). Retrieval from cache takes far smaller amount of CPU circles than retrieving from main memory. There is wait or delay for access to memory, which could take several CPU […]
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 […]