When you find data is lost, actually, most of time, the data is not erased completely. It will still be over there until new data is written over it. Thus, in this course, you should follow the 5 vital rules listed in this article to prevent overwriting lost data.
As we all know, data loss can occur from multiple factors, such as mistaken data deletion, wrong disk formatting, lost partition, file corruption like PST corruption, physical device damage and so on. As a matter of fact,...
Read more »
Learn how to backup and restore database objects for a SQL Server databases, using DAC Package.
When operating on a SQL Server database, there can be situations where you wish to copy a database in a given server to another server, with schema information only, and not the data. This can be done in multiple ways, a few of the basic ones include:
Separate the script from the source database, and run it for a fresh, empty database, this can also be the target to copy the objects in source...
Read more »
Every time when you update a specific Excel worksheet, if you always need to send an email notification to specific recipients, you can utilize the method introduced in this article.
Some users ask for a solution to let MS Excel automatically send an Outlook email notification to specific persons every time when they update a specific worksheet, in that they often forget to send such an email. Now, in the followings, we’ll guide how to achieve this function with VBA code.
Auto Send an...
Read more »
