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: 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...
  • 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: 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...
  • Blog Post: 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", presented by Erik Veerman of Solid Quality...
  • Blog Post: 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. If you'll be at PASS and you're reading this message...
  • Blog Post: 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 Avalanche . We had over 200 people show up for a spirited...
  • Blog Post: SQL Server 2008 R2 August CTP Available for Download

    If you’re interested in the next release of SQL Server, the BI-focused SQL Server 2008 R2, you’ll be pleased to know that the August CTP is available for download here for MSDN and TechNet members. Here’s the skinny from the download page: SQL Server 2008 R2 expands on the value delivered in SQL Server...
  • Blog Post: An Update For Cousin Tom: Classroom Stories, Business Intelligence, and Career News

    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 Microsoft Certified Architect OLTP/Ranger certification...
  • Blog Post: Two Pieces of Technical News from Kalen

    Kalen Delaney has one of the most consistently informative SQL Server blogs in all of the Internets, and unless I miss my guess, it was also she who left the first of the very supportive comments I've received in the wake of my recent series of personal posts. Thank you, Kalen, and everyone else for...
  • Blog Post: Data Warehousing: A Open Note To Cousin Tom

    Dear Tom, It's been almost three weeks since you wrote. I've been real busy with work and summer and everything, so I haven't had a chance until now to do the thinking I need to do to answer your questions. You do remember your questions, don't you? It's been that long? Okay.. My company...
  • Blog Post: As Spring Approaches, a SQL Blogger’s Thoughts Turn to Daylight and Baseball

    As we progress towards the Ides of March, one of my best friends-who-I’ve-never-met, Jimmy May , notes our annual transition to Daylight Savings Time , in a post he generously concludes with a link to one of this very blog’s oldies but goodies . In his blog’s title, Jimmy humbly refers to himself...
  • Blog Post: Microsoft BI Conference 2007: Days 2 and 3

    As the great John Lennon once said, "life is what happens when you're busy making other plans." I had hoped to spend all of Thursday and most of Friday at the BI Conference, but some late-breaking issues at work pulled me away from the two Thursday afternoon sessions I was most interested in. I'll have...
  • Blog Post: Lubor Offers a Wonderful Synopsis of Partitioning

    One of the best parts of my current job is that the email distribution lists I'm on allow me to be a "fly on the wall" for some very interesting, educational conversations. Terry started this one off by asking a question: I’ve heard it recommended that the number of partitions for an OLTP table...
  • Blog Post: 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 been so incredible that it's been moved to a bigger...
  • Blog Post: New To SSIS? Come Take A Guided Tour..

    One of the more interesting and perhaps challenging aspects of a SQL Server 2000 to SQL Server 2005 upgrade is the migration from DTS to SSIS for ETL (Extract-Transform-Load) activities. SSIS isn't an upgrade of DTS, but is in fact an entirely new, and greatly enhanced, component. While it's possible...
  • Blog Post: Business Intelligence Is *Not* An Oxymoron

    One of the wonderful things about my new position is that it provides a far different perspective on SQL Server than my old gig did. There's certainly great honor in building OLTP systems, but there's also a lot more going on in the world! Apropos of this dawning realization, a very interesting notification...
  • Blog Post: Log Buffer #118: a Carnival of the Vanities for the DBA

    UPDATED 16 Oct 2008 to fix a broken link. UPDATED 10 Oct 2008 to reflect Giuseppe's comment . Welcome to installation #118 of Log Buffer , the weekly review of database blogs. Today, we’re gonna party like it’s 1999 ! For those of you who might be new to this little corner of the Internets,...
  • Blog Post: A Blog You Should Know About (If You Don't Already)

    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, Sanjay Mishrah, Lubor Kollar, Michael Thomassy, Tom...
  • Blog Post: 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 was the primary architect of the SQL Server 7.0 storage...
  • Blog Post: CTP4 Of PerformancePoint Server 2007 Available For Download

    The fourth and final CTP for PerformancePoint Server 2007 is now available for download here . Those of you into BI scorecarding should definitely go get it! -wp
  • Blog Post: Microsoft BI Conference 2007: Day 1

    As I mentioned yesterday , I'm attending the inaugural Microsoft BI Conference at the Washington State Convention and Trade Center in downtown Seattle. There are over 2600 people in attendance. In addition to the "canned" presentations, there are a number of chalk-talks (no PowerPoint allowed!) and Partner...
  • Blog Post: One Little Thing I Missed..

    ..while we were preparing for our move.. The company chose my 48th birthday (two days before the movers descended on us) as the RTM date for SQL Server 2008.  There's a full download available here (subscription required); the free Express version is available here . There are so many new features...
  • Blog Post: Just What *is* the Current SQL Server Patch Level, Anyway?

    Courtesy of Ben Lam’s question and Arvind Shyamsundar’s answer comes the following list of resources for keeping up with SQL Server product update releases: You can sign up for security bulletin-related email alerts from Microsoft here (Windows Live ID and Windows Live Alerts account required). ...
  • Blog Post: Another Blog You Should Know About (If You Don't Already)

    I posted last Friday urging you towards a blog offering from the SQL Customer Advisory Team. Today, I'd like to point you at another brilliant blog . Tips, Tricks, and Advice from the SQL Server Query Processing Team offers "tips, tricks, advice and answers to freqeuently-asked questions in a continued...
  • Blog Post: Networking Opportunity: See You At The Microsoft BI Conference!

    In the midst of week three of our third SQL Ranger rotation, I'm going to take a powder for three days and attend the first-ever Microsoft BI Conference at the Washington State Convention Center in downtown Seattle for the rest of this week. I'll be posting daily during and/or after the conference...