Blog » Entries from 9/29/2010

September

  1. 17
  2. 25
  3. 38
  4. 42
  5. 52
  6. 611
  7. 77
  8. 87
  9. 912
  10. 108
  11. 113
  12. 122
  13. 138
  14. 1420
  15. 1511
  16. 1612
  17. 177
  18. 184
  19. 192
  20. 2011
  21. 2110
  22. 224
  23. 238
  24. 242
  25. 253
  26. 261
  27. 2711
  28. 287
  29. 2910
  30. 308

29

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

  1. SQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts

    Since I started the monthly round up of the blog post, I have received many positive feedback. I plan to continue doing this month refresher every month now. This rounds ups are my mirror and informs me what I have been doing whole month. Here is quick look at the ...

    • Type: entry
    • 9/29/2010 at 8:30 PM
    • By Pinal Dave
    • 00 votes

  2. SQL Server 2008 SP2 released

    Few minutes back, I read on Aaron Bertrand’s blog that SQL Server 2008 SP2 has been released.

    It is ready to be downloaded from here and the list of bugs that are fixed in this SP2 are documented here. The version after installing SQL Server 2008 SP2 is full ...

  3. SQL Server 2008 SP2 Released

    SQL Server 2008 SP2 has been released and I must be living under a rock because I had no idea it was coming.

    Fellow SQL blogger (and Canadian) Aaron Bertrand broke the news on his blog here

    Link to the Service Pack

    Link to the bugs that are fixed in ...

  4. How to Prove a Fact (Again)

    Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about a common theme I’ve been seeing lately: Proving facts to ignoramuses*.

    How to Prove Facts to the Unbeliever

    1. State the fact.
    2. Explain the fact.
    3. Restate the fact. [Realize ...

  5. Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild

    Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can be done: drop the existing indexes first then create new ones or execute a create statement with the DROP_EXISTING = ON option. At face value it may appear that SQL Server ...

  6. Kansas City, Pork, and Performance Tuning

    What do all three of those things have in common? Here’s a hint: it’s me!

    That’s right, this weekend I will be at SQL Saturday #53 in Kansas City. I am especially looking forward to the BBQ crawl on Friday afternoon followed by the Royals game that ...

  7. Cannot create Maintenance Plan after 2005 SP3 install

    Yesterday I came across a question in one of the forums. The user was unable create any Maintenance Plans after installing SQL Server 2005 SP3. When tried to create one, SSMS would throw the below error.

    Invalid column name 'from_msx'
Invalid column name 'has_targets'

    This usually happens when the service ...

  8. Smoking SQL Mirror

    The Rant

    I had someone vehemently insist on a conference call that you could not mirror more than one user database.  Although that alone is worthy of a blog post to clear up the misconception (I’ll explain the confusion in a minute), what I really wanted to talk about ...

    • Type: entry
    • 9/29/2010 at 10:38 AM
    • By Ryan Adams
    • 00 votes

  9. Savepoints: The Other Other White Meat

    Most T-SQL guides and tutorials I’ve seen concentrate on the following transaction commands: BEGIN, COMMIT, and ROLLBACK, which I’ll henceforth refer to as the “big three”. While they’re certainly very important, there’s also a fourth command, SAVE, which is typically treated like a distant cousin who ...

  10. The Lone Ranger And Data Integrity

    Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the Lone Ranger stands to protect the unsuspecting townsfolk from the wayward derelicts that plagued the American frontier. He also ate bacon three meals a day.

    Like the Lone Ranger, IT ...

    • Type: entry
    • 9/29/2010 at 6:54 AM
    • By Joe Webb
    • 00 votes

  11. Updated missing index dmv script

    One tool I have in my toolbox is the great missing index script from Bart Duncan. However for me there were a few things I wanted to tweak to make it a better tool. I needed just the absolutely relevant information and I needed away to cut my time spent ...

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.