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 …
SQL variables can act on each other
There are many situations when you have a variable in a stored procedure and you want to add to it. Well, there …
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. …
SMO SQL Server Error Reading Stored Procedures Collection
The following error is appearing while running Visual Studio 2005 and developing an application with SMO capabilities. It appears when trying perform …
ORACLE initialization or shutdown in progress
Error “ORA-01033 ORACLE initialization or shutdown in progress” plagued me twice, not a third, unprepared! Since this was the second time this …
SQL Server 2005 Agent Schedule Not Updating
Ewwwh, this was a nasty little bug. Let me describe the title … I was having to update all our database data …