Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » File Stream   (RSS)

How to use FileStream feature in an ASP.NET Web Application that uses Forms or Anonymous authentication

We have a customer who uses Form based authentication in his ASP.NET application. But he also wants to use FileStream feature. Authentication becomes a challenge. In order for FileStream to work, sql connection needs to use ingetrated security (not SQL
Posted by psssql | 1 Comments
Filed under:

How It Works: File Stream Compression with Backup/Restore

The question of file stream compression during backup and restore arose last week and makes for a good clarification topic. Shown here is a conceptual layout of a database containing file stream containers.    On the left the folders represent
Posted by psssql | 2 Comments

How It Works: File Streams Requires Integrated Security (Windows Authentication)

SQL Server authentication versus Windows Authentication seems to cause File Stream users confusion.   I thought this e-mail chain would help. From: Robert Dorr Subject: RE: OpenSqlFilestream problem   It is really not the SQL Server Service
Posted by psssql | 3 Comments

How It Works: Debugging SQL Server Stalled or Stuck I/O Problems - Root Cause

Previously I have covered stuck and stalled I/O issues in other posts and articles.  However, these only tell you that there is a problem outside the SQL Server engine.   This post attempts to extend your root cause debugging capabilities

How It Works: File Stream the Before and After Image of a File

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. The question that spawned this entry was: "I am performing updates of a specific row and
Posted by psssql | 1 Comments
 
Page view tracker