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.

Jacob Sebastian

2013-03-15

5,153 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)

Jacob Sebastian

2012-11-12

418 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.

Jacob Sebastian and Sven Aelterman

2012-11-12

419 reads

Blogs

CISA Accredited Trainer!

By Brian Kelley

My certification came in! I’m now accredited to provide training for the Certified Information...

Correlated Subqueries vs Derived Tables

By Bert Wagner

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...

Video – Creating Azure SQL Database

By Arun Sirpal

A quick 2 minute upload (with sound, my voice) showing you how easy it...

Read the latest Blogs

Forums

Troubleshooting with. wait stats (last 2 weeks included)

By DataAnalyst011

I’m troubleshooting a slow SQL Server. Our server team is adamant it doesn’t need...

grant user read only whole server

By cphite

Hello — I should know this…  but is there any way to grant a...

Query to Find Mismatches

By MalcolmS

New user with what should be an easy question. I have two tables; both...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers