Filestream allows us to store and manage unstructured data in SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly. However, it became clear that we were missing out on some extraordinarily useful functionality, so we asked Jacob Sebastian to come up with a simple and clear-cut account of the FILESTREAM feature in SQL Server 2008. You'll agree he has managed the feat superbly.

Call For Speakers – SQL Lunch Live Meeting

by Patrick LeBlanc

SQLServerCentral.com

Blogs

The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...

Different ways to determine free space for SQL Server databases and database files

by Additional Articles

MSSQLTips.com

database size

In this tip we take a look at a few ways to find the current free space within a database, so you can better manage your database files.

Loyalty Cards

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Many businesses have loyalty programs to encourage repeat business. However do they think about data security when they build these programs? Steve Jones thinks they could do better.

Loyalty Cards

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Many businesses have loyalty programs to encourage repeat business. However do they think about data security when they build these programs? Steve Jones thinks they could do better.

Loyalty Cards

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Many businesses have loyalty programs to encourage repeat business. However do they think about data security when they build these programs? Steve Jones thinks they could do better.

Changing Table Schema – what goes behind the scenes – Part II

by Alok Dwivedi

SQLServerCentral.com

Design and Theory

Part two of his series on table schema changes, this article examines those changes that affect the actual data. Read this great article from Alok Dwivedi.

Placing a Value on Data

by Steve Jones

SQLServerCentral.com

Editorial

What's your stolen data worth? It might be worth investigating, as Steve Jones suggests. Then you'll know how much you should be spending to protect it.

Foreign Key Constraints Revisited

by Additional Articles

Database Journal

Database Design

Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.

Installing Hyper-V and Beyond

by Additional Articles

SimpleTalk

Hyper-V

In his previous article “Hyper-V, an introduction” Jaap Wesselius explained about the Hypervisor, the parent partition, the child partition, and Integration Components. In this article Jaap discusses installing Hyper-V, all kinds of Virtual Hard Disks, Virtual Networks, and some best practices.

An Introduction to SQL Server FileStream

Call For Speakers – SQL Lunch Live Meeting

Different ways to determine free space for SQL Server databases and database files

Loyalty Cards

Loyalty Cards

Loyalty Cards

Changing Table Schema – what goes behind the scenes – Part II

Placing a Value on Data

Foreign Key Constraints Revisited

Installing Hyper-V and Beyond

Blogs

Git forked

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Forums

Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

The String Distance I

Question of the Day

The String Distance I