Adding FILESTREAM to an existing table in a database in SQL 2008 R2, SQL 2012

Posted
12/01/2015
IN

SQL

FILESTREAM is a great feature of SQL Server. It alleviates some of th eproblems of storing large unstructured data files such as documents, PDFs, and images, (BLOBs) in a structured database. It is very easy to enable FILESTREAM on a database/table when you are creating them. Most of us, however, get to inherit these things and then are then told to "fix it."

When initially presented with the problem, I searched the Internet for a solution and could not find something that is complete, so after a lot of tinkering with different things found online, and some help from a colleague, I came up with these steps to follow to enable FILESTREAM on an existing database and then convert an existing BLOB table into a FILESTREAM table.

There are three steps needed to enable FILESTREAM on the database.  You need to turn on the FILESTREAM feature on the instance, turn on the feature on the database, and then let the database know where to store the data on the file system

Read More

SQL Server Performance Monitoring

Posted
01/07/2014
IN

SQL

Does it take you hours just to get a simple report out of your company’s application? Do you have mission critical applications that are slow or going down all the time? Have you received complaints from customers or vendors because of application availability issues?

Read More