Hello CCD,
I’m glad to see that there are local IT companies in Maryland with SQL Server expertise. Â My colleagues and I were wondering how to get rid of duplicate rows in a SQL Server table. Â Do you know about this?
Tom in Maryland
Database Management
How can I extract a MySQL query result in CSV format?
Hello Will
I am running a MySQL query from the linux command line and I need to output the results in CSV format. I need an efficient way to extract that information with the from MySQL that is properly escapes any quotes that exist in the data.
Thank you
Jim from Washington DC
I need to know when a MySQL table was last updated. How do I get that information?
Hi Will
I would like to add something like “last updated the xx/xx/200x” on my page.
Can you tell me what the best way to do that is? Are there any functions that will retrieve the last updated date?
Kim from Rockville
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.
CCD
I need to convert String to Int?
I have a text box in vb.net and I need the result to be converted into ‘int’ to store it in a Sql Server database. How can I do this?
Patrick from Maryland
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!
Upsizing an Access Database to SQL Server Database
Hi Corbin Creative Databases,
I want to upsize an access database to sql server database, but I don’t know how to do it. Can you tell me how to upsize an access database to sql server?
Adam BC, LLC
Maryland
Database Management with MySQL and PHP
Hello CCD:
Our organization is looking for some help with MySQL and PHP. We have a database of clients and potential clients- We would like to publish some of the information in this database on the web so that our team members across the country can easily access it. Is this the sort of computer consulting that you do? I guess you would call it database management.
JL in the District of Columbia
P.S. Do you also do web development work in Microsoft SQL Server? We also may have a need for that.
Web developer or database developer in Washington DC?
Hi,
I am in charge of a medium-sized non-profit organization in Washington DC. I am interested in augmenting one of our customized databases and then putting its contents up on the internet for our members and the public to access. My question is: Should I be looking for a web developer, or a database developer for this project? I see from your web-site that you have significant experience in both web development and database management. Thanks in advance,
Mike W.
Washington DC