Blog » Recent Entries

  1. M111
  2. A192
  3. M152
  4. F151
  5. J145
  6. D107
  7. N158
  8. O173
  9. S114
  10. A165
  11. J223
  12. J188
  13. M120
  14. A154
  15. M182
  16. F165
  17. J199
  18. D172
  19. N108
  20. O232
  21. S252
  22. A333
  23. J279
  24. J266
  25. M222
  26. A223
  27. M272
  28. F234
  29. J288
  30. D235
  31. N320
  32. O252
  33. S213
  34. A217
  35. J231
Home

  1. Security Questions: Differences between “Grant” and “With Grant?”

    As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I ...

  2. I’m presenting at the PASS Summit!

    I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October 14-18.  It’s amazing to think that, although I have been in IT for 25 years, I first started to build my brand when I started this blog ...

  3. Using Scoped Assignments To Show Calendar and Financial Year-To-Date Values In The Same Calculated Measure

    I’ve had a lot of requests for more MDX content on my blog, so here’s something I’ve been meaning to write up for a long time: a worked example of how to use scoped assignments to implement two different types year-to-date calculation on two different hierarchies in ...

  4. Business Objects on Linux and SQL Server

    This is just a quick post to share a lesson learned while I was on an engagement where the client’s reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doing a test to move the underlying data warehouse from another database platform to ...

  5. Is Your Code an English Garden or Ikebana?

    Erika loves having fresh flowers around the house. Every Saturday morning, I pick up a bouquet at a farmer’s market or grocery store and put it in a vase for her. I’m slowly upping my game by learning more and more about the art of arranging flowers. When ...

  6. The Journey is the Reward: Speaking for SQLPass, where do you start?

    I'm heartened by the numbers of people who are expressing an interest in speaking at events. In particular, I understand that SQLPass had record numbers of people submitting to SQLPass Summit in Charlotte this year. For me, this is especially important because it suggest that more people are interested ...

  7. Big Data for the Business Intelligence Professional SQLPass Summit Preconference Day

    I'm delighted to announce that Allan Mitchell (blog ¦ twitter) and I are giving a Big Data for the Business Intelligence Professional preconference session at SQLPass Summit 2013 in Charlotte, NC.What will we be covering? What does Big Data mean for business intelligence professionals? Come see the “whats,” “hows ...

  8. Database index design and optimization: Some guidelines

    Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response time. In the meantime, poorly designed indexes, such as missing or excessive indexes on tables, indexes placed on the wrong column or inadequate index maintenance strategies, can be ...

  9. SQL Server Transactions and Locking (Part 1)

    In many situations, data modification requires several steps. For example, you may need to change the values ​​in two separate tables. You can use transactions to complete these two operations as a unit, or if an error occurs, does not change any of the tables. Another key consideration is that ...

  10. Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)

    The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP solution for your organization, you must ensure that the components of your OLAP solution, including relational data warehouse databases and multidimensional cubes, are designed to meet the business needs of ...
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.