Join other Florida .NET Developers in Ft. Lauderdale, Florida to learn various SQL Server 2008 T-SQL Enhancements with Dave Noderer on Tuesday, November 4, 2008 at 6:30pm.
"Check out the SQL Server 2008 new features in T-SQL including Filestream data, the merge statement and table valued parameters plus an introduction to SQL Server 2008 PowerShell."
FileStream Data Type in SQL Server 2008
SQL Server 2008 introduces two new capabilities for storing BLOB data:
- FILESTREAM: An attribute you can set on a varbinary column so that the data is stored on the file system (and therefore benefits from its fast streaming capabilities and storage capabilities) but is managed and accessed directly within the context of the database.
- Remote BLOB Storage (RBS): A client-side application programming interface (API) that is designed to move storage of BLOBs from Microsoft SQL Server to external storage solutions.
Specifying the FILESTREAM attribute on a varbinary(max) column causes SQL Server to store the data on the local NTFS file system instead of in the database file. FILESTREAM data is stored in special FILESTREAM filegroups, called containers, that contain the file system directories, not the files themselves. Individual files stored in a FILESTREAM column cannot be opened directly from the NTFS file system. They can only be manipulated as part of a SQL Server transaction.
Learn more.
Table-Valued Parameters in SQL Server 2008
Table-valued parameters are a new parameter type in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters.
Table-valued parameters are like parameter arrays in OLE DB and ODBC, but offer more flexibility and closer integration with Transact-SQL. Table-valued parameters also have the benefit of being able to participate in set-based operations.
Learn more.
Register here for an evening of SQL Server 2008 in Ft. Lauderdale, Florida.
If you are interested in FREE SQL Server 2008 Training, you may want to make the trip to the Orlando SQLSaturday Event:
SQL Server 2008 Annoucements