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
A Blog You Should Know About (If You Don't Already)
Posted
over 7 years ago
by
WardPond
2
Comments
As I mentioned my last letter to my cousin, we just finished up the first week of our SQL Server Microsoft Certified Architect OLTP/Ranger certification training. In our first week's technical sessions alone, we've heard from Don Vilen, Carroll Moon,...
Ward Pond's SQL Server blog
An Update For Cousin Tom: Classroom Stories, Business Intelligence, and Career News
Posted
over 7 years ago
by
WardPond
1
Comments
Hey there cousin.. It’s been almost two months since we discussed data warehousing here. I apologize for the long delay since my last correspondence. It’s been a very busy time here; we’ve been preparing the first offering of our four-week SQL Server...
Ward Pond's SQL Server blog
An Email From BillG
Posted
over 7 years ago
by
WardPond
0
Comments
Yesterday was the last day of the annual Microsoft Giving Campaign Auction, and tomorrow is the last day of the Giving Campaign as a whole. An all-employee email from Bill Gates reminding us of this latter fact provides some fodder for reflection. In...
Ward Pond's SQL Server blog
The Bloo Is No More.. Long Live The Blog!
Posted
over 7 years ago
by
WardPond
1
Comments
You might recall I mentioned a little rendering problem I was having after the recent software upgrade. Scott Watermasysk of Telligent sent along a magic piece of CSS that resolved the issue -- he even put it on the site himself! Drop a comment if...
Ward Pond's SQL Server blog
IE7 Is Here!
Posted
over 7 years ago
by
WardPond
0
Comments
This morning, the English version of Internet Explorer 7 for Windows XP was released to the web; it's available for download here . There are myriad improvements over IE6, of which tabbed browsing is just the most obvious. Were I you, I would certainly...
Ward Pond's SQL Server blog
Better Living Through Tags?
Posted
over 7 years ago
by
WardPond
0
Comments
One of the new features of our recently updated Telligent Community Server software is expanded support for tagging of blog entries. Of course, this feature does little good for you, the reader, unless your humble blogger undertakes to actually tag their...
Ward Pond's SQL Server blog
A "Kobiyashi Maru" On The Prime Number Front?
Posted
over 7 years ago
by
WardPond
2
Comments
No less a figure than Louis Davidson has weighed in on the Prime Number Challenge . I left a comment on his blog last week which has yet to be published, so I'll respond to Louis here. Here's the salient part of Louis' post: A friend blogger...
Ward Pond's SQL Server blog
From Dad's Bookshelf: More On Prime Numbers
Posted
over 7 years ago
by
WardPond
3
Comments
I'm in western Vermont until Wednesday morning, totally off the grid except for a 56K dialup connection which seems much slower. I'm visiting my father and sister, and I found an item that follows right along with the prime number conversation we've been...
Ward Pond's SQL Server blog
Database Programming: Something Simple That, LIKE, ESCAPEd Me Until Now
Posted
over 7 years ago
by
WardPond
5
Comments
There's no rocket science in this post, just a neat little piece of syntax which has been around for awhile and yet had managed to escape my awareness until Ning asked a really interesting question that I thought I knew the answer to: How do you...
Ward Pond's SQL Server blog
Database Programming: Prime Number Methodology
Posted
over 7 years ago
by
WardPond
2
Comments
Rob Farley 's back with two comments in regard to my prime number methodology: Ward - how do you justify having the 'initial fill of sieve' in your tweak of Hugo's? If you pull that stuff out (as per my first post ), it takes much longer. Rob (...
Ward Pond's SQL Server blog
Welcome To My Bloo! I'm Afraid I Must Be Going For Awhile..
Posted
over 7 years ago
by
WardPond
4
Comments
UPDATE: Please note that the issue discussed below pertains only to web-based page views, not RSS or Atom feeds Well, the software upgrade we were expecting last week finally went through earlier yesterday morning. Other than some subtle changes...
Ward Pond's SQL Server blog
Database Programming: A Prime Number Contender From Down Under
Posted
over 7 years ago
by
WardPond
6
Comments
Denis' Prime Number Challenge just won't die. I think this topic has spurred more dialog than any other in this blog's 15-month, 180-odd post history. Just imagine if I could've harnessed this global outpouring of SQL skills for something with commercial...
Ward Pond's SQL Server blog
Technical News: Windows Vista September EDW Now Available
Posted
over 7 years ago
by
WardPond
0
Comments
I spent my lunch hour today upgrading my laptop from Windows Vista RC1 to the latest EDW (External Developer Workstation) build, build 5728. You can get the new build in the following languages: English German Japanese I've been running...
Ward Pond's SQL Server blog
Database Programming: Closing The Door On The "Discredited" Prime Number Tangent
Posted
over 7 years ago
by
WardPond
4
Comments
One more PDA-incompatible post: lessons learned from "discredited" prime number syntax...
Ward Pond's SQL Server blog
Database Programming: Sunday Night Prime Number Update
Posted
over 7 years ago
by
WardPond
3
Comments
Our blogging site is going to go dark in an hour or so for a software upgrade, so I won't be able to post my full findings tonight. What I can say is that, based on the current "rules of engagement" (i.e., the timer starts when the tables are populated...
Ward Pond's SQL Server blog
Database Programming: Denis' Prime Number Challenge: A New Leader
Posted
over 7 years ago
by
WardPond
12
Comments
Well, folks, there's a new sheriff in town.. this is a continuation of a conversation here and here . I've tweaked Hugo's syntax to further filter the initial seive population (similar to the pre-filtering present in the discredited tangent ). Where...
Ward Pond's SQL Server blog
Database Programming: Denis' Prime Number Challenge: Fourth Place Finisher
Posted
over 7 years ago
by
WardPond
6
Comments
Hugo Kornelis posted a wonderful reply on his blog to the Prime Number Challenge, which runs in 9.3 seconds on my laptop. Denis posted his solution in a reply on Hugo's blog ; Denis' solution runs in 6 seconds . WOW! Perhaps this isn't such a crazy...
Ward Pond's SQL Server blog
Database Programming: Denis' Prime Number Challenge
Posted
over 7 years ago
by
WardPond
10
Comments
I answer Denis' challenge with another post to refrain from downloading to your mobile device....
Ward Pond's SQL Server blog
Database Programming: Set-Based Update -- Hugo's Syntax Outperforms Shaun's; Ward Tweaks Hugo's Syntax Even Further
Posted
over 7 years ago
by
WardPond
6
Comments
A long post continuing last night's discussion regarding the generation of 1M GUIDs. I'm not sure I'd download this one to your PDA......
Ward Pond's SQL Server blog
Database Programming: Game, Set, Match -- Why Writing Code In Transact-SQL Is Different Than Writing In A Compiled Language
Posted
over 7 years ago
by
WardPond
4
Comments
More tidbits from an internal discussion.. it'll take us awhile to get to the answer to the titular question; hopefully you'll find this a worthy journey. Mike asked, in a nutshell, why this batch is taking so long to run: SET NOCOUNT ON DECLARE...
Ward Pond's SQL Server blog
Welcome Back, Peter Gammons!
Posted
over 7 years ago
by
WardPond
0
Comments
I haven't subjected you to a baseball post in awhile . Don't worry, I'll be brief.. I can't let the day pass without noting that the great Peter Gammons has returned to his nonpareil column (link requires subscription) on ESPN.com after his health...
Ward Pond's SQL Server blog
Made In Express Contest Winners Announced!
Posted
over 7 years ago
by
WardPond
0
Comments
Yes, the winners are in ! The Made In Express contest has announced its Grand Prize , First Prize , and Community Choice award winners. Congratulations to Ernie Hall , Ali Khalid , Jonas Martinsson , and Sanchez Roman Canlas !
Ward Pond's SQL Server blog
Database Programming: Everything You Always Wanted To Know About JOIN Semantics, But Were Afraid To Ask
Posted
over 7 years ago
by
WardPond
1
Comments
Every once in awhile, I get an opportunity to look around for new and interesting things to read. With the emphasis my new position places on building world-class training resources for SQL Server types, I'll be spending even more time on this sort of...
Ward Pond's SQL Server blog
Five Years On
Posted
over 7 years ago
by
WardPond
0
Comments
As a wide-eyed boy from Long Island, I watched them go up . As a jaded middle-aged man a continent away, I watched them fall down . Never forget .
Ward Pond's SQL Server blog
Database Programming: Sergey Offers Another FOR XML EXPLICIT Syntax For Steve
Posted
over 7 years ago
by
WardPond
3
Comments
If you've worked with databases long enough, you develop a set of truisms that you carry around in your head. One of mine, related to building T-SQL syntax, is, "there are at least 87 ways to skin any particular cat." While we're still 85 methods short...
Page 12 of 16 (394 items)
«
10
11
12
13
14
»