Jacob Sebastian


SQLServerCentral Article

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,297 reads

SQLServerCentral Article

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

508 reads

The Art of SQL Server Filesteam eBook cover

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

551 reads

Blogs

Types of data consulting engagements and what you can expect from them

By

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022

By

Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout

By

I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs

Forums

SSAS Tabular Excel reports slower after upgrade

By woutgoet

Hello, We recently upgraded our SSAS Tabular model from compatibility level SQL Server 2014...

db_datareader user cannot connect to read-only routed AlwaysOn SQL cluster

By goftari

I have set up a 2-node SQL AlwaysOn cluster and configured read-only routing for...

New Topic for SQL Server 2022

By andreas.kreuzberg

Hi dear admins, can you start a new group for sql server 2022 threads?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers