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

16

  1. 12 A0
  2. 10
  3. 20
  4. 30
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 90
  11. 101
  12. 110
  13. 12 P1
  14. 12
  15. 20
  16. 30
  17. 40
  18. 51
  19. 61
Home

  1. What the devil?

    The devil you know vs. the devil you don't. A good friend of my told me about an issue she recently came across. It seems that a particular group of admins implemented SQL Server database mirroring in order to implement a kind of relatively cheap high availability solution. It ...

  2. SQLSaturday #25 – big news!

    Just a quick post to announce a couple of cool developments that are happening for SQLSaturday #25 in Gainesville, GA, Oct 10. We’ve got 75 attendees registered!  I was really worried about the low turnout, but I’m feeling a lot more comfortable with it now.  One of the ...

  3. Upgrading from SQL Server 2000 to 2005

    This is part one in a series of upgrading from SQL Server 2000 to SQL Server 2005. The first question I want to address is why would you want to upgrade in the first place. It’s important to know why you are doing something if you are going to ...

  4. Upgrading from SQL Server 2000 to 2005

    This is part one in a series of upgrading from SQL Server 2000 to SQL Server 2005. The first question I want to address is why would you want to upgrade in the first place. It’s important to know why you are doing something if you are going to ...

  5. The Age-Old SELECT * vs. SELECT 1 Debate

    There is a certain look that T-SQL Developers get when they see SELECT * used in production code. In the span of a couple seconds, you’ll see a slight tic develop in their left eye, and you’ll hear little whimpering sounds coming through their nose, which is quickly followed ...

  6. Monitoring Process for Performance Counters

    Recently I needed to create a process to monitor performance counters over a short period of time. We were going to implement a change and we wanted to compare performance before and after to see if there was any impact. To do this, I first created a couple of tables ...

  7. Indexes and Convert_Implicit

    When you are designing your where clause to access data from a given set of tables it would benefit you to pay careful attention to the data types of the columns you will be using.  SQL Server tries to help out by implicitly converting between data types which can cause ...

  8. SQL 2008 CMS Security

    So we’ve recently adopted the use of SQL Server 2008’s Central Managment Server for our development team.  Something that tends to get missed or not talked about in articles about CMS is the security required to connect and view the Central Management Server. There are 2 MSDB database ...

  9. Lesson Learned: Why is my tlog backup huge at 5AM?

    As a DBA, I find myself learning new things all of the time. I was looking at the transaction log backups of one of my servers recently and saw something incredibly odd. Most of my transaction log backups are in tens of megabytes. But the backup at 5:00 AM ...

Home

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