Article Ideas, specifically on SQL Server 2008

June 23, 2008 at 7:58 am (Misc, SQL Server 2008) (, , )


I’m trying to come up with some ideas for an article (or six) on SQL Server 2008. I know I’m getting about 40 views a day on this blog. That must translate to about 20 users (the statistics on this site aren’t clear, so I’m guessing). Do any of you have any good questions about new functionality in SQL Server 2008? I’ve been thinking about looking at sparse columns and filtered indexes or maybe the spatial data types. Those are the topics I’m most excited about as a database developer and designer. If I think about it in terms of being an admin, policy management, the data collector, and those types of new functionality are very interesting. I’m not even sure what’s new in the BI space.

So, if you’re one of twenty people reading this, leave a comment. What interests you? What concerns you? If you’re interested in something, I’m pretty sure more people are.

5 Comments

  1. V.M. said,

    Don’t write what other people want to read. Write what you want to write. Readership will follow… :-)

  2. Derek Comingore said,

    Hi Again,

    Each role (DBA, Dev, BI) has their ‘key’ features in each new SQL Server release and certainly SQL Server 2008 is no different. For BI (my area), the following new features are ‘key’ to me (off the top of my head):
    -Change Data Capture
    -AMO Warnings
    -MERGE
    -Backup/Restore Enhancements in SSAS
    -Attribute Relationships in SSAS
    -Data Profiling Task in SSIS
    -SSRS Dundas Integration, HTTP.SYS usage (no IIS req’d), overal new server architecture…Word Rendeder too I guess

    As a side note, having written several articles allready on SQL 2008 here are some side ideas/topics which dont seem to get enough coverage:
    -SSAS/SSIS/SSRS upgrade & migration
    -Deprecated Features & Discontinued Features, see my short post on this at http://weblogs.sqlteam.com/derekc/archive/2008/06/06/60618.aspx

    Cheers
    Derek

  3. scarydba said,

    To V.M.

    Yes. Absolutely. But I’m interested in what others are seeing and what questions they have. That can help drive where I go. For example, I saw a number of people asking how to deal with large execution plans. Since this is something that I did all the time, I decided to quantify a lot of what I did and that became an article. I wouldn’t have thought of writing the article until I saw the questions. That’s the type of thing I was going for.

  4. scarydba said,

    Hello Derek,

    Thanks for the comment. That is some useful information.

    CDC is pretty cool for the transactional side of things too. Same thing with MERGE. I’ve heard buzz that says you guys on the BI side of things are the biggest winners with the 2008 release.

  5. Jack Corbett said,

    I’d be interested in sparse columns. I have read a little on them, but a nice article with some examples and why I’d need them would be great.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: