FILETABLEs: What They Are and How to Use Them

Lah Matija

Ostali podaci

Data Platform & Business Intelligence
300
English
10:45 - 11:45
016 (252)

Opis predavanja

Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, and from a homogeneous data store.

Matija Lah has more than fifteen ears of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Windows Server System SQL Server). In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

SolidQ CEE

Tarabica # IT Conference je najveća tehnička konferencija u Srbiji koju organizuju ljudi koji se profesionalno ili iz hobija bave Microsoft tehnologijama.