Pulse » Recent Items from 5/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.
-
SQL Saturday #7 wrap-up
Finally back in my hotel room; I’ve forgotten how exhausting it is to actually present these days. John Baldwin and the rest of the Steel City SQL user group did an awesome job pulling this together. These guys are a lot of fun to be around, and they really ...
-
5:30 AM on a Saturday and I’m awake….
Obviously, I’m excited about SQL Saturday 7. I’ll post more after the festivities are over, but for now, I’m packing up and heading over. I love geek days.
-
Fine print: Removing single page allocations
Back in the days, Kalen Delaney blogged about how to remove single page allocations and how the algorithm changed from SQL Server 2000 to SQL Server 2005. However there seems to be some confusion when the single page allocations are kicked in. The confusion seems to be that single page ...
-
SQL Server 2008 Extended Events - high performance eventing system
I’ve written two articles on SQLTeam.com about a great new feature in SQL Server 2008 called Extended Events. They are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like ...
-
Contest: Name My Chicken
So in my first post I explained that my moniker was inspired by the rubber chicken hanging on the wall in my cube. After realizing that he's now become an integral part of the office in that we all squeeze him whenever something breaks its time he had a ...
-
It’s a major award
I try to shy away from humor in any of my posts because what I think is funny, others think is irritating or stupid (examples: I LOATHE Adam Sandler and I thought Hudson Hawk was funny. So there. I’m completely out of the main stream of America where comedy ...
-
User Groups Are Like Guilds…
(channeling “Forest Gump”)… you never know what you’re gonna get. Ack! Sorry, I just can’t help myself sometimes. Moving on… I was recently discussing guilds with my gamer husband and he commented how much running a user group sounds like running a guild. For those of you who ...
-
DBADiagnostics – My DBA Database
A couple years ago I started consolidating all of my DBA scripts into a portable DBA database that I could use for diagnostics (hence the silly name) and for maintenance scripts. To help me to continue to be inspired to update the database and to get some feedback, I plan ...
-
UPDATE Statements and Indexes
I ran into a database earlier this week with a lot of stored procedures that look like this: CREATE PROCEDURE updateUser @id INT, @FirstName VARCHAR(50), @LastName VARCHAR(50), @EmailAddress VARCHAR(50) AS SET NOCOUNT ON UPDATE Users SET FirstName = @FirstName, LastName = @LastName, EmailAddress = @EmailAddress WHERE id = @id GO ...
-
sp_WhoIsActive
For those who attended the webcast I did with Brent Ozar today, “Getting Started With SQL Server Management Studio,” here’s the link to Adam Machanic’s excellent sp_WhoIsActive stored proc: http://sqlblog.com/blogs/adam_machanic/archive/2009/03/30/who-is-active-v8-40-now-with-delta-power.aspx Thanks for attending!
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.