If you have a production SQL Server that has low memory, where do you start when trying to find out the root cause? I.e. 4GB of ram but only a few hundred MB left available during peak times. Do you have a specific checklist of common issues/or perhaps even common misconfigurations you would look for to see if you can track down the root cause? These are typically for dedicated SQL Servers not running any other apps but a couple are dual purpose servers, i.e. also an application server.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.