Pulse » Recent Items from 9/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.

2009

  1. J112
  2. F198
  3. M123
  4. A221
  5. M162
  6. J170
  7. J132
  8. A151
  9. S345
  10. O228
  11. N179
  12. D141

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
Home

  1. Free Training in October at the Quest Connect vConference

    Quest Connect is back… and bigger than ever!  Quest Connect 2009 will take place October 21 – 22, beginning at 9 a.m. British Summer Time/4 a.m. Eastern/1 a.m. Pacific and will accommodate all time zones. This is a 24-hour virtual event covering topics across Quest Software ...

  2. SSIS – Performing An UPSERT

    For those of you who may be wondering what the heck an UPSERT is, an UPSERT is an UPDATE and INSERT into a given table. Typically, an UPSERT operation requires two separate transactions. Usually, the first transaction issued is the UPDATE and then the INSERT is issued shortly after. In ...

  3. SQL Lab Adventure: Phase I

    It seems that I may be able to free some time from my schedule. To fully utilize this “spare” time, I am planning to go all the way to tech blogging! My plan to build a home-brewed test SQL Server lab is already in place. I have a couple of ...

  4. Mike’s Rule: Know Thy Data

    At my former employer, I was hired to do database application support. I spent my first two weeks working with Debbie, our trainer and business analyst. I learned all about our project management system and met the key players. In retrospect, that was one one of the best things I’ve ...

  5. MidnightDBA News - Podcasts, new DBAs@, and Snacks

    MidnightDBA is in iTunes!!  We're getting all the videos published in batches. So far we have something like a couple dozen videos out there, and we'll catch up in very short order. I also just published a three-part DBAs @ Midnight video from this week: Working From Home (Part ...

  6. Recovering a deleted SQL Job

    A user wanted to recover a SQL job that had been deleted from the agent. We do backups of MSDB, of course, but how would you actually recover the job definition? Thanks to ServerFault and user squillman, we used the following technique. Restore a copy of MSDB (we used MSDB_old ...

  7. SQLSaturday 25 October 10, 2009 – Final Stretch!

    Less than two weeks until SQLSaturday 25, and I have lots of stuff to wrap up; however, there’s been some exciting stuff happening in the last couple of weeks. Attendance is up! Attendance – Planning to Attend: 95  (as of today) New Sponsor! Interworks, Inc has really stepped up to ...

  8. Monitoring Log File Growth using PerfMon

    There are lots of ways to monitor data file and log file growth, but my favorite method is to set up a perpetual Counter Log in Windows Perfmon. The SQLServer:Databases object contains the following counters (among others): Data File(s) Size (KB) Log File(s) Size (KB) Log File ...

  9. Get index fragmentation statistics

    I recently attended a Pittsburgh SQL Server user group meeting where Brent Ozar gave a presentation on the silent performance killer. This motivated me to create a stored procedure that could leverage the DMVs in SQL 2005/2008 to gather index fragmentation statistics for all databases on a given server. Goal ...

Home

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