Pulse » Popular Items from 4/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.
-
Refresh Your Views With sp_refreshview
With SQL Server 2008 R2 having been released it seems like a good time to remind people about the sp_refreshview system stored procedure. How are those two things related? Great question. When migrating or upgrading to newer versions (such as R2), you need to be aware that a simple restore ...
-
How to Tell When SQL Server Started?
As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to me by the client. They don’t mean any harm, but different people in the organization have different perspectives and different memories. Sometimes it is difficult to know what is really ...
-
Listen Up! I’m on the Virtumania Podcast
Pause that Lady Gaga for a minute and head over to Virtumania. It’s a casual, hour-long conversation podcast that usually focuses on virtualization and storage. This week, I’m along for the ride with:Rich Brambley (Blog – @RBrambley) – virtualization blogger who syndicates with the PASS Virtualization Virtual Chapter Marc Farley ...
-
Submitting a Winning Abstract at PASS
For those who couldn’t make today’s presentation, or those who could but want to hear Tim Ford and Buck Woody trashing Wisconsin, I’m pleased to share with you both the slides and the recording of today’s presentation. Or rather, two recordings. The Powerpoint The Presentation Submitting a session to the ...
-
SQL 2005 System Stored Procedures Poster
Just over two years ago I helped put together the following poster that detailed some of the more useful system stored procedures found in SQL 2005: I have a handful of the posters laying around my cubical and my office at home. I suppose I should give them away whenever ...
-
Fear and Loathing in the Blogosphere – A plagiarism primer
Last year my better half, Tim, suggested that we start a blog. It made sense for any number of reasons, but it scared the heck out of me. I couldn’t imagine that there was anything that I could ever blog about that hadn’t already been posted and probably ...
-
Playing For High Stakes
Yes, we use T-SQL to manage and manipulate data for multi-billion dollar enterprises, but every now and then we need to take some time for some recreation.And I don’t mean “lie around on a Hawaiian beach sipping a Mai-Tai” kind of recreation… I’m talking about something more cerebral.We’re going to ...
-
Oracle DBA Year One
About a year and a half ago, I took a position managing the SQL Server and Oracle DBA teams. I find myself gravitating towards Oracle just because there is a lot to learn. So what have I learned? Oracle smashes SQL Server and visa versa. It all depends on your ...
-
Using Model to Change Default Database Settings
During a Twitter conversation today Malik Alamin (Twitter) asked about the Autogrow settings on his databases. The conversation naturally progressed to the question of how you change the default behavior and set all newly created databases to have user defined settings. Brent Ozar (Blog | Twitter) was able to point ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.