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)
June, 2006
TechNet Blogs
>
Ward Pond's SQL Server blog
>
June, 2006
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Ward Pond's SQL Server blog
Database Programming: An Incrementally Better Mousetrap For Optional Parameters
Posted
over 7 years ago
by
WardPond
4
Comments
enderC points out that the syntax I proposed in last night's post on optional parameters can be made more readable thusly.. SELECT x FROM dbo . foo WHERE COALESCE ( y1 , @constant ) = COALESCE ( @p1 , y1 , @constant ) AND COALESCE ( y2 , ...
Ward Pond's SQL Server blog
Do I Need To Start A Baseball Feed?
Posted
over 7 years ago
by
WardPond
0
Comments
With last night's posts, you might have noticed a couple of loose ends being tied up. I'm trying to get loose ends tied up all over the place, because.. As of this afternoon, I'm on vacation until the morning of July 10th. Other than some "deferred...
Ward Pond's SQL Server blog
Made In Express Contest Finalists Selected
Posted
over 7 years ago
by
WardPond
1
Comments
I first blogged on this contest way back in March.. well, the twelve finalists have been selected, and all of the work that's going on is pretty cool. Head on over to the Made In Express Contest website and check out the latest details. You're sure to...
Ward Pond's SQL Server blog
Database Programming: Optional Parameters Revisited
Posted
over 7 years ago
by
WardPond
6
Comments
Frequent visitors might recall a thread earlier in the spring regarding optional parameters to a stored procedure (the earlier posts are here , here , and here ). The question had basically boiled down to whether there was single-statement syntax available...
Ward Pond's SQL Server blog
What Do You Get When You Put 600 Database Developers In A Room?
Posted
over 7 years ago
by
WardPond
4
Comments
Well, earlier this afternoon at least, you got SQL-Fest, which is believed to be the largest SQL Server training event ever held at Microsoft. It was my honor to act as master of ceremonies for this event. The focus of today's session was the new Database...
Ward Pond's SQL Server blog
Epilogue: Not All Dreams Come True
Posted
over 7 years ago
by
WardPond
2
Comments
I just wanted to follow up yesterday's post on the Redmond Red Sox. Last night, the boys played in their district championship game against, of all teams, the North Bend Rainiers. They fought hard, but eight unearned runs in the fourth inning proved...
Ward Pond's SQL Server blog
Field of Dreams: Better Living through Youth Baseball
Posted
over 7 years ago
by
WardPond
5
Comments
Databases are important. Databases pay my bills, and presumably those of many of you reading this blog. But there are more important things in life than databases. I’d like to tell you a short story of how faith and perseverance can move mountains. I...
Ward Pond's SQL Server blog
This Blog Is One Year Old!
Posted
over 7 years ago
by
WardPond
2
Comments
That's right, this humble enterprise, which began its on-line life with a questionable Admiral Stockdale pun, is exactly one year old as of the minute this post was published to the aggregators. This is the 59th post during that period, and 39 of those...
Ward Pond's SQL Server blog
Happy Birthday, Mom
Posted
over 7 years ago
by
WardPond
0
Comments
Today would've been my mom's 79th birthday. I can't call her today. I wish I could. If you can, please, even though tomorrow is Father's Day, call your mother too. -wp
Ward Pond's SQL Server blog
New Job, New (non-technical) Blog Feature
Posted
over 7 years ago
by
WardPond
6
Comments
A new, non-technically oriented feature of this blog is unveiled....
Ward Pond's SQL Server blog
Good Luck, Robert Scoble
Posted
over 7 years ago
by
WardPond
0
Comments
Late last night, a certain geek-focused corner of the blogosphere worked itself into something of froth over the pending departure from Microsoft of Robert Scoble , a platform evangelist and noted blogger. Robert has also been a part of the Channel...
Ward Pond's SQL Server blog
Database Programming: Slaying The Time Zone Conversion Beast (or at least rendering it comatose)
Posted
over 7 years ago
by
WardPond
16
Comments
Schema and code for performing time zone conversions is discussed....
Page 1 of 1 (12 items)