Sign in
Ward Pond's SQL Server blog
Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Blog - Link List
SQL Server Resources
Michael Rys' blog
Kimberly L. Tripp's blog
Adam Machanic's blog
SQL Server 2005 Service Pack 3
Books OnLine For SQL Server 2005 SP1
Hugo Kornelis' blog
SQL Server Customer Advisory Team blog
Tips, Tricks and Advice from the SQL Server Query Processing Team
Gert Drapers' blog
"Data Dude" Development Manager
PSS SQL Server Engineers' blog
Microsoft Certified Masters program blog
RBarryYoung's blog (movingsql.com)
News
Keith Olbermann
How Mark Felt Fooled The FBI
Music
Little Feat
Planet Earth's House Band
Warren Zevon
an American original
Jordan Zevon
Warren's progeny; a singular talent in his own right
Wolfgang's Vault
Forty years of Bill Graham concerts streaming online!
Pat Metheny on Kenny G
The jazz guitarist editorializes, employing several of George Carlin's seven words in the process
Published Articles
XML To The Max: Get More Power Out Of Your SQL Server
a primer on XML manipulation in SQL Server 2000
XML Programming In SQL Server 2005
a primer on XML manipulation in SQL Server 2005
Other Publications
SQL Q&A - Technet Magazine, Winter 2005
SQL Q&A - Technet Magazine, October 2006
SQL Q&A - Technet Magazine, January 2007
SQL Q&A - Technet Magazine, February 2007
SQL Q&A - Technet Magazine, August 2007
Panel Discussions
SQL PASS 2006: The Growing World of SQL Server: Surviving the Data Avalanche (Nov. 19)
A Bit More From Me
Ward Pond's TechEd Developers 2008 Resource Page
slide decks and demonstration scripts from my TechEd Developers 2008 presentations
The Pond's Laws Home Page
a compendium of the Pond's Laws posts
WardPond.net
my personal web page
zPond's Ponderings
my personal blog (pardon the extraneous character, but these items are alpha sorted)
Search Blogs
Tags
Baseball
Business Intelligence
Career
Charitable Works
Conferences
Contests
DWWTWT?
Home Office
News
Optional Parameters
Personal Technology
Pond's Laws
Prime Numbers
Programming Methodology
Quality
Set-Based Thinking
Software Release Announcements
SQL Server 2000
SQL Server 2005
SQL Server 2008
TechEd Developers 2008
Technical Content
Vista
Windows 7
XML
Archive
Archives
October 2010
(1)
September 2010
(2)
August 2010
(1)
July 2010
(1)
June 2010
(3)
February 2010
(1)
January 2010
(2)
December 2009
(2)
November 2009
(2)
October 2009
(11)
September 2009
(12)
August 2009
(7)
July 2009
(9)
June 2009
(12)
May 2009
(7)
April 2009
(17)
March 2009
(14)
February 2009
(18)
January 2009
(15)
December 2008
(17)
November 2008
(18)
October 2008
(11)
September 2008
(18)
August 2008
(6)
July 2008
(5)
June 2008
(9)
May 2008
(20)
April 2008
(25)
March 2008
(33)
February 2008
(21)
January 2008
(8)
December 2007
(18)
November 2007
(25)
October 2007
(17)
September 2007
(6)
August 2007
(24)
July 2007
(20)
June 2007
(22)
May 2007
(16)
April 2007
(12)
March 2007
(18)
February 2007
(24)
January 2007
(21)
December 2006
(25)
November 2006
(46)
October 2006
(34)
September 2006
(39)
August 2006
(40)
July 2006
(35)
June 2006
(26)
May 2006
(4)
April 2006
(10)
March 2006
(7)
February 2006
(7)
December 2005
(1)
November 2005
(3)
October 2005
(4)
September 2005
(3)
August 2005
(2)
July 2005
(4)
June 2005
(2)
TechNet Blogs
>
Ward Pond's SQL Server blog
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Ward Pond's SQL Server blog
Database Design: A Brief Rant About Quality
Posted
over 8 years ago
by
WardPond
2
Comments
If you could save your company $225 million in ten minutes, would you?...
Ward Pond's SQL Server blog
Slight Ado About Nothing: More On NULLs
Posted
over 8 years ago
by
WardPond
3
Comments
More on NULLs: a reader asks if NULLs slow down searches....
Ward Pond's SQL Server blog
93,000 Concurrent SAP Users In A Free Download?!
Posted
over 8 years ago
by
WardPond
1
Comments
No, you can’t run 93,000 concurrent SAP users on SQL Server Express (you’ll need SQL Server Enterprise Edition and some pretty decent server iron to do that), but you will be able to access up to 4gB of database space and 1gB of RAM – in a free download!...
Ward Pond's SQL Server blog
Launch 2005: Here Comes The Next Generation of Developer Tools
Posted
over 8 years ago
by
WardPond
0
Comments
TCO will never be looked at the same way again. ...
Ward Pond's SQL Server blog
XML Programming in SQL Server 2005
Posted
over 8 years ago
by
WardPond
0
Comments
With the RTM of SQL Server 2005, excitement is understandably running very high in the SQL Server developer community....
Ward Pond's SQL Server blog
Database Design: Do Not Fear NULLs
Posted
over 8 years ago
by
WardPond
9
Comments
A brief discourse on what NULLity means, how it works in the database, how to use it, and examples of its misuse....
Ward Pond's SQL Server blog
Two Programming Tricks: Counting Characters In A String and RETURN CASE
Posted
over 8 years ago
by
WardPond
1
Comments
A couple of tricks here, from some recent work: a user-defined function to count the number of characters in a string, and a new (for me) syntax discovery: RETURN CASE....
Ward Pond's SQL Server blog
The Gig Was..
Posted
over 8 years ago
by
WardPond
0
Comments
.. a blast. Over $100 was raised, which the company will match, and as far as I know a good time was had by all. If you'd like to support Cocoon House , please let me know .
Ward Pond's SQL Server blog
The Gig is On
Posted
over 8 years ago
by
WardPond
0
Comments
As promised, here are the details of the Giving Campaign concert for Cocoon House . I'll be playing between noon and one on Monday, October 3rd, at the cafeteria in the Microsoft "Sammamish C" building in Issaquah, WA. If you can't join us but would...
Ward Pond's SQL Server blog
SQL Server 2005 September CTP Available Now!
Posted
over 8 years ago
by
WardPond
0
Comments
Here's a nice little query on the Microsoft download site that will give you quick links to most all of the essential components of the latest Community Technology Preview edition of SQL Server 2005. Even if you can't install the software (and you should...
Ward Pond's SQL Server blog
Respite From The Last Mile
Posted
over 8 years ago
by
WardPond
0
Comments
I have been neglectful of this blog recently, as my team is hard on the last mile to both the production go-live of v1.0 of our product and the drop to test of the first release of our localization Service Pack next week. I've pulled several late nights...
Ward Pond's SQL Server blog
Baseball Challenge This Sunday!
Posted
over 8 years ago
by
WardPond
0
Comments
Full details here .. please support this worthy cause if you can! More next week.. -wp
Ward Pond's SQL Server blog
The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statement
Posted
over 8 years ago
by
WardPond
19
Comments
Updated 20 Mar 2009: This code is revisited here . This nifty little trick will allow you, with some limitations, to treat the output of a stored procedure as a named SQL record set rather than creating a table and going through an INSERT.. EXEC process...
Ward Pond's SQL Server blog
Facelift I
Posted
over 8 years ago
by
WardPond
0
Comments
I've given the blog a bit of a facelift.. please click the comment link below and let me know if you like what you see. Actual SQL content will come early next week, in the form of something I've come to call "the OPENROWSET trick." Stay tuned,...
Ward Pond's SQL Server blog
Thanks, Scotty..
Posted
over 8 years ago
by
WardPond
1
Comments
Sad news today that James Doohan has passed away .. If you're of a particular age, Star Trek was at the least a presence in your life; for many of us, it was an influence. What my mother called "claptrap" when it premiered shortly after my sixth birthday...
Ward Pond's SQL Server blog
Baseball Challenge 2005: A Chance To Give Something Back
Posted
over 8 years ago
by
WardPond
2
Comments
Warning: what follows is a shameless solicitation, directed towards my friends and colleagues in the Puget Sound region and throughout the country, to provide financial assistance to some of the most innocent, wonderful people you will ever meet. If this...
Ward Pond's SQL Server blog
A Solution For Stripping Invalid XML Characters From varchar/text Data Structures
Posted
over 8 years ago
by
WardPond
6
Comments
One of the more subtle aspects of converting (n)varchar or (n)text data to XML is the fact that XML is choosy about which characters are permitted and (n)/varchar/(n)text is not. Any T-SQL programmer who runs conversions of this type is likely to run...
Ward Pond's SQL Server blog
SQL Server 2005 XQuery Performance Tips
Posted
over 8 years ago
by
WardPond
3
Comments
During some recent Xquery performance work, three discoveries emerged which dramatically improved the performance of my team's component. I'd like to share them here.. Specify A Single Root Node The XML parser in SQL2K5 doesn't assume that the XML...
Ward Pond's SQL Server blog
Welcome!
Posted
over 8 years ago
by
WardPond
2
Comments
Welcome to my new blog. Perhaps I should start off by answering the old Admiral Stockdale question: who am I and why am I here? I'm a Senior Applications Developer in Microsoft's internal IT department. I've been designing and coding PC and mainframe...
Page 16 of 16 (394 items)
«
12
13
14
15
16