freecomputerbooks.pickatutorial.com Computer Tutorials and Books
Tutorials: C / C++ | C#.NET | PHP MySQL | Java | Java Script | jQuery | HTML | xHTML | HTML5 | VB Script | CSS

Books: C/C++ | C# | Android | Mathematics | Database | Cloud | Graphics | Networking | Oracle | Hardware | AI
Categories Download eBook: The Art of SQL Server FILESTREAM Bookmark and Share

Book Catagory:SQL Server
Title The Art of SQL Server FILESTREAM
Author(s) Jacob Sebastian and Sven Aelterman
Publisher: Red gate books (August 31, 2012)
Paperback 512 psges
Language: English
ISBN-10: 1906434891
ISBN-13: 978-1906434892
Book Description

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 that are required for business data, and which SQL Server provides. Up to now, most people have adopted file system storage by necessity, and often struggled to overcome the associated shortcomings. This is exactly where SQL Server's new FILESTREAM feature fits in. Introduced in SQL Server 2008, it 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 guides you step-by-step through every phase of FILESTREAM implementation, from enabling the feature, to creating FILESTREAM tables, to manipulating FILESTREAM data through the streaming APIs. We also cover, in detail, administration and troubleshooting of FILESTREAM databases and tables. No feature is used in isolation, so we devote several chapters to explaining how this new feature can be integrated into ASP.NET and Silverlight web applications, and into applications using Entity Framework. We also take a look at how well FILESTREAM plays with other SQL Server features such as SSIS and SSRS, pointing out various issues and pain-points along the way. We also devote a full chapter to the FileTable feature, a long-awaited new addition to FILESTREAM, with SQL Server 2012, which allows Windows applications to access FILESTREAM data exactly as is it were stored directly on the file system. We hope this book will get you started, quickly, with FILESTREAM, and then help you master all essential aspects of programming and administering FILESTREAM-enabled databases.
Download eBook
|
|
|
The Art of SQL Server FILESTREAM

More SQL Server eBooks:
BI Solutions Using SSAS Tabular Model Succinctly
Introducing Microsoft SQL Server 2014: Technical Overview
SQL Server Analysis Services Succinctly
Fundamentals of SQL Server 2012 Replication
SQL Server Concurrency: Locking, Blocking and Row Versioning
SQL Server Execution Plans, Second Edition
Performance Tuning with SQL Server Dynamic Management Views
SQL Server Backup and Restore
Inside the SQL Server Query Optimizer
Introducing Microsoft SQL Server 2012
Introducing Microsoft SQL Server 2008 R2
SQL Server Statistics
The Red Gate Guide to SQL Server Team-based Development
Defensive Database Programming with SQL Server
Brad's Sure Guide to SQL Server Maintenance Plans






Home - Advertise - Contact - Disclaimer - About Us
© Since 2006 pickatutorial.com -- All Rights Reserved.