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

February

  1. 11
  2. 28
  3. 37
  4. 423
  5. 511
  6. 69
  7. 70
  8. 82
  9. 99
  10. 1015
  11. 117
  12. 124
  13. 139
  14. 140
  15. 151
  16. 168
  17. 176
  18. 189
  19. 195
  20. 207
  21. 212
  22. 220
  23. 235
  24. 247
  25. 258
  26. 269
  27. 2726
  28. 280
Home

  1. Configuring Reporting Service to use Host Headers for the Report Manager Website

    Ever tried to change the URL of the Report Manager in IIS using host headers? I did, but got the following error message when I tried to open the Report Manager: “The request failed with HTTP status 400: Bad Request” There is some extra configuration needed to make this work ...

  2. Configuring Reporting Service to use Host Headers for the Report Manager Website

    Ever tried to change the URL of the Report Manager in IIS using host headers? I did, but got the following error message when I tried to open the Report Manager: “The request failed with HTTP status 400: Bad Request” There is some extra configuration needed to make this work ...

  3. SQL 2008 - Compound Operators and Some FizzBuzz

    Another lesser known new feature in SQL Server 2008 is the ability to use Compound Operators.  Much like my post on Inline Variable Assignment this is yet another way for me to not type as much… perfect So Compound Operators take the place of the code that would look something ...

  4. UPDATE - ORDER BY and Deadlocking

    I was working on a deadlocking issue a few days ago at a client  The transaction that  was continuously getting deadlocked utilized three SQL statements to checkout and return rows from a queue for the client’s application.  Before going into the problem here’s a little code to setup ...

  5. Now syndicating Grant Fritchey and Scott Herbert

    The hits just keep comin’!  Here’s our new additions today: Grant Fritchey, the Scary DBA Grant, aka GFritchey on Twitter, is active in PASS and wrote the e-book Dissecting SQL Server Execution Plans.  I met him at the PASS Summit in Seattle, and yes, he is indeed scary.  He ...

  6. Key Lookup Threshold

    Gail talks about bookmark lookups…. err.. key lookups in this post. So are they good or bad? Well, like many things in SQL, it depends. The main factor is the number of rows returned. A few rows are fine but the cost rises sharply with larger result sets. There comes ...

  7. Create SQL Snapshot Backup to Document Change Process

    Let’s get the disclaimer out of the way right up front. This article is not intended to be used in place of a Production grade backup solution. It can be used in conjunction, with your regular backup rotation, but if you truly care about the database and its contents ...

  8. Row-Based Security

    In the first two installments of my articles on SQL Server security, I described server level roles and flexible database-level roles. This final article talks about row-based security, specifically row-based security using stored procedures. Why would you want to use row-based security? Well, there are a lot of situations where ...

  9. SSWUG Virtual Conference Presentations

    Once again I will be taking part in the SSWUG Virtual Conference on April 22-24th. I presented three topics last year and managed to make such a fool of myself that they asked me to come back again and do four talks this time. The talks I have on tap ...

Home

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