Blog » Entries from 5/27/2009

May

  1. 16
  2. 24
  3. 31
  4. 43
  5. 56
  6. 65
  7. 78
  8. 82
  9. 91
  10. 103
  11. 113
  12. 128
  13. 134
  14. 149
  15. 155
  16. 161
  17. 175
  18. 186
  19. 198
  20. 2010
  21. 218
  22. 226
  23. 231
  24. 240
  25. 250
  26. 264
  27. 277
  28. 282
  29. 298
  30. 302
  31. 311

27

  1. 12 A0
  2. 10
  3. 20
  4. 30
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 90
  11. 100
  12. 111
  13. 12 P1
  14. 10
  15. 20
  16. 30
  17. 40
  18. 53
  19. 61
Home

  1. Webcast Tomorrow!

    I’m excited to be doing a webcast tomorrow with the infamous illustrious Brent Ozar for Quest’s Pain-of-the-Week. The title is “Getting Started with SQL Server Management Studio,” and as you’ve probably gathered, it’s pretty entry-level stuff. If you read my blog, then chances are you don ...

  2. Spatial Data Hurts My Brain


    I’m still barely scratching the surface working with spatial data in SQL Server 2008. We’ve ported some of the data into a table where we built a geography spatial data column and we’re begginning to work with point data. The requirements from the developers are, so far ...

  3. AutoGrow Apparently Means “I Don’t Care”

    Well, at least that is the impression I have from Operations Manager. Let me explain why.

    It all started around the time we were making some adjustments to one of our servers that was not performing as well as our end users would have liked. The short end of that ...

  4. One quarter ago?

    Today at work we discovered that DATEADD can do date math involving quarters. Which, if you ask me, is pretty cool.

    In an effort to avoid work investigate this scenario, we started playing around with our calendar table and DATEADD.

    SELECT [DATE],
       DATEADD(q, -1, [DATE]) AS OneQuarterAgo,
       DATEDIFF(d ...

  5. PASS DBA SIG: Understanding the Default Trace

    Today during lunch was the monthly PASS webcast for the Database Administration SIG. This month’s topic was understanding the default trace and was presented by Jonathan Kehayias (BLOG Twitter). Jonathan did a great job as he very clearly explained the nuances of the default trace (i.e. what it ...

  6. EDMPASS Meeting Tomorrow #YEG #SQL

    http://edmpass.com/

    EDMPASS has it’s first meeting tomorrow evening.  It looks like we’re going to have a good turnout but do have room for a few more.  Below are the details:

    Date:  May 28th 2009
    Time: 5:00 pm - 7:00 pm
    Location: Stanley A. Milner library ...

  7. BeginRange and EndRange connection string properties

    Using the Timeout connection string property is a good way of making sure that your queries don’t run for too long, but sometimes – for example when you’re using SSRS – you want to restrict the amount of data that a query returns. You can’t properly do this with ...

Home

Get Syndicated on SQLServerPedia

Have you been blogging for six months or more? Want to see your own posts here on SQLServerPedia too? Follow these easy steps to increase your visibility in the community and attract more visitors to your blog.

  1. Create a Blog Category for Syndicated Posts

    Using your blogging software, create a new category for posts that should be syndicated on SQLServerPedia and add a few posts to it. (This allows you to keep off-topic posts from being syndicated.)

  2. Find the URL to Your Syndicated Posts Feed

    Most major blogging platforms will create a RSS or Atom feed for each category you create. On WordPress blogs, the feed can be accessed by appending /feed/ to the category page URL. On Blogger blogs, the feed for a label is at http://<yourname>.blogspot.com/feeds/posts/default/-/<categoryname>.

  3. Email Us with Your Feed URL, a Picture, and a Bio

    Once you're ready to set up syndication, send us an email introducing yourself. Include the URL to your feed, a headshot of yourself, and a short professional bio.