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
SINGLE_BLOB Size Limit: An Affirmation for Bert
Posted
over 4 years ago
by
WardPond
1
Comments
Bert left a comment on this post pointing out a limitation of “the other OPENROWSET trick” (the one which loads an XML file into a single XML column): I tried this, but had an error because my XML file is 6gB. The SINGLE_BLOB seems to be limited to 2gB...
Ward Pond's SQL Server blog
Windows 7 Beta Downloads Extended Through February 10
Posted
over 4 years ago
by
WardPond
1
Comments
There’s a new post on The Windows Blog indicating that general availability of the Windows 7 Beta download will end on February 10th. Here’s the calendar: The shutdown of general availability for the Windows 7 Beta will occur in 3 phases over the...
Ward Pond's SQL Server blog
A Moment of Silence, Please
Posted
over 4 years ago
by
WardPond
0
Comments
Per’s already been busy on his new blog .. Up until a few months ago, we had someone on our team who did the Master and MCA marketing for the last two years, and did a great job with it. Today, her mother passed away after some longer term health struggles...
Ward Pond's SQL Server blog
The Microsoft Certified Master Programs Have Joined the Blogosphere
Posted
over 4 years ago
by
WardPond
1
Comments
If you’re looking for the best high-end training in Microsoft technologies – OCS, Exchange, SharePoint, SQL Server, or Windows Directory – the Microsoft Certified Masters program is where you want to be. The program’s website has always been a great...
Ward Pond's SQL Server blog
Cumulative Update Package 3 for SQL Server 2008 Released
Posted
over 4 years ago
by
WardPond
1
Comments
I was two weeks late with my announcement of CU #2 ; this announcement is coming to you on the day of release. Sometimes it’s better to be lucky than good.. Cumulative Update Package 3 for SQL Server 2008 has been released and is available for download...
Ward Pond's SQL Server blog
Get Well, Steve Jobs
Posted
over 4 years ago
by
WardPond
0
Comments
Sure, he’s a competitor, but some things trump business . Sad news about Steve Jobs’ health today, as what was described last week as a “relatively simple and straightforward” hormone imbalance is now “more complex than.. originally thought.” I know...
Ward Pond's SQL Server blog
Issue 18 of The Architecture Journal Now Available
Posted
over 4 years ago
by
WardPond
2
Comments
I found out recently that Microsoft publishes a quarterly called The Architecture Journal . As its website says, its articles are designed to offer perspective, share knowledge, and help you learn the discipline and pursue the art of IT architecture...
Ward Pond's SQL Server blog
Yet Another Holiday Query: Adam Wants to Play
Posted
over 4 years ago
by
WardPond
2
Comments
If this keeps up, I might need to define a tag for this stuff.. Our old friend Adam Machanic , perhaps inspired by the work of Dirk and Madhivanan , left a comment with his own contribution to the seasonal query pool. He was sufficiently concerned that...
Ward Pond's SQL Server blog
Another Seasonal Query, Slightly Late..
Posted
over 4 years ago
by
WardPond
4
Comments
On the heels of Christmas Eve’s seasonal query from Dirk Gubbels comes this gem from Madhivanan (with a tip of the hat to Dave Edwards’ link in Log Buffer #129 ). set nocount on select space ( 7 - len ( replicate ( char ( 42 ), no )))+ replicate...
Ward Pond's SQL Server blog
Windows 7 Beta Available for Download This Friday, January 9
Posted
over 4 years ago
by
WardPond
1
Comments
Exciting news over on The Windows Blog : the first and only release of the Windows 7 Beta will be available for download here this Friday, January 9. The full details are here , but I'll share some highlights: The beta will only be available for...
Ward Pond's SQL Server blog
DWWTWT?: December 29-31
Posted
over 5 years ago
by
WardPond
0
Comments
In the second of my annual indulgences , I’m “treating” you to a summary of my commuting life this year. A note to the uninitiated: there has been a hidden feed on this blog since I started my position in the SQL CoE in June of 2006. My office was...
Ward Pond's SQL Server blog
Feedback is a Gift; Thanks, Kalen!
Posted
over 5 years ago
by
WardPond
1
Comments
The law of unintended consequences is an amazing thing. When I posted Dirk Gubbels’ holiday greeting last week, I very quietly snuck in a new format for displaying source code, a formatting plug-in that was recommended in an internal discussion group...
Ward Pond's SQL Server blog
A Seasonal Query
Posted
over 5 years ago
by
WardPond
12
Comments
UPDATED 29 Dec 2008: Back to the tried-and-true source code formatting method, per Kalen’s comment and my response . UPDATED 24 Dec 2008: I got this from a couple of different sources, so I didn't realize when I drafted this post that Dirk wrote...
Ward Pond's SQL Server blog
SQL Server 2005 SP3 CU1 Is Now Available
Posted
over 5 years ago
by
WardPond
0
Comments
Hot on the heels of the initial SQL Server 2005 SP3 release , Cumulative Update 1 for SQL Server 2005 SP3 is available for download here . From the Knowledge Base article : Cumulative Update 1 for SQL Server 2005 Service Pack 3 contains only...
Ward Pond's SQL Server blog
May Glad Tidings be Upon You
Posted
over 5 years ago
by
WardPond
3
Comments
UPDATED 20 Dec 2008 to fix links It’s that time of year again, when I disappear from the blogosphere for a couple of weeks to contemplate the blessing of home and family. Before I do that, I’d like to use the blog’s 700th post for my annual holiday...
Ward Pond's SQL Server blog
It's Here! SQL Server 2005 Service Pack 3 Now Available for Download
Posted
over 5 years ago
by
WardPond
5
Comments
As discussed here , SQL Server 2005 Service Pack 3 is now available for download here . The following information is taken verbatim from the Data Platform Insider : SQL Server 2005 SP3 is now available for download and includes the following updates...
Ward Pond's SQL Server blog
Linchi Shea Makes an Interesting Point About Hints
Posted
over 5 years ago
by
WardPond
2
Comments
I had a couple of extra minutes today and found this post on Linchi Shea’s blog ; I wanted to commend to all of you who’ve taken in the programming methodology and set-based thinking discussions in this little corner. While I disagree some with the...
Ward Pond's SQL Server blog
Database Programming: OBJECT_ID Takes Three-Part Identifiers
Posted
over 5 years ago
by
WardPond
2
Comments
This is another one of those tricks that’s been available since the earth was cooling, but I just discovered it recently. So, here’s a history lesson in the form of a small T-SQL script, with the moral contained in the title of this post: set...
Ward Pond's SQL Server blog
Cumulative Update Package 2 for SQL Server 2008 Released
Posted
over 5 years ago
by
WardPond
2
Comments
Can you tell I’m moving towards the top of my in-box? My earlier release announcement was three months late; this one is only two weeks so. Cumulative Update Package 2 for SQL Server 2008 has been released and is available for download here . ...
Ward Pond's SQL Server blog
Throw Some SPARKs: Microsoft’s First Windows Embedded Hobbyist Competition
Posted
over 5 years ago
by
WardPond
0
Comments
I think contests are really cool, so I tend to blog about them here even when they’re not overtly SQL Server related. A little background.. back in March of this year, the Windows Embedded Group launched SPARK Your Imagination , the first hobbyist...
Ward Pond's SQL Server blog
Windows Live Messenger Translation Services Available
Posted
over 5 years ago
by
WardPond
1
Comments
I’m about three months late to the party on this, but in light of our previous forays into machine translation , I think it’s still worth mentioning. In my defense, this item just hit my in-box yesterday (don’t ask me about finding time to check my RSS...
Ward Pond's SQL Server blog
Happy Birthday, Dad! v84.0
Posted
over 5 years ago
by
WardPond
0
Comments
If it's December 4th, it must be my Dad's birthday .. After our move to Florida this past August, I'm living in the same time zone as my father and sister for the first time since we last lived under the same roof, which would be approximately 1984...
Ward Pond's SQL Server blog
Just What *is* the Current SQL Server Patch Level, Anyway?
Posted
over 5 years ago
by
WardPond
3
Comments
Courtesy of Ben Lam’s question and Arvind Shyamsundar’s answer comes the following list of resources for keeping up with SQL Server product update releases: You can sign up for security bulletin-related email alerts from Microsoft here (Windows Live ID...
Ward Pond's SQL Server blog
Database Versioning Demonstration Uploaded
Posted
over 5 years ago
by
WardPond
0
Comments
Fulfilling my promise at TechEd , I’ve finally completed a self-directed demonstration of the database versioning techniques I first presented at last year’s TechEd and which was alluded to during this year’s TechEd SQL Tricks presentations. It’s published...
Ward Pond's SQL Server blog
My Latest Reason to be Thankful
Posted
over 5 years ago
by
WardPond
0
Comments
In keeping with the spirit of the season, I thought I’d introduce you to my latest reason to be thankful. As if a wonderful family and an incredible career weren’t enough.. Ever since this city boy relocated to rural Central Florida, his farm girl...
Page 4 of 16 (394 items)
«
2
3
4
5
6
»