Blog » Entries from 1/26/2009

January

  1. 12
  2. 23
  3. 30
  4. 41
  5. 53
  6. 65
  7. 73
  8. 81
  9. 96
  10. 102
  11. 112
  12. 122
  13. 133
  14. 145
  15. 154
  16. 162
  17. 174
  18. 181
  19. 193
  20. 202
  21. 213
  22. 222
  23. 234
  24. 243
  25. 252
  26. 265
  27. 279
  28. 284
  29. 292
  30. 308
  31. 312

26

  1. 12 A0
  2. 10
  3. 20
  4. 30
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 90
  11. 100
  12. 110
  13. 12 P0
  14. 11
  15. 21
  16. 32
  17. 40
  18. 50
Home

  1. Search Cache For Execution Plans

    Sometimes when I am working with clients I need to take a look at execution plans for different stored procedures.  Rather than digging around with SQL Profiler or executing the stored procedures with what I think might be the parameters I like to '”return to the source”.

    Now I feel ...

  2. How to Become a Microsoft SQL MVP

    So this past weekend I got myself an xbox 360 so that I could hook into my Netflix to watch movies instantly. At the same time I decided to ditch my TiVo as well as my old DVD player. So, a consolidation of sorts in terms of hardware, remotes, and ...

  3. New Vendor Interview with an "annoying" DBA

    A while back a conversation on Jonathan Kehayias' former blog (he has moved) gave me an idea for this post.

    Once you have been a DBA for any length of time, you will encounter the situation of a new vendor coming in with software that has a database back end ...

    • Type: entry
    • 1/26/2009 at 7:46 PM
    • By Mike Walsh
    • 00 votes

  4. SQLBits IV voting now open

    We've now closed session submission for SQLBits IV, which will be taking place on March 28th in Manchester. Once again we've had a great response and it's now time to vote for which of the 83 submitted sessions you'd like to see; to do this you ...

  5. Grant EXECUTE Permissions on all Stored Procedures to a Single User

    I have to run similar code on a regular basis, so I thought I would share it with everyone.

    Basically, it grants access on every stored procedure that meets a certain naming pattern to a single user.

    
-- I've updated this with Aaron Bertrand's suggestions from the comments.
-- Thanks ...

  6. COPY_ONLY Backups

    In SQL 2005 a COPY_ONLY option became available for backing up your databases.  What COPY_ONLY does is take a backup (full or t-log) without affecting the backup/restore cycle.  This is a great new feature as quite often DBAs are asked for an out of sequence backup to be taken ...

  7. Apress Alpha Program


    Apress has a new program called Alpha where they make available books in progress. You can download, for a price, an e-copy of some of the chapters of the book for early review. It allows you to get in on the action a bit and you can post comments to ...

  8. Retrieve the top X random rows from a query

    Let’s suppose for a minute that you want to retrieve the top x number of rows from any given query. Keep in mind that x is a value that your users can supply.

    Sure, you could do string concatenation and EXEC sp_executesql ‘SELECT TOP ‘ + @count + ‘ x FROM y;’. But ...

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.