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,228 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

462 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

510 reads

Blogs

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Suggested Topics in Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

Abuse, Patience, and Understanding

By

I’ve been struggling with an author for a few months. I tried to work...

Read the latest Blogs

Forums

Elevated Thread! Best Home of Screen Printing

By mariakeith

Elevated is the best place for screen printing services in the USA. The event...

SSRS 2016 data source - Azure SQL DB not working

By PJ_SQL

Hello! I am trying to create data source to connect to Azure SQL DB...

cumulative updates in multi instance standalone server

By noobdba

For 2019, how would one go about applying CU on multiple instances in a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers