Blog » Entries from 6/2010

June

  1. 15
  2. 23
  3. 34
  4. 47
  5. 50
  6. 61
  7. 76
  8. 87
  9. 96
  10. 108
  11. 112
  12. 122
  13. 134
  14. 143
  15. 156
  16. 169
  17. 178
  18. 184
  19. 192
  20. 203
  21. 2111
  22. 227
  23. 237
  24. 2412
  25. 256
  26. 266
  27. 273
  28. 2812
  29. 2911
  30. 308
  1. Building A Remote Desktop Manager Cluster List

    The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a cluster management perspective. I’ve previously blogged about Building A Remote Desktop Manager Connection List from the SQL Server Central Management Server (CMS) tables. The RDCMan use case for cluster ...

  2. Building A Remote Desktop Manager Cluster List

    The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a cluster management perspective. I’ve previously blogged about Building A Remote Desktop Manager Connection List from the SQL Server Central Management Server (CMS) tables. The RDCMan use case for cluster ...

  3. Now on SQLPASS, “Can Integrity Be Learned?”

    Ok, I admit it.  I’ve done about as good a job publicizing my monthly professional development column, Plays Well With Others, as NBC did when the transitioned Jay Leno back to the Tonight Show.

    So I’m going to try to better, henceforth and forever more!  Two entries ago ...

  4. SQL University – Database Design/Development Week

    Welcome back to another installment of SQL University. This week we will be talking about a topic that is often overlooked: database design. On second thought, “overlooked” may not be the correct choice. I think a more accurate description would be NULL. That’s right, I just said that database ...

  5. One of these things is not like the other

    I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later, if I get it to work) and I wanted to try out different scripting tools to build it. I started with PrimalScript from Sapien. It’s slick. It’s ...

  6. Detangling Nested Views

    I hate nested views. I hate them, I hate them, I hate them. This is the Nth shop I have been in that makes use of one view that pulls FROM and JOINs other views, which in turn pull from other views, and it’s foot-stompingly frustrating to work with ...

  7. The Politics of SQL Server Performance

    Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL Server platform but have you ever stopped to consider the wider implications of your actions?

    As a SQL Server Database Administrator you are responsible for the overall health ...

  8. SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts

    Last month I wrote monthly round up and I was very well received. For the same here it goes this months wrote up for all the SQLAuthority.com blogs.

    The month started very interesting subject of SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision which lead to few datetime ...

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

    Have you ever wanted to grant a user account the ability to execute permissions in a database without having to worry about maintaining object level permissions? Maybe we should back up a bit… When you have an account that needs to read data only, it is easy enough to add ...

  10. Did You Just Ask Me What I Did This Weekend?

    Before I answer that question, let me first respond to a different question:

    “Michael, Could you show us an image that tells us how much you’ve written, while simultaneously reminding us what-state-of-the-art graphics was like in the early nineties?”

    Why certainly!

    100th Blog Post

    100th Blog Post

    I’ll wait ’til the ...

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.