Currently browsing tag

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 …

SQL Server Best Practices

There is nothing better than knowing exactly what needs to be done to get the best results from your technology. Especially from …

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 …

Oracle buys Sun Microsystems

It was revealed today that Oracle will buy Sun Microsystems. The deal is expected to close in the summer. It has come …

SQL Recompiles

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