See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
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)
Software Release Announcements
SQL Server 2000
SQL Server 2005
SQL Server 2008
T. Alexander Pond
TechEd Developers 2008
Browse by Tags
Ward Pond's SQL Server blog
Greetings From SQL PASS!
At the moment, I'm on my first break of my first morning of my first PASS, and so far it's all been good. I rode the Sound Transit 545 bus in from Redmond and was deposited two blocks from the Convention Center. The preconference session on my agenda today is called "Microsoft Business Intelligence...
13 Nov 2006
IE7 Is Here!
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 take these bits out for a spin. Enjoy! ...
19 Oct 2006
Throw Some SPARKs: Microsoft’s First Windows Embedded Hobbyist Competition
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-focused program for this exciting technology. ...
6 Dec 2008
SQL Server 2005 Service Pack 1 QFE Rollup Released
The most recent set of fixes for SQL Server 2005, the Service Pack 1 QFE Rollup, is available for download here . The linked page currently includes instructions in seven languages as well as links for downloading all of the updated components. You'll also find a list of the hotfixes included in the...
23 May 2006
Feedback is a Gift; Thanks, Kalen!
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. It was decidedly not what I was looking for...
30 Dec 2008
Career Development?: What a Day Dad Had!
BY WAY OF INTRODUCTION and FULL DISCLOSURE: I don’t usually pass my blog entries by my boss before I post them, but I rarely blog so directly about the details of my work experiences. For that reason, and because he and our team figure prominently in this story, I have done so in this case. Therefore...
27 Jan 2007
Finally, An Answer (and a mea culpa) For Adam Machanic
I've once again been frightfully neglectful of this blog, as the holidaze, shifting work assignments, and the occasional personal event have combined to render me a poor custodian. The good news is that I've got a backlog of tidbits to share. Before we get started with those, though, I'd like to respond...
9 Feb 2006
A Note From Binh's Customer
Binh Cao's customer left a comment on yesterday's post on global temp tables. Here's the money quote: My research confirms that global temp table does allow the plan to be shared among processes. However now we are forced to deal with the problem of ownership of data within the global temp table...
26 Sep 2008
Database Programming: A More Performant Alternative To COLUMNS_UPDATED()
(updated 18 February 2006 to clarify version information) A recent discussion with several colleagues reminded me of a hard-won insight I've been meaning to share here. This involves the code that we originally discussed here . I know the following to be true for SQL Server 2000. I've not tested the...
16 Feb 2006
R.I.P. Tun-Hsu "Martha" McCoy -- and Thank You!
Every once in awhile, you get a piece of news that sets you looking at where you are and where you've been. Today is one of those days. There will be no technical content in this post, and it might ramble some. Bear with me; it's been a contemplative night.. =-=-=-=-=-=-=-= When I was a young...
9 Apr 2008
Database Programming: Sunday Night Prime Number Update
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), I believe I've got the execution time of the...
25 Sep 2006
Issue 18 of The Architecture Journal Now Available
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. The focus of Journal 18 is Green Computing. ...
15 Jan 2009
Database Programming: Prime Number Methodology
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 ( new SQL MVP , by the way!) Like... just populate...
4 Oct 2006
SQL Server 2008 Table Valued Parameter Webcast
The webast for Table Valued Parameters is currently ongoing, and is well worth your time. Database developers should be salivating for this feature! Check out the end of the webcast now.. when the links to the recordings for this week's sessions are up, I'll post them here. -wp
22 Jun 2007
TechEd Developers 2007 Barcelona: Day 4
Another busy day here in Barcelona. I started this morning by heading to La Rambla de Catalunya in the center of the old city. I wanted to visit La Font de Canaletes . Local legend has it that visitors that drink from this fountain will someday return to Barcelona. I confess I was expecting a running...
9 Nov 2007
Loading An XML Document Into SQL Server: Another OPENROWSET Trick
Have you ever had an XML document in a file that you needed to get into a database column quick-and-dirty? Well, another OPENROWSET trick is ready to come to our rescue. Up until I was shown this trick, every time I needed to import XML into a data column, I'd load up a copy of the XML in SQL Server...
8 Mar 2006
Strange Bedfellows? Branson Offers Hawking A Boost
Stephen Hawking wants to go to space. Via Virgin Galactic , Richard Branson wants to help. Read this . It's pretty remarkable. -wp
1 Dec 2006
CTP 6 of SQL Server 2008 Is Now Available For Download
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 evaluating multiple policies simultaneously, and...
21 Feb 2008
SQL PASS 2006, Day 3
Networking, I'm user friendly Networking, I install with ease Data processed, truly BASIC I will upload you, you can download me - Networking , Warren Zevon and Stefan Arngrim Today is the third day of my trip to the SQL PASS 2006 Community Summit , and the first day of the conference proper. It...
16 Nov 2006
Database Programming: A Prime Number Contender From Down Under
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 potential.. J Rob Farley has two posts on his...
30 Sep 2006
TechNet White Paper on SQL Server Virtualization Now Available
Great news today from Mark Pohto: the TechNet White Paper SQL Server Consolidation at Microsoft has just been posted. You can download a Microsoft Word document here , or read it on-line here . In addition to being one of the world’s leading experts on SQL Server operations, Mark is a fine human being...
12 Mar 2009
Cross-Database Connectivity: An Answer For Kyle
Kyle Schoonover, a former colleague in MSIT, posed the following questions in a comment on October’s cross-version database attachments post : Ward, I'm currently working in MySQL and writing conversion scripts to convert a MySQL database to a SQL 2005 database. I have also been using OpenQuery...
8 Nov 2008
The Microsoft Certified Master Programs Have Joined the Blogosphere
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 source of information, but this morning there’s...
22 Jan 2009
Database Programming: Why I, Like, May Never Write Another LIKE, Like, Ever Again
[ UPDATE 30 October 2007 : There are significant ambiguities in this post which are addressed in the comments and in this follow-up , which I recommend reading after you've read this post and its comments. -wp] I've been doing some performance tuning work over the last couple of days, and I've found...
21 Oct 2007
Better Living Through Tags?
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 posts. I've gone through the contents of the...
19 Oct 2006
© 2014 Microsoft Corporation.
Privacy & Cookies