Jacob Sebastian is a Microsoft MVP (SQL Server) from Ahmedabad, India, who has been working with SQL Server for almost 15 years. He works as CTO with Excellence Infonet, Ahmedabad, which focuses on building highly scalable, mission critical applications for the healthcare industry. He has presented at various SQL Server conferences worldwide, and wrote his first book in 2009, The Art of XSD – SQL Server XML Schema Collections. He also wrote the XML chapter for the book, SQL Server 2008 Bible.
Sven Aelterman is a lecturer in Information Systems at Troy University in Troy, Alabama. He teaches undergraduate courses in data warehousing, network infrastructure and security. He is also the technology specialist for Troy University's Sorrell College of Business, and performs a variety of technology roles with a global scope. He continues consulting work through Adduxis, where he assists customers with software development projects using the Microsoft .NET Framework and related technologies. Sven focuses on application design and architecture and secure coding practices.
FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, adminstration and troubleshooting of it.… Read more
Free eBook download Authors: Jacob Sebastian and Sven AeltermanPublication Date: October 2012 Storing large object data in the database offers a number of benefits, but introduces performance challenges. Conversely, storing large object data in the file system has overriding performance advantages, but fails to offer some of the basic data integrity, security and manageability features … Read more