How to Auto Track Deleted Databases in SQL Server

Using SQL Server's Schema Changes History we can identify the name of databases that were dropped from the SQL Server. In a big SQL Server environment, connecting to each Schema Changes History of every SQL Server instance is a very difficult task. In this article, we will learn how to automatically track deleted databases. Multi options There are several options with which you can track a database getting deleted from your SQL Server instance. Option1: Log data from the system table...

Read more »

How to Number Records in Your Access Forms and Reports to Make Them More Organized

Numbering is one of the easiest ways of organizing data and in this article we apply the concept to on Access Forms and Reports Numbering or ranking data plays an important role in keeping records sorted and organized. And people often prefer arranging their Access reports and forms with numbering entries to gain an easy access to a particular subject. Numbering entries also come in handy if the user is looking for a particular range data. These steps can be used by casual as well as...

Read more »

How to Auto Minimize Outlook Window after Inactive for a Specific Period

Some users wish that Outlook window can be auto minimized as Outlook has been inactive for a specific period of time, such as 5 minutes. With no doubt, Outlook has no such a native feature. But you still can achieve it with the VBA code shown in this article. If your Outlook has been idle for a certain time interval, namely you not making any operations in this period, you may hope that Outlook can be auto minimized to keep other applications running smoothly. Many users have this...

Read more »