Pulse » Recent Items from 7/27/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.
-
Deadlocks explained ...
... in comic form! You either get it or don't. BTW, I've got a new appreciation for Hagar the Horrible's creator. Michael Swart
-
Find All Logins With VIEW SERVER STATE Permissions
Having survived my deep dive into Dynamic Management Views and Dynamic Management Functions in Microsoft SQL Server I thought it would be interesting to do a few posts here on some of the side issues that arise with use of these objects. One thing to stress about usage of the ...
-
SQL Server 2005/2008 Querying Hierarchal Data
SQL Server 2005 introduced a new query construct that has the look and feel of a derived table, but offers much more. This new construct is called a CTE or common table expression. CTEs allow developers to name result sets and can directly query the name set, as if it ...
-
SQL Server Consolidation, Part Trois
I wrote a couple of posts previously on SQL Server consolidation. The first post tried to give some insight on some of the problems and associated motivating factors that most companies have for consolidation efforts. The second post was an attempt to cover some of the decision factors that could ...
-
SQL SERVER – 2008 – Design Process Decision Flow
I was recently invited by a company that is primarily using other RDBMS as their primary database for solutions. It was a different experience for me, as I am used to having pretty good SQL Server Smart crowd in my presentations, but this time there were smart people but no ...
-
A Big Shout Out to all SQL Webcasters Out There
I just want to take this time to say “WOW” to all the great and even the not so great SQL Webcasters out there. It is amazing the time and effort that goes into doing a webcast and feeling happy with the final product. Tieing the powerpoint with the Management ...
-
SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model
In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility. Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.