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.
Jacob Sebastian is a SQL Server Consultant based in Ahmedabad, India. He's a Microsoft SQL Server MVP, a Moderator at the MSDN and Technet Forums, and volunteers with the Professional Association for SQL Server as Regional Chapter Coordinator for Asia.
He also runs a SQL Server User Group in his home town and is a frequent columnist at SQLServerCentral.com.
Jacob started his database career in the early nineties with Dbase and then moved to Clipper, Foxpro and finally settled on SQL Server. He's now been working with SQL Server for over 11 years and is a regular speaker at local User Groups and SQL Server events. He is also a well-known SQL Server trainer, and teaches at various SQL Server classes across the country.
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