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 connecting to an AWS EC2 SQL Server box.
Tag: Database
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 a new prefix for Joomla database tables. This
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 is definately a slick way to build on
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 simplicity of using them, it’s about the impacts
SQL Recompiles
Here are some articles that describes the need to reference the owner (schema) of SQL Server stored procedure when called by applications. Also, making sure that the calls are sensitive
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 a foreach( on ActiveDB.StoredProcedures). Could not load file
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 happened to me so I decided I should
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 and schema to support the GMT/UTC baseline and
.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 would provide instructions I put together while developing
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 This error presented itself because I wasn’t closing