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)

Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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. ...
  • Blog Post: 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
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Donald Farmer's "Improvements In SQL Server 2008 Analysis Services" At 11am PDT

    The meeting is here . Hope to "see" you there.. -wp
  • Blog Post: 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 ...
  • Blog Post: 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...
  • Blog Post: SQL Server 2008 Datetime LiveMeeting At 11am PDT

    You can get to the meeting here . Hope to "see" you there.. -wp
  • Blog Post: 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....
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...