Ward Pond's SQL Server blog - Site Home

Posts

| |

Ward Pond's SQL Server blog

Database Programming: The String Concatenation XML Trick, Finalized

Posted over 5 years ago

by WardPond
- 5 Comments
It's an especially Good Friday when we can close the loop on a technical conversation, and I believe that our modifications to The Technique That Lance Found , also discussed here and here , are complete. Scott Whigham left a comment on the most...
Ward Pond's SQL Server blog

Database Programming: The String Concatenation XML Trick, Sans Entitization

Posted over 5 years ago

by WardPond
- 6 Comments
When last we checked in on The Technique That Lance Found , Adam had noted that the method entitizes XML special characters, a state of affairs which limits its utility somewhat. I tried to leverage Tony Rogerson's technique , which Adam passed...
Ward Pond's SQL Server blog

R.I.P. Arthur C. Clarke (1917-2008)

Posted over 5 years ago

by WardPond
- 0 Comments
Sad word today from the world of letters that Arthur C. Clarke has passed at 90. While his most remarkable book was made into a most remarkable film (which bears little resemblance to the book, in my opinion), Clarke was an incredibly prolific writer...
Ward Pond's SQL Server blog

Another Word On For-Fee Aggregators

Posted over 5 years ago

by WardPond
- 1 Comments
One more post before I turn in.. Blogging is about passion and community, which may well be two sides of the same coin. Our passion makes us a community. Even though I don't read the output of my fellows in the SQL Server blogosphere nearly...
Ward Pond's SQL Server blog

Database Programming: The String Concatenation XML Trick Revisited (Or, Adam Is Right, But We Can Fix It)

Posted over 5 years ago

by WardPond
- 8 Comments
A find shared by one friend leads to correspondence from another.. The redoubtable Adam Machanic left a comment on The Technique That Lance Found which points out that special XML characters in a string will get entitized. As usual, Adam is correct...
Ward Pond's SQL Server blog

Database Programming: The String Concatenation XML Trick

Posted over 5 years ago

by WardPond
- 8 Comments
Courtesy of my good friend and once-and-always colleague, Lance Larsen, who writes: I recently ran into this little trick. Joining two tables having a one-to-many relationship and stuffing a set of column values from the many side into a single...
Ward Pond's SQL Server blog

Don't Forget! SQL Server 2008 Web Chat On Thursday, March 13

Posted over 5 years ago

by WardPond
- 0 Comments
I wanted to mention this one more time, since my previous post on this topic suffers from a cryptic title.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008....
Ward Pond's SQL Server blog

Yet Another Blog You Should Check Out

Posted over 5 years ago

by WardPond
- 0 Comments
The comment space for yesterday's rant about the web site that's charging for access to MSDN and TechNet blog content is busier than any has been for awhile. I also got this email via the contact mechanism on the blog: I was just about to ask you...
Ward Pond's SQL Server blog

SQL Server 2008 February CTP Scheduled For March 13

Posted over 5 years ago

by WardPond
- 1 Comments
Forwarding along a nugget that my inbox served up.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008. The web chat starts here at 11 am Pacific Daylight Time...
Ward Pond's SQL Server blog

Are You Paying To Read This Post? You Don't Have To!

Posted over 5 years ago

by WardPond
- 7 Comments
In the age of the blog, it may well be that republishing is the sincerest form of flattery. The same RSS technology that many of you use to read the blog through wonderful rollers like this one also can be turned to far more nefarious purposes. I'm going...
Ward Pond's SQL Server blog

Greetings From Windows Live Writer, and Other Non-Technical News

Posted over 5 years ago

by WardPond
- 1 Comments
Sure, it's a somewhat contrived reason for a post, but it's leap day. In such a calendar-centric endeavor as a blog, it seems to me that one must leave a footprint on leap day.. I'm posting today via Windows Live Writer, which I downloaded earlier...
Ward Pond's SQL Server blog

At Long Last, Great News For Stephen and rudy

Posted over 5 years ago

by WardPond
- 5 Comments
It took me far too long to get this done.. health issues, project deadlines.. but forty posts after the December contest was annouced and thirty-eight posts after your victories were confirmed -- not to mention a month after I promised to ship them in...
Ward Pond's SQL Server blog

An Answer For Spazecaze: A Reasonable Method To Implement User Defined Fields

Posted over 5 years ago

