How to Use MS Access in a Strategic Manner in a Large Organization

In this article we look at using the Ms Access database in a large organization, often in conjunction with other database solutions. Access users often believe that it is an application ideal for small to midlevel organizations; for large organizations, high end applications like SQL Server or other enterprise grade databases should only be used. This statement is only partly correct. Access can also be used for large organizations, provided it is used in a strategic manner. You cannot...

Read more »

How to Read and Analyze Deadlock Logs in SQL Server

It is a well-known fact that deadlocks cannot be avoided. It is necessary that we learn to minimize deadlocks from our SQL server environment. Trace flags enable you to capture deadlock graph in the SQL Server Error log. In this article, we will learn how to get the deadlock history from that log. Deadlock Deadlock occurs when there is more than one session competing for a resource. When a deadlock occurs, SQL Server immediately jumps into action by killing one of the session and that session...

Read more »

How to Batch Change the Cases of All Contacts’ Full Names in Your Outlook

Perhaps you’ve discovered that your contacts’ full names are in various cases. If you would like to batch change the cases of contacts’ full names, you can use the method introduced in this article. Sometimes, you may find that the formats of many contacts’ full names are multifarious, such as non-uniform cases of full names. For instance, you must prefer “John Smith” instead of “john SMITH”. Therefore, here we will teach you to batch change the cases of all contact’s full...

Read more »