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.

You rated this post out of 5. Change rating

2013-03-15

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

You rated this post out of 5. Change rating

2012-11-12

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

You rated this post out of 5. Change rating

2012-11-12

565 reads

Blogs

What to Know about Power BI Theme Colors

By

Power BI reports have a theme that specifies the default colors, fonts, and visual...

A Global Team Meeting

By

The last few years at Redgate we’ve had the entire (or most) of the...

A New Word: sayfish

By

sayfish – n. a sincere emotion that seems to wither into mush as soon...

Read the latest Blogs

Forums

MSOLEDBSQL/MSOLEDBSQL19 - Linked Servers and encryption

By Fozzie

Yes I know Linked Servers can be evil... but they can be fine and...

dbcc clonedatabase issue

By blom0344

I have used the 'dbcc clonedatabase'   schema-only backup procedure many times in the past...

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers