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 »
CDs and DVDs are widely used for storing software, computer files, video programs or any other digital data. However, this type of storage media can get corrupt easily, thereby leading to data loss. Now, this article will share 8 tricks to avoid CD/DVD data loss.
Although nowadays, CDs and DVDs have been less significant than external hard drives and flash drives, they are still playing great roles in multiple aspects, such as storing installation files, specific movies or music and so on....
Read more »
