Pulse » Recent Items from 7/28/2011

Welcome!

Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.

  • Browse

    Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.

  • Vote

    Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.

  • Comment

    When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.

July

  1. 147
  2. 222
  3. 312
  4. 434
  5. 548
  6. 649
  7. 745
  8. 843
  9. 912
  10. 109
  11. 1155
  12. 1256
  13. 1362
  14. 1451
  15. 1536
  16. 1617
  17. 177
  18. 1848
  19. 1959
  20. 2052
  21. 2145
  22. 2237
  23. 238
  24. 247
  25. 2539
  26. 2633
  27. 2737
  28. 2855
  29. 2941
  30. 3014
  31. 3120

28

  1. 12 A1
  2. 10
  3. 23
  4. 31
  5. 40
  6. 51
  7. 62
  8. 71
  9. 81
  10. 90
  11. 103
  12. 112
  13. 12 P0
  14. 12
  15. 27
  16. 36
  17. 40
  18. 52
  19. 66
Home

  1. Marking FK Constraints NOT FOR REPLICATION

    When administering Merge Replication, sometimes we need to mark foreign key constraints NOT FOR REPLICATION. In some cases, we might require replication agent activity to be treated differently from user activity since we cannot guarantee the order of changes that are replicated. To be more specific, sometimes parent and child ...

  2. SSIS Logging and Auditing Framework

    Thank you for all of you that came out to my presentation at the Atlanta Microsoft BI user group, last Monday. We had a pretty good turn out, 40+. The slide deck can be found on the user group web site. http://atlantabi.sqlpass.org/Resources.aspx Here are the ...

  3. SSIS Logging and Auditing Framework

    Thank you for all of you that came out to my presentation at the Atlanta Microsoft BI user group, last Monday. We had a pretty good turn out, 40+. The slide deck can be found on the user group web site. http://atlantabi.sqlpass.org/Resources.aspx Here are the ...

  4. Activity Monitor and Profiler

    Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can be found here. I was looking at the script and thought it looked pretty cool and also wondered why it might ...

  5. SQL Server – "Denali" – Analytic Functions – LAG() and LEAD()

    LAG() function can be used to access data from a previous row in the result set without using a self-join. And it’s counterpart LEAD() can be used to access data from a subsequent row in the same result set. These functions are introduced in “Denali” as T-SQL functions, these ...

  6. T-SQL refactoring

    Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are being splitted, then joined together again, entities are often renamed several times just because you have better name for them etc. For me, renaming is heart of T-SQL refactoring. But ...

  7. T-SQL refactoring

    Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are being splitted, then joined together again, entities are often renamed several times just because you have better name for them etc. For me, renaming is heart of T-SQL refactoring. But ...

  8. How to move Cluster MSDTC Drive

    I recently had the need to move the MSDTC for a cluster to a new SAN drive.  It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive.  Let’s just walk through the basic steps. The first thing you need ...

  9. Meme Monday For August

    Next Monday is the first Monday of the month, which means one thing: Meme Monday! This time around we are looking for people to blog about the worst pieces of code they have seen. They can submit something written by themselves, by a coworker, or by a vendor (wink, wink ...

  10. HA vs DR, what’s it all mean

    People often get HA (High Availability) and DR (Disaster Recovery) mixed up.  There are a couple of reasons that this happens.  First is the fact that there aren’t any clear guidelines which separate the two.  There are standard terms which are used to help define HA and DR, but ...

Home

Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.