SQL Server 2012 File-Table Quota recently I was doing a POC for one of my customers which evaluate the feasibility of handling a file storage related task using SQL Server 2012 File-Table feature. the SQL Server team did a great job with the new File Table feature. it is a lightweight implementation which let you manipulate the file either directly (using file explorer or .NET System.IO ) of via the TSQL . for example you can delete a file using with TSQL : TSQL Snippet delete from [dbo] . [ImageFiles...
Bring Bulk insert into the ORM era modern application increasingly drifting toward Object Relational Mapping ( ORM ). but ORMs does not designed for bulk Insert operations, there were a few community solution, including this one, which deal with the issue, those solution are using the old ugly DataTable , which means ugly mapping from DTO to DataTable ( and potential memory leak if the DataTable does not disposed ). this post will suggest alternative solution which will use relative small...