Currently browsing category

Database

EC2 and SQL Server Micro

As we are learning the new EC2 Amazon Cloud Services, I am compelled to post a “how to” when setting up and …

Change Joomla Table Prefix

We are interested in your security and performance! To improve performance and enhance security of the Joomla platform be sure to provide …

MS SQL Cursors are Evil

Alright, they’re necessary at times, but for the most part you need to really avoid them. It’s not about the coding and …

SQL Recompiles

Here are some articles that describes the need to reference the owner (schema) of SQL Server stored procedure when called by applications. …

.NET and MySQL

Searching for a document that helps to connect a .NET web application with MySQL is hard to find. So, I thought I …

Oracle Maximum Open Cursors Exceeded

In writing my application that checks certain settings and values every few seconds received the following error today. ORA-01000: maximum open cursors …