Blog » Entries from 11/2009

2009

  1. J98
  2. F152
  3. M114
  4. A175
  5. M137
  6. J128
  7. J125
  8. A142
  9. S312
  10. O215
  11. N169
  12. D138

November

  1. 13
  2. 23
  3. 36
  4. 414
  5. 54
  6. 67
  7. 71
  8. 81
  9. 99
  10. 108
  11. 119
  12. 1220
  13. 136
  14. 142
  15. 152
  16. 169
  17. 1712
  18. 188
  19. 193
  20. 206
  21. 215
  22. 221
  23. 2310
  24. 245
  25. 255
  26. 261
  27. 273
  28. 280
  29. 290
  30. 306
Home

  1. SQL Saturday #34/New England Data Camp v2.0

    It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The New England SQL Server Users Group and the Southern New England SQL Server Users Group are again jointly hosting a full day of SQL Server goodness on January ...

  2. How do -you- install SQL Server? (Part 3)

    Welcome to this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Part 2 discussed security, playing around before doing a first install and smoke testing ...

    • Type: entry
    • 11/30/2009 at 12:20 PM
    • By Mike Walsh
    • 00 votes

  3. SQL 2008 R2 Utility Control Point (UCP) Videos

    While Playing around with the UCP inside of SQL 2008 R2 I found some videos to help you get started. The November CTP has six videos listed but only five of the links are currently working.

    Here is the splash screen you will see to help you get started:

    UCP_splash

    The ...

  4. SQL Server XQuery For Idiots


    I’m still struggling with learning XQuery. My latest little revelation was small, but vital.

    The difference between:

    @inXML.nodes('/rss/channel/item')

    and

    @inXML.nodes('/rss[1]/channel[1]/item')

    Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding ...

  5. TechNet WebCast: SQL Server Locking & Blocking


    Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here are the details:

    Event Overview

    A good working knowledge of how Microsoft SQL Server makes use of locking and transaction isolation levels can help you greatly improve an application ...

    • Type: entry
    • 11/30/2009 at 8:00 AM
    • By Joe Webb
    • 00 votes

  6. OPENXML can be a beast sometimes.

    Our application includes some search functionality which is pretty complex to deal with.  In a nutshell the user can select multiple values from a couple of lists on the website and use those listed to filter down the rows which are being searched.  These lists are passed into the SQL ...

  7. Have You Seen This Man?

    EDMPASS WANTS BUCK WOODY!!! When talking to Summit attendees the one name that comes up constantly or the one question that comes up is… “Did you get a chance to see Buck Woody present?” I did… and it was my first time.  It was the end of the day I believe on the Thursday… I would tell you [...]

  8. Ownership chaining or how to extend permissions without giving away the server

    The nightly process in our production system collects data from our real time systems (JD Edwards) and then processes that data.  Many of these process manipulate the data and supply a modified data set for use by the dozens of client processes and applications.  All of the client applications have ...

  9. Windows 2008 R2 Active Directory Enhancements

    What server upgrade would be complete without some Active Directory enhancements?  This release is no exception.

    One of the best enhancements (in my opionion) is that Active Directory now has a recycle bin.  It's something that needs to be enabled and has its own requirements before you can do ...

  10. The Sequels for SQL Server: The Week of November 27, 2009

    Just as an FYI, I’ve added one new slide deck and webcast to http://KevinEKline.com/Slides/, as well as quite a few upcoming user group events where I’m speaking in http://KevinEKline/Upcoming-Events/.

    I’m starting a new series called Sequels for SQL Server.  In this series ...

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.