I was completely unaware of the SQL Server “ghost records” until recently I’ve started using a table in SQL Server database to temporarily store and then delete generated PDF documents as part of a nightly job. Because of a large amount of data being processed (inserted and then deleted) few days later our DBA realized that the database data files started growing in a rhythm [... read more]
Only few years ago I was not such a big fan of Object-Relational mapping tools (ORM), but now I have to admit that when starting a new project I’m always thinking whether it makes sense to use it or not. Compared to “traditional” coding techniques, Object-Relational mapping often reduces the amount of code that needs to be written, but I would add as well that [... read more]
In this post I would like to analyze the two ways of how applications can exchange data (especially when it comes to the database access). I am mainly a big advocate of SOA (Service Oriented Architecture), but on the other side, you have developers who are more oriented toward direct database connections and sharing the data in this way. I would like to share with [... read more]
By PDGACO payday loans