Pulse » Recent Items from 9/11/2009

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.

September

  1. 17
  2. 29
  3. 37
  4. 45
  5. 52
  6. 63
  7. 73
  8. 815
  9. 914
  10. 1039
  11. 1112
  12. 123
  13. 134
  14. 1412
  15. 1517
  16. 1610
  17. 1715
  18. 1814
  19. 191
  20. 202
  21. 2112
  22. 2212
  23. 2318
  24. 2412
  25. 2512
  26. 265
  27. 278
  28. 2816
  29. 2924
  30. 3032

11

  1. 12 A0
  2. 11
  3. 20
  4. 30
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 91
  11. 100
  12. 111
  13. 12 P1
  14. 13
  15. 21
  16. 31
  17. 40
  18. 52
  19. 60
  1. SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2

    This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool ...

  2. Documenting servers

    I'm starting to create a Run Book (not my term, but I don't remember where I heard it) to store all documents relating to the databases and their servers I'm responsible for. That list is growing, and before it gets out of hand I'd like to create a template of ...

  3. Fun With Percentiles, Part 2

    In Part 1, we talked about how to calculate a value V for a given percentile p in a given set of numbers. We looked at the mathematical formula that Excel uses for its PERCENTILE() function and then put together some T-SQL scripts that used those formulas.In this blog ...

  4. BINGO!!!

    Let’s talk about Alerting. Alerting is like a nice fun game of BINGO.  When a new ball is pulled and the announcer yells out “Under the B… 6″ if everyone stood up at the same time and yelled “NO BINGO” and the one person who needed B6 yells out ...

  5. Non-Unique, Non-Consistent Data Returns From sys.dm_db_index_operational_stats

    I’ve run across an interesting (and by interesting I mean annoying) issue as of late with persisting data from the sys.dm_db_index_operational_stats.  This DMF (Dynamic Management Function) returns information concerning how existing indexes are being utilized by the SQL Server 2005 and newer instance.  It contains granular I/O ...

  6. MidnightDBA feels pretty! Oh so pretty!

    So you may have noticed that MidnightDBA looks a bit different.  Quite a bit prettier, and a little big uglier.  This week we pushed our upgrade...tah-dah!!  The site is still a little rough, and we'll be putting in big work this weekend.  BUT, the new site features some ...

  7. Running a Server Side Trace

    This is part two of three part series on creating, running, and scheduling Server Side Traces in SQL Server. Part I, Scripting Server Side Traces, was posted on August 31, 2009. Part III will be posted soon. SQL Server Profiler can bring your production server to a screeching halt In ...

  8. Automating DBA Tasks

    A member of my user group recently asked me about the best practices for monitoring and automating database maintenance. Automate Everything If I do something once, I automate it. I learned this valuable lesson at last year’s PASS Summit during a panel discussion. Any time I find an error ...

  9. Dear Vendor

    A lot of application vendors try to do things that will make managing their application easier for customers who lack an IT staff. I seriously doubt they make it that much easier. Unfortunately, there is something called unintended consequences, and they frequently make their applications harder for those of us ...

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