Blog » Entries from 9/24/2012

September

  1. 10
  2. 21
  3. 36
  4. 42
  5. 56
  6. 67
  7. 73
  8. 80
  9. 90
  10. 106
  11. 118
  12. 128
  13. 133
  14. 147
  15. 150
  16. 160
  17. 1710
  18. 182
  19. 195
  20. 207
  21. 217
  22. 221
  23. 230
  24. 243
  25. 256
  26. 264
  27. 275
  28. 286
  29. 290
  30. 301

24

  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. 20
  16. 31
  17. 40
  18. 50
  19. 60
Home

  1. SQL Server: Part 3 : Approaching Database Server Performance Issue

    In the last post, we have discussed the script to list the sessions which are waiting for resource or currently running. In this post let us see how to list the blocking sessions with required information.   ******************************************************************************************/CREATE FUNCTION [dbo].dba_GetStatementForSpid(     @spid SMALLINT  )  RETURNS NVARCHAR(4000)  BEGIN     DECLARE @SqlHandle BINARY(20 ...

  2. Heavy Heart

    About 12 years ago I sat down with a couple of the guys that I work with. We had an in depth discussion about starting a User’s Group in Colorado Springs, I am not sure if we knew how big it would get, or what we really expected. But ...

  3. TechEd Australia 2012 videos online

    Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free!  Get your learning cap on.  Check them out here.

  4. More SSMS Tips

    I've written in the past about some of the ways you can configure SQL Server Management Studio to help you make your life a bit easier. I've discovered two more little tricks I thought I'd pass along. Every DBA has a handful or more of T-SQL scripts ...
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.