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)

November, 2006

  • See You At PASS!

    This news has been in the works for a couple of days, but it was only just this morning that everything came into focus.. There are two pieces of news to share: one is that I will be in attendance at next week's 2006 PASS Community Summit in Seattle...
  • Database Programming: A Decrypter For Omni

    This post will conclude (for me and for now, at least) a discussion begun here and continued here and here . When last we spoke, I was searching for a SQL Server 2000-specific decrypter for Omnibuzz . Well, I've got one. It might be a tad over-engineered...
  • Database Programming: SET Statements and Dynamic SQL

    What's this, you say? Useful T-SQL making a return to this blog? Yep. The first T-SQL I've posted since we were in the midst of the prime number exercise , over a month ago. The first commercially viable T-SQL I've posted since the end of August ....
  • Database Programming: (Almost) A Decrypter For Omni..

    Omnibuzz saw my comment (I left another one over the weekend and it showed up right away; I wonder if the ones I left previously were eaten by some flavor of the issue I ran into trying to leave a comment here) and left two comments . Omni's first...
  • Database Programming: Omnibuzz Steals A Saturday Night..

    I first encountered Omnibuzz during the recent prime number mania. His contribution to that exercise introduced me to his blog, which I must confess that I initially perused only lightly. Tonight, a chain of links led me back to his blog and I explored...
  • SQL PASS 2006: Breakfast Panel Venue Change

    From a personal perspective, I somewhat " buried the lead " in my last post , so here it is again in a post of its own.. The response to Quest Software 's breakfast panel seminar, The Growing World of SQL Server: Surviving The Data Avalanche , has...
  • 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...
  • 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
  • Research Begets Enlightenment: The SSMA Downloads

    This time, it was me asking the question, on behalf of one of my classmates in BI training this week: Is anyone aware of an automated Access-SQL to TSQL conversion tool for stored procedures? Frankie answered: You can try SSMA for Access...
  • Living The American Dream

    Just a quick note that as of 5:06pm yesterday, Gale and I closed on our house. Rumor has it we are now living the American Dream. If the American Dream involves a mortgage the size of a cruise ship anchor, then we're there.. I'll keep you posted.....
  • DWWTWT? November 14

    Today's commuting obligation and alternatives were the same as yesterday: to get to downtown Seattle for SQL PASS for an 8:30 call via either the MG or the Sound Transit 545 bus. Today was another victory for social responsibility: ...
  • No More HTML For This Database Geek?

    A couple of weeks ago , you might recall, I mentioned that I'd added a couple of new web-based search tools from Windows Live to the left-hand menu of the blog. Well, as you might've noticed, they're gone now. It turns out that the Windows Live...
  • SQL PASS 2006, Day 4

    Another day at the SQL PASS 2006 Community Summit , and my education continues on more axes than I would've thought possible. The day started very early, with Quest Software 's breakfast seminar, The Growing World of SQL Server: Surviving The Data...
  • Home For The Holidaze..

    After over a month of working pretty ridiculous hours, I'm going to take the rest of the week away from work to celebrate our good fortune with my family. Other than some automated DWWTWT? posts, I expect the blog to pretty much remain quiescent until...
  • SQL PASS 2006, Day 2

    Greetings from the last break of the second day of preconference seminars from SQL PASS 2006 . Since my primary goal in attending this week is to get up to speed on BI issues, today I'm attending a seminar called, "Enterprise ETL with Integration Services...
  • New Blog Features, With A Caveat: Beware Of Database Geeks Writing HTML

    This post doesn't apply for you aggregate surfers; those of you who come to http://blogs.technet.com/wardpond , please read on. If you look closely, over at the left hand side of the bloo .. er, I mean, blog .. over on the left hand side of the blog...
  • DWWTWT?: November 27

    This week sees me in "SQL Server 2005 Business Intelligence Bootcamp," offered up in Bellevue for the week by SQLSoft . Since I did so well riding the bus to SQL PASS before the holiday, I'm exploiting the Metro Transit 232 (express) and 233 (local) routes...
  • DWWTWT?: November 30

    The month comes to an end with a return to meteorological normalcy (light rain, temperatures in the high 30s to low 40s) as well as Day 4 of "SQL Server 2005 Business Intelligence Bootcamp," offered up in Bellevue for the week by SQLSoft . While the postulated...
  • DWWTWT?: November 29

    Day 3 of "SQL Server 2005 Business Intelligence Bootcamp," offered up in Bellevue for the week by SQLSoft , saw me back on the chained-up Metro Transit 232 bus: Telecommuted: 4 Walked: 71 Walked to...
  • Vaya Con Dios, Old Friend..

    Here's another piece of news I got last week.. this one of a sadder variety than my PASS plans .. Last week's inbox brought the unhappy news that John Huschka is leaving Microsoft . While I will miss John as a long-distance colleague and friend (to...
  • 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...
  • DWWTWT?: November 16

    In attempting to assess this morning's possibilities, yesterday I said: [I]f anything goes wrong in the morning I'll have to ditch the bus and fire up the MG . Well, nothing went wrong (if you don't count designing a day where I needed to get...
  • DWWTWT?: November 28

    Day 2 of "SQL Server 2005 Business Intelligence Bootcamp," offered up in Bellevue for the week by SQLSoft , coincided with a bit of a weather event here in the Seattle area. Today, the Metro Transit 232 was chained up, making for a suboptimal but ultimately...
  • SQL PASS 2006, Day 5

    The SQL PASS 2006 Community Summit wraps up this afternoon. The entire conference has run very smoothly; the organizers and volunteers should be very pleased with themselves. I got here this morning just in time for David Ca mpbell's keynote. David...
  • DWWTWT?: November 20

    A very short work week got off to a fine start -- my first "long walking commute" in almost a month , and I actually spent the day in my office rather than in a classroom or a convention hall: Telecommuted: 4 Walked...