Pulse » Popular Items from 12/23/2010

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.

23

  1. 12 A26
  2. 128
  3. 29
  4. 37
  5. 421
  6. 510
  7. 620
  8. 717
  9. 87
  10. 919
  11. 1017
  12. 1128
  13. 12 P37
  14. 135
  15. 239
  16. 346
  17. 446
  18. 550
  1. The 12th day of SQL

    My Christmas tree is like this post; short, easy to assemble, and a little tacky. So, at the first FreeCon, a bunch of writers gathered together and talked about stuff. Most of the stuff we talked about was how to be a better technical writer, as well as how to ...

  2. Does sp_executesql Handle Batch Separators (i.e. GO)?

    The answer is no, but I saw something interesting when I was finding out (sometimes a one minute experiment is more effective than looking up behavior on books online). I ran the following: EXEC SP_EXECUTESQL N'select 1 go select 2 go' Now, before reading further try to guess what ...

  3. Modifying SSRS Rendering

    In my last post I outlined how to remove a rendering format from the report manager by modifying the “rsreportserver.config” file. Another useful configuration to the “Render” element is the ability to add rendering formats. Consider a report that renders in the report manager like this: All is well ...

  4. What should Developers know about SQL Server?

    Back at Tech Ed 2010 a good friend Robert Cain (blog | twitter) and I were wondering the exhibit hall floor and we got stopped by the guys from the Deep Fried Bytes pod cast and they asked us if we’d be willing to sit down a record a pod ...

  5. Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ]

    On Tuesday our Monitoring Tool sent out this notification about a SQL Server 2005 instance. Error: 26050, Severity: 17, State: 1. Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due to a failure. Error: 0xe8, state: 4. The server will automatically attempt to re-establish listening. The instance ...

  6. PASS Summit Speaker Evals – THE ANALYSIS

    Rule: No Sushi with Adam within 24 hours of session I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 ...

  7. PASS Summit 2010 Survey Results

    As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit. Feedback is a gift. I received a great many gifts this year and I’m extremely happy about all of them. There are a set of questions with ratings ...

  8. Filling in Data Potholes with Recursive CTEs

    Data: it can break your foot. Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of ...

  9. Filling in Data Potholes with Recursive CTEs

    Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero. In thinking about this problem this ...

  10. New Trace Events in SSAS2008 R2 CU5

    Greg Galloway has just pointed out to me a new KB article outlining some major improvements/changes to trace events that are coming in CU5 for SSAS 2008 R2: http://support.microsoft.com/kb/2458438/ This represents part of the new monitoring functionality that will be coming to SSAS in ...

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