I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.
SQL SERVER – FIX: Error: 5511 – FILESTREAM’s file system log record under log folder is corrupted
Error 5511 says the FILESTREAM file system log record under the log folder is corrupted. Here is how I got the database back online.
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
Slow Filestream Data Cleanup can follow deletion when files are still ineligible for garbage collection. One customer was running out of space.
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
A script upgrade failure left SQL Server down with RsFxFt.Dll error 0x80070002 and error 5597. Tested on SQL Server 2025: the FILESTREAM cause.
FileTable: Files You Can Open in Explorer and Query in T-SQL
Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties
Part 3 of my FileTables series for SQL Server 2012: queries to tell files from folders and find root paths, path locators and relative paths.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table
Part 2 of my FileTables series covers two methods to insert data into a FileTable in SQL Server 2012, starting with a simple copy and paste.