-
One year of blogging and trying to get out of my funk
It has been a little more than a year now since I started blogging. I started writing Sql Server related entries at http://blogs.sqlservercentral.com/blogs/haidong_ji/default.aspx. Shortly after that, I established this site, where I post all my blog entries. My purpose is simple: sharing my musings and observations, sharing my learning experience of various technologies, and keeping…
-
sp_who has a new column
For Sql Server DBAs, sp_who is an indispensable diagnostic tool for researching, monitoring, and troubleshooting. For example, you can use it to iterate through all sessions to a particular database, logins used, and host name where a session is initiated from, etc.. sp_who is modified slightly in Sql Server 2005. It now returns one additional…