Jacob Sebastian

SQL Server XML Schemas

When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. Jacob Sebastian's book explains all.

2013-03-15

5,164 reads

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.

4 (1)

2012-11-12

420 reads

The Art of SQL Server Filestream eBook Download

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.

2012-11-12

431 reads

Blogs

The Azure-SSIS IR Startup Time

By

If you want to run SSIS packages in Azure Data Factory, you need the...

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Strange update trigger behavior

By andre-119936

Hi. I create a update trigger on a table to audit data changes... the...

DW create User for DB Owner

By pdsqsql

we have created Data warehouse server and planning to create Databases, Schema and users....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers