• Title The Art of SQL Server FILESTREAM
• Author(s) Jacob Sebastian and Sven Aelterman
• Publisher: Red gate books (August 31, 2012)
• Paperback 512 psges
• eBook PDF (497 pages, 8.09 MB)
• Language: English
• ISBN-10: 1906434891
• ISBN-13: 978-1906434892
• Share This:  

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.

• N/A

• Amazon

• Miscrosoft SQL Server
• Database, Data Warehouse and Data Management
• Data Management White Papers
• Microsoft Windows and .NET

• The Art of SQL Server FILESTREAM (Jacob Sebastian, et al)
• The Mirror Site (1) - PDF

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• SQL Server Execution Plans, 3rd Edition (Grant Fritchey)

  This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans, leads you right from the basics of capturing plans to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

• SQL Server Concurrency: Locking, Blocking and Row Versioning

  This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

• SQL Server Backup and Restore (Shawn McGehee)

  This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes.

• SQL Server Team-based Development

  How to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as "normal" development.

• Performance Tuning with SQL Server Dynamic Management Views

  This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.

• 45 Database Performance Tips for Developers (Phil Factor, et al)

  Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.

• SQL Server Integration Services (SSIS) Succinctly (Rui Machado)

  With this book, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.

• Introducing Microsoft SQL Server: Technical Overview

  In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions.

• BI Solutions Using SSAS Tabular Model Succinctly (P. Savjani)

  This book delivers a business intelligence solution is broken down into simple steps to help you turn raw data into an interactive reporting dashboard. It walks you through the layers of a BI solution, how to develop a tabular data model with SSAS

• SQL Server Analysis Services Succinctly (Stacia Misner)

  You will learn how to implement a business intelligence solution through SQL Server Analysis Services. You'll start with developing a database, and learn which architecture is most appropriate for the database's end use.

• Fundamentals of SQL Server Replication (Sebastian Meine)

  This book provides the hands-on introduction you need to get started, and explores all of the technology's most important strengths and weaknesses.