Storing XML in SQL Server - note to self

There are several ways of storing XML documents in SQL Server table.

One way is to use a table with datatype varchar(max) or nvarchar(max).
another option is to use XML data type column
or you can use varbinary(max)
if you are using SQL 2012, then there is yet another option: use filetable and filestream

Let’s look quickly at these options:

The

Continue reading […] Storing XML in SQL Server – note to self […]

 

A new addition to the Deployment Suite for Oracle: Source Control for Oracle

Have you heard the news?

Soon there will be a new addition to the Redgate’s Deployment Suite for Oracle. The Source Control for Oracle is coming to be a part of it.

So far the Deployment suite has the capabilities of comparing schemas, data and creating schema deployment scripts, but very soon the new member of the

Continue reading […] A new addition to the Deployment Suite for Oracle: Source Control for Oracle […]