by WardPond
- 3 Comments
Spazecaze discovered a February, 2006 discussion of order of operations and poses the following question in its comment area : So how would you go about designing a database that allows for end user defined fields? For instance, a system is...
Ward Pond's SQL Server blog

CTP 6 of SQL Server 2008 Is Now Available For Download

Posted over 5 years ago

by WardPond
- 0 Comments
The latest CTP of SQL Server 2008 is available for download at the Microsoft Connect website, here . The list of new features in this release is pretty impressive: Progress-Based Management: policy violation alerts, policy import, running and...
Ward Pond's SQL Server blog

Springtime Must Be Close At Hand..

Posted over 5 years ago

by WardPond
- 0 Comments
..pitchers and catchers have reported to spring training. This is better than the groundhog and his shadow.. -wp
Ward Pond's SQL Server blog

Are You An ISV Who's Making A Difference In The World? Here's A Contest For You!

Posted over 5 years ago

by WardPond
- 0 Comments
I just got word of an interesting new contest sponsored by Microsoft called The Ingenuity Point . The contest is designed to recognize and celebrate ISVs who are making a meaningful difference in the areas of education, healthcare , and environmental...
Ward Pond's SQL Server blog

R.I.P. Ken Henderson: 1967-2008

Posted over 5 years ago

by WardPond
- 1 Comments
I've been a bit out of touch with the blogosphere over the last couple of weeks, so I was absolutely floored when a colleague forwarded me Kalen Delaney's post on the recent sudden passing of Ken Henderson of Guru's Guide renown (just how sudden is evidenced...
Ward Pond's SQL Server blog

This Week: The SQL Server 2008 Jumpstart

Posted over 5 years ago

by WardPond
- 1 Comments
I'm spending the week in the SQL Server 2008 Jumpstart event here in Redmond. I'm on the Developer track, which means I get to spend three days listening to the great Bob Beauchemin extoll the virtues of the new programmability constructs in SQL Server...
Ward Pond's SQL Server blog

Where Has Ward Been?

Posted over 5 years ago

by WardPond
- 2 Comments
Well, at least I can say that I was counting my blessings.. I've been slowly getting back up to speed since a relapse of my pancreatitis just after New Year's. With the patience of family and colleagues, I'm most of my way back to being a productive...
Ward Pond's SQL Server blog

What Do You Get When You Give A Community Builder An External Website?

Posted over 5 years ago

by WardPond
- 0 Comments
I've asked to rhetorical questions such as this two times previously, each in reference to an event masterminded by Saleem Hakani, the persistent and determined gentleman behind the internal Microsoft SQL Server Community movement. Never one to leave...
Ward Pond's SQL Server blog

DWWTWT?: December 31

Posted over 6 years ago

by WardPond
- 2 Comments
In what seems to be becoming an annual tradition , I'm "going public" with the final commuting-oriented post of the calendar year. If this "tradition" strikes you as more of an "indulgence," please skip this post and accept my best wishes for a joyous...
Ward Pond's SQL Server blog

Season's Greetings

Posted over 6 years ago

by WardPond
- 2 Comments
Dear Friends and Colleagues.. After a year of great personal and professional growth (my first overseas trip to deliver my first customer-facing presentations) and personal challenge (three surgeries and five hospitalizations in our family), it's a...
Ward Pond's SQL Server blog

Non-Technical News: R.I.P. Dan Fogelberg

Posted over 6 years ago

by WardPond
- 1 Comments
Sad news today that songwriter Dan Fogelberg has passed away at age 56 after a three-year battle with prostate cancer. I discovered Fogelberg's music at about the same age my sons are now (14 & 15). My habit in the day was to find new artists to...
Ward Pond's SQL Server blog

And The Winners Are..

Posted over 6 years ago

by WardPond
- 2 Comments
Stephen Moore and rudy, who both correctly divined that " the contest post " was the 500th on the blog. By the time rudy got here, there were already two new DWWTWT? posts since the contest post had gone up, which made his successful entry all the...
Ward Pond's SQL Server blog

Today's Blog Post Is Brought To You By The Letter "D"

Posted over 6 years ago

by WardPond
- 10 Comments
Let's have a little fun.. This is a special post in the history of this little backwater of the internet. Its specialness is related to the letter D. If you can figure out why this post is special, and how that specialness is related to the letter...