sobota, april 19, 2008

BLOBi in SQL 2008

Architecture of Microsoft SQL SImage via WikipediaWhere to store large binary object (videos, movies, songs, documents) database or file system? That’s an old dilemma!

File system: quick, easy access, but no transaction control, duplicate logic
Database: less speed, harder to backup, but everything is under RDBMS management - more secure, centrally stored

And new Microsoft SQL Server 2008 supports both scenarios database and file system (NTFS) and wherever you decide to store.

VARBINARY data type is extended with attribute FILESTREAM – when set to true blobs data will be stored outside of database on NTFS, but transactions, joining, selecting and all other cool SQL stuff will be still available.

Post written just for testing Zementa! ;-)

Ni komentarjev: