SQL Server, How to manage files in SQL Server. The Filetables feature
Hi Guys, Welcome back to this my SQL server technical blog! I am here again after three weeks of holiday that I really needed in order to recharge my internal batteries. Now that my batteries are full I am able to hear you voices that are asking: What will be today's topic? Okay okay today we will speak about “ How to manage file in SQL server ”. How to manage file in SQL server You must know that starting from the 2012 edition SQL Server have a filetables feature . Mmmmh…. never heard that? As usually I will try to explain myself in the clearest way. But ask me it is not! So are you ready? Let’s go!!! The Filetable feature. Intro With The FILETABLE feature (that is the next step in the FILESTREAM technology) you can store files and folders inside the special tables . You can access to these table with the traditional Windows SMB protocol. FileTables let us use SQL tables for non-transactional access so is possible create, read, modify or delete files from a generic file sh