I would like to see a (T-)SQL function like normalize-space() from XPath, which I believe is slightly more useful than just TRIM, as it deals with all white space characters...

I was reading Chapter 1 of your interesting book and was a bit puzzled by the solution to the Defending Against Cases of Unintended Use example. If you do not...

[p]I am having some difficulty understanding the categorizations of roles used here.

[/p][p]My understanding of a database administration role is close to Wikipedia's, where a DBA looks after but does not...

Another way of building this functionality could be to:

1) add a BIT "email result to system admins" parameter to selected stored procedures;

2) put a conditional path in those queries to...

I think that you can use SQL stored procedures with Microsoft's entity framework if you choose. Although we do not use the entity framework at the moment, we are rewriting...

I see that you do not have to do RBAR to get row error details for BULK INSERT from a data file.

Is there a set-based/declarative/T-SQL way of getting row error...

Jeff Moden (12/11/2013)

---

To tell the truth, though, there should be 0 failures all the time even if the data is bad because the data should be imported into a staging...

The snoop bins look to me like crossing the line into illegality if you consider the ICO's Data Protection Technical Guidance: Determining what is personal data.

Even if you argue that...

Decomposing an XML document into relational tables, rows and columns is commonly called "shredding", and you can find various articles on this, although I have found some of them to...

You are welcome, Evil Kraig F 🙂

I did notice I made a mistake in naming the ID attribute, since XML ID attributes are specially reserved and should have a value...

Here's one approach. I adapted some code from another XML generation solution, and it might be a little messy. One difference is that here you have more of a many-to-many...

Koen Verbeeck (1/23/2013)

---

I'd like to see the performance of the XML solution.

Also, I would think the structure of your website is known, so a relational model is preferred.

Curious to see...

You could start by creating a mock-up (example) Word...

I would agree with the views that (pending further investigation) the website data should probably be first modelled relationally based on the given entities, then augmented with XML structures.

A College...

You might want to look at the Office Open XML File Formats used by Word 2007 onwards, but they are complex.

You can read introductory articles such as Walkthrough: Word 2007...