In this article we look at the key functions of transaction logs in SQL Server
Transaction Log, as the name suggests, keeps a log of all the transactions that are taking place; along with the database modifications it’s making each day. It is one of the most crucial element in your database, in case of any system failure it brings back database to a consistent condition. You should never opt for deleting or moving your transactions log unless you are not completely sure of its consequences....
Read more »
Sometimes you don’t want to save the changes in certain worksheets. Now we have a quick method to undo changes in specific worksheets.
Suppose you have made several changes in different worksheets. In the image below, you can see that there are many worksheets in this file. And you change the contents in all the sheets by the order.
However, you find that the changes sheet “DataNumen Sales Volume” and sheet DataNumen Access Repair” is unnecessary. If you use the “Undo” feature in Excel,...
Read more »
In this article, we decide to show you the way to write protect a part or the entire of your Word document.
There are times when you finish creating a Word document you want no one else but yourself to have the access to modify it. Naturally, some of you may come to the idea of encrypting your document with password. Certainly, it can protect your privacy well. However, there are also occasions when you have to allow others to view you document. In such cases, you need to make use of...
Read more »
