Blog » Recent Entries

  1. F107
  2. J182
  3. D156
  4. N102
  5. O225
  6. S230
  7. A326
  8. J270
  9. J265
  10. M219
  11. A221
  12. M271
  13. F234
  14. J288
  15. D234
  16. N320
  17. O250
  18. S212
  19. A217
  20. J228
  21. J173
  22. M178
  23. A194
  24. M231
  25. F171
  26. J167
  27. D136
  28. N169
  29. O215
  30. S311
  31. A141
  32. J125
  33. J128
  34. M136
  35. A175
Home

  1. Database Mirroring Failover Considerations

      Database mirroring is a great option for many disaster scenarios. If using a witness server automated failovers can be achieved.  However, just like any other disaster recovery solution database mirroring should be tested.  Before you execute your first test of failing over a database from one server to another you ...

  2. 2012 MVP Summit Preview

    Next week I will be attending the 2012 Microsoft MVP Summit. This will be my third Summit but it feels like my first because there are going to be a lot of new faces there for the first time. That’s why I wanted to take the time to remind ...

  3. Want Another Reason to Hate iTunes?

    I’m not one to whine.  Really.  I’m totally not a whiner.  However, I’m going to sound like one with this statement… I fricken HATE iTunes. There, I said it.  I’m already starting to feel better. Playing on Elisebeth Barrett Browning and her fantastic poem, “How do ...

  4. SQL Server 2012 (“Denali”): FileTable

    FileTable is a new feature in SQL Server 2012 that is built on top of SQL Server FILESTREAM technology, which allows BLOB data to be stored as individual files separate from a database’s data files.  Interactions with the FileStream files took place only through T-SQL or through code which ...

  5. SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video

    We got tremendous response to our very first video of SQL in Sixty Seconds #001 and SQL in Sixty Seconds #002. We talked about how to convert Subquery to CTE and Error and Reaction. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips ...

  6. Julie Presents SSIS 2012 A Fresh Start in Columbia

    Thanks for attending tonight. Here is the link to the slidedeck.

  7. SSIS Script Component Source -- Proc/Select Stmt

    I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations.  I had to build one moments ago and realized I am tired of looking back through my presentations to build them.  Here is a sample script that ...

  8. Using the MDX Script Debugger in BIDS

    Almost every time I write MDX calculations, I end up using scoped assignments – it’s by far the easiest way to control where your calculations work inside a cube. However making sure that your scoped assignments work in the places that they’re meant to work and don’t overwrite ...

  9. Support me and Team #SQLPlunge for the Special Olympics

    On March 3, 2012 I will be jumping into a hole in the ice in Lake Calhoun to raise money for the Special Olympics. One item on my bucket list will be crossed off – I don’t think I want to get good at this, but I do want to ...

  10. Still Using Windows Logins for your Databases? You’re Doing it Wrong

    If your DBA is still adding Windows logins to your database servers then they are doing it wrong. Using logins (versus Windows groups) is an inefficient method that hasn’t been considered a favorable practice for almost ten years. Oh…sure…it works. I won’t argue that point. 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.