How to Prevent SQL Server Jobs from Getting Executed during Maintenance

In a big SQL environment, it is very common to see servers rebooted during maintenance. Though we might inform the users about the server maintenance, many DBAs miss taking care of their SQL Server agent jobs. In this article, we will learn how to identify SQL Server Agent jobs that are scheduled to run at a specific time. We can then disable jobs whose schedule collide with the maintenance window. No notification: You might have set up SQL Server jobs to send out failure notifications or...

Read more »

How to Batch Delete Columns in Multiple Excel Workbooks

It is very common to see people saving confidential data in Excel workbooks. When these workbooks have to be shared with other colleagues or friends, manual deletion is the only option available. However, with this article, you will learn how to quickly delete confidential columns or unwanted columns from multiple workbooks. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the...

Read more »

2 Quick Ways to Auto Back up Your Word Document Periodically

In this article, we would like to share with you 2 quick ways to auto back up your Word document periodically as to secure them. It’s well-known that Word has an auto save function to save your document. Yet, it saves only new changes made to the document and there is and will always be one file. This is not so ideal since out of all kinds of reasons, such as power outages, your file has a high possibility of getting corrupt. Then what if you have a backup copy? That will definitely...

Read more »