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
sql server 2008
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
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
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
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
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
Don't Forget! SQL Server 2008 Web Chat On Thursday, March 13
I wanted to mention this one more time, since my previous post on this topic suffers from a cryptic title.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008. The web chat starts here at 11 am Pacific Daylight...
12 Mar 2008
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
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
Database Programming: The String Concatenation XML Trick, Revisited
UPDATED 27 February 2009 for spelling I’ve got to pay more punctual attention to my comment pool.. RBarryYoung’s movingsql.com will be on my blog roll shortly after I get this posted (second attempt; first thwarted by a laptop hang. I have suspended unit testing of SQLRAP 2.5 changes until I’m...
27 Feb 2009
Earth Day Linkfest
TechNet magazine has released a web-only “Green IT” edition as a companion piece to Mark Pohto’s recent white paper and article in The Architecture Journal. The issue features a valuable collection of new and archived articles on energy efficient computing, including: · Framework for Building a “Hyper...
22 Apr 2009
Microsoft Knowledge Base Articles Moving to TechNet and MSDN
Word today from Christopher Kilborn over at Port 80 that, as part of a larger initiative, Microsoft is relocating much of its Knowledge Base library. The money quote: Microsoft is moving its Developer & IT Professional primary support content (also known as Knowledge Base – or KB - articles...
18 Feb 2009
See You Even More In Barcelona: Two Additional Chalk Talk Sessions Added
I'm pleased to report that the organizers of TechEd have scheduled repeat offerings of two of my sessions (so much for my earlier belief that the schedule was finalized *grin*): Set-Based Thinking for the T-SQL Developer: Insights from Microsoft IT will also be presented in Room 132, 3:45pm-5pm...
27 Oct 2007
Paul S. Randal Posts Some Sobering Statistics
Paul’s name should be familiar to denizens of the SQL Server blogosphere. Along with his wife, Kimberley Tripp , he’s a principal of SQL Skills (home also to the redoubtable Bob Beauchemin , with whom I share a birth date of significance to SQL Server aficionados); given that his history includes authorship...
14 Mar 2009
Database Versioning Demonstration Uploaded
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 here on my resource page at MSDN Code Gallery...
1 Dec 2008
Donald Farmer's "Improvements In SQL Server 2008 Analysis Services" At 11am PDT
The meeting is here . Hope to "see" you there.. -wp
17 Aug 2007
Paul S. Randal Has Another Important Survey
Paul ’s latest survey is a deep dive into the physical layout of your databases. It’s the same basic question, for four different size categories of database: what’s the physical layout of your database, and why? Paul will publish the results on 24 April, so please respond before then! -wp ...
12 Apr 2009
La Font de Canaletes Works Its Magic
La Font de Canaletes is a public fountain near the head of La Rambla de Catalunya in what it currently the center of Barcelona, Spain: When I was in Barcelona last November, I reported that I "drank generously from the fountain, hopefully sealing my fate." The fate to which I referred...
27 Sep 2008
SQL Server 2008 Datetime LiveMeeting At 11am PDT
You can get to the meeting here . Hope to "see" you there.. -wp
21 Aug 2007
SQL Server 2008 LiveMeeting Recordings
If you were unable to make last week's SQL Server 2008 webcasts, fear not; the recordings have been posted on LiveMeeting.com: SQL Server Katmai June CTP: Analysis Services - Dimension Design SQL Server Katmai June CTP: Change Data Capture The session for Star Joins is currently ongoing....
19 Jun 2007
Five Things About sp_.. (okay.. Four Things and a Closing Argument)
Celebrating the first day of Summer with the first technical post on the blog since mid-Winter (apologies for my absence).. Jens has a great post regarding the internal behavior of various forms of sp_-named programmability objects. Some SQLRAP-related research led me to take a different tack, and...
22 Jun 2010
A Gift From Jens and Jimmy
Two Microsoft folks frequently featured in this space, Microsoft Certified Masters Jimmy May and Jens Suessmeyer , have joined forces to bring to the world SQLIOSimParser, a tool to parse and interpret the XML output of the Bob Dorr’s SQLIOSim testing tool. Jimmy says Jens did most of the heavy lifting...
29 Sep 2009
Second Shot with a Side of Career Assist: Just What the Doctor Ordered
In light of the current state of the economy (not to mention recent news in my own back yard (I can still call it that since we continue, against our deeply held wishes, to own a house in Redmond)), I make it a point to count my blessings every day. A loving and supportive family is primary among...
6 Feb 2009
See You At Microsoft Tech·Ed North America 2008 Developers!
Happy news this week that I'll be traveling to Orlando, Florida the first week of June to attend and present at Microsoft Tech·Ed North America 2008 Developers June 3-6 at the Orange County Convention Center . I'll be revisiting the three presentations I made last November in Barcelona.. Data Modeling...
27 Mar 2008
© 2014 Microsoft Corporation.
Privacy & Cookies