SQL Server Tips and Troubleshooting

The following guide helps you to troubleshoot your SQL Server if its running very slow:
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes.


Reasons for Selecting LAMP (Linux, Apache, MySQL, Php)

Although CCD does most of its work using Microsoft products, many people come to us asking about LAMP. The standard reasons for selecting LAMP (Linux, Apache, MySQL, PHP) instead of combination of other software programs, servers and operating systems include:
All of those are open source resource. Security of linux can be much greater than that for windows. Apache can be a better server that IIS both in functionality and security. Mysql is the most popular open source database in the world. PHP is faster than asp or other scripting language.

If your firm is in Gaithersburg, Germantown, Rockville, or anywhere in the Maryland area, and you need some help with computer programming, please contact us!

Corbin Creative Databases, LLC

Access Database for an Association

We are an association in the District of Columbia. We use an Access Database to keep track of members and some of our publications. We have had several employees work on our database over the years, and it is not looking very good. Do you have experience in database management and think you could help us with our computer consulting needs?

Washington DC

I think I want an Access database

I see from your web site that you have experience with database management and Microsoft Access. I have a small store in DC, and we keep our information in Foxpro. However, I also have Microsoft Office 2007. Can I transfer my information from foxpro to Microsoft Access? Is this something you do? Thanks in advance,

Glover Park, District of Columbia