FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

The SQL FILESTREAM feature provides efficient storage, management, and streaming of unstructured data stored as files on the file system. The SQL server database file provider serves the file system ...

Limit Trace File and Table Sizes [!INCLUDE SQL Server] SQL Trace results vary in size depending on the event classes that are included in the trace and the way in which the [!INCLUDE ssDE] is used.

Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

This post is authored by Amit Banerjee, Principal PM Manager, SQL Server and Bob Ward, Principal Architect, Microsoft SQL Server Data Services. SQL Server has provided enterprises the capability to ...