How to Auto Delete Sent Meeting Cancellations in Your Outlook

After cancelling an Outlook meeting, you may hope to auto delete the sent meeting cancellations from "Sent Items" folder. Now, in this article, we will teach you how to realize it with Outlook VBA. Every time when you cancel an Outlook meeting which is organized by you, you'll be requested to send a meeting cancellation to all its attendees. After sending the cancellation, the meeting will be auto deleted from calendar. Yet, the cancellation will be still in the "Sent Items" folder. More...

Read more »

How to Copy the Schemas & Statistics of Multiple Databases without Data via TSQL

With the service pack 2 of SQL Server 2014, you can create a copy of a user database without the actual data. i.e., you would be creating just the schema and statistics of your source database. In this article, we will learn how to quickly create clone of multiple user databases A copy needed for investigation: To find the root cause of a performance problem, you might need a copy of your existing database. In such cases, you can use the following query to create copies of multiple SQL Server...

Read more »

A Comparative Analysis of Using MS Access for Data Analysis over MS Excel

This article provides a comparative analysis of Using MS Access for Data Analysis over MS Excel. MS Access and Excel are often compared because of their similar pronunciation and usage. Both these Microsoft applications are used majorly for storing particular type of data; however, Access is a database management software, whereas Excel is a spreadsheet based software which offers extended data analysis tools to the users.  Access is obviously better for managing and storing tons of...

Read more »