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

10

  1. 12 A1
  2. 11
  3. 22
  4. 30
  5. 42
  6. 51
  7. 60
  8. 72
  9. 80
  10. 90
  11. 100
  12. 110
  13. 12 P2
  14. 12
  15. 22
  16. 315
  17. 41
  18. 52
  19. 61
Home

  1. Object Explorer Details in 2008 SSMS

    One of the things I love most in SQL 2008 SSMS is the way Microsoft redid the Object Explorer Details page. Now it shows some really useful information. You can change what columns display by right-clicking on the column bar and checking which columns you want to see.

  2. Reporting Service "features"

    I've been a proponent of Microsoft's SQL Server Reporting Services (SSRS since 2005) since it was first released in beta for SQL 2000. I thought the product was a natural, combining a report writer with the database. I especially loved the ease of deploying individual reports. The first ...

  3. Getting data into a page header in SSRS

    As I've mentioned before, we're moving MS Access97 reports to SSRS 2008. Recently I came across another issue, repeating data in a page header. You may or may not know it, but you can't directly add a data field to a page/report headers and footers. If ...

  4. Moving a reporting database

    Another task I just finished in regards to SSRS was moving the reporting database. We have an older server we were using for developing the report on. The system team gave us a virtual server (we're going to run virtual when we go live). I wanted to copy the ...

  5. SQL Servings 2009-09-10 11:26:17

    One of the first things you'll probably notice is the Surface Area Configuration Tool, introduced in SQL 2005, is not there. Actually it's still part of the server, only its moved. Now you access it by connecting to the server using the Management Studio, right clicking on the ...

  6. Start with the basics when troubleshooting

    Recently I began troubleshooting an issue on one of our servers. The issue is that the alerts I set up for jobs and on the server itself weren't sending emails to the operator I configured. This was happening for a while but I never had time to look at ...

  7. How to change the display name of mail sent with DB Mail

    Recently I had a manager complain that emails from some of our SQL 2005 servers were displaying different "From" aliases. These emails were being sent via DB Mail in jobs that were on all servers. I thought all the servers were configured the same; the same email account was being ...

  8. Replaying traces with SQL Profiler

    One of the projects I've become involved with at work has been the virtualization of our regional databases. However, when we hooked up a copy of one of the databases in a virtual environment we noticed a huge performance degradation, mainly in regard to CPU usage. The only part ...

  9. Replaying traces, Part 2

    When I left off, I was discussing using SQL Profiler to replay a trace taken on a production server on different test boxes with different configurations. The end result is to see if we can virtualize our production OLTP database servers. Our next step in testing was to test replaying ...

  10. Replaying traces, Part 3

    I had a few surprises when I began replaying a production workload on a virtual server. I'm using the same workload I captured from a production server and replayed on a physical server in different scenarios. The first virtual test was on a 32 bit server hosted on a ...

Home

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