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.
December
-
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 ...
-
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 ...
-
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 ...
-
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 ...
-
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 ...
-
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 ...
-
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 ...
-
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 ...
-
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 ...
-
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.