Paul Randal has written a very detailed technical article about FILESTREAM Storage in SQL Server 2008.
This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM with other features, and implementation details such as partitioning and performance.
This white paper is targeted at architects, IT Pros, and DBAs tasked with evaluating or implementing FILESTREAM. It assumes the reader is familiar with Windows and SQL Server and has at least a rudimentary knowledge of database concepts such as transactions.
Here is the table of contents:
Introduction
Choices for BLOB Storage
Overview of FILESTREAM
–Dual Programming Model Access to BLOB Data
–When to Use FILESTREAM
Configuring Windows for FILES...
Content suppressed by ://URLFAN, for full article visit source
Why singletons are badFrom: blogs.lessthandot.com
Post Date: 2008-09-19 23:59:32
I didn’t know that google actually had a policy about it, but they explain very well why you should avoid them . They even have an application that searches for singletons in code.
Here is a little extract of that article.
The use of singletons is actually a fairly controversial subject in the Java community; what was once an often-used design pattern is now being looked at as a less than desirable coding practice. The problem with singletons is that they introduce global state int...
more Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and ImplementationFrom: blogs.lessthandot.com
Post Date: 2008-09-18 17:23:24
Pro SQL Server 2008 Relational Database Design and Implementation is one of those books that should be in the hands of every SQL Server developer. There are tons of SQL Server programming books around but none of them covers the fundamentals of a good SQL Server database, the design. If your design is ‘broken’ then it is a lot harder to fix it down the road, design is probably the number one reason people have all kinds of problems with their databases.
I have both the 2000 an...
more Nice .NET Design Patterns ArticlesFrom: blogs.lessthandot.com
Post Date: 2008-09-17 08:40:00
The DotNetSlackers site has a nice series of articles about design patterns. The articles were written by Granville Barnett and are a very good read. Here is what is in the first four articles.
Design Patterns – Part 1
Learn how to design more robust and maintainable code by incorporating design patterns into your software projects.
1 Introduction
2 The strategy pattern
3 Implementing our design
4 Summary
Design Patterns – Part 2
In this part of the design patterns s...
more Behaviour-driven development and User storiesFrom: blogs.lessthandot.com
Post Date: 2008-09-17 06:10:31
On Dan North ’s blog you will find a nice writeup on this subject the post is called What’s in a Story? and explains it a bit better.
Compare to use cases where you describe the interaction between the stakeholder and the other stakeholder (mainly the system) this describes the desired behaviour of the system.
This is an example of such a use case. Found here.
Use Case Example
Example for the Club Information System (CIS)
Actor: A member of the publi...
more 
Websites mentioned in article
Buzz Words mentioned in article:
How popular is blogs.lessthandot.com?
