blog.fossmo.net

The last three years I have been working for a customer in Trondheim, Norway, building a application based on Windows Presentation Foundation (yeah, I know it's not the hottest stuff), SQL Server, Entity Framework 4.1 (Code first) and a cool scalable architecture. At the user group meeting I will present how we buildt the architecture and how we solved the problems around scalability. I'm looking forward to presenting this stuff for the user group and hope to see you there!!

Sign up for the meeting at http://www.nnug.no/Avdelinger/Trondheim/Moter/NNUG-Trondheim---29-september-2011/ 

Tags: cqrs, ddd

At work we had a discussion about storing files in the database (SQL Server 2005) is a good thing or not. I searched the Internet, and found this paper. It says that storing files in a database (blob) is better if the file size is less than 256 kb. If the file size is larger than 1 Mb, it's recommended to store the files in the file system. Nice to know!

SQL Server 2008 supports the "datatype" filestream. 

I found this at Microsoft's website:

"The new SQL Server 2008 FILESTREAM data type allows large binary data like documents and images to be stored directly in an NTFS file system while letting the data document  remain an integral part of the database and maintaining transactional consistency. The new FILESTREAM data type enables the scale-out of large binary data, traditionally managed by the database, to be stored outside of the database on more cost-effective storage without comprising features for accessing such data. IT administrators can take advantage of all the rich database services like security, backup etc on top of these documents."

I suppose this will give us the best from both worlds?

Tags: