Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

All authors

Notes from SQLSaturday #21 – Part 1

by Andy Warren

SQLAndy

I started the logistics preparations last Sun (8 days ago), finalizing the print version of the schedule, the eval cards,...

2009-10-19

741 reads

PASS Update #16

by Andy Warren

SQLAndy

A one topic post this time. As a candidate for Vice President of Marketing for PASS this year I asked...

2009-10-18

631 reads

SQLSaturday #21 Shirt Snafu!

by Andy Warren

SQLAndy

Thought I’d share a funny story. Way back before SQLSaturday #1 my friend Shawn recommended a local shirt/embroidery vendor, I...

2009-10-16

499 reads

Book Review: The Deceived

by Andy Warren

SQLAndy

The Deceived by Brett Battles

I haven’t post on any fiction lately, thought it was time to write about something more...

2009-10-15

355 reads

SQL Lunch/Call for Speakers

by Andy Warren

SQLAndy

Patrick Leblanc has started a new project called…SQL Lunch! The concept is to present a 30 minute topic every two...

2009-10-15

890 reads

SQLSaturday #21 Is Tomorrow (Oct 17)

by Andy Warren

SQLAndy

I’m writing this in advance because I’ll be busy with all the last minute preparations, but I’m looking forward to...

2009-10-15

291 reads

Sparse Columns – ConvertSVtoXML & XMLToResv

by Andy Warren

SQLServerCentral.com

Blogs

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